4
Shopping Cart
Home
(current)
Our Services
Shared Hosting
Corporate Hosting
WordPress Hosting
VPS Server
SiteLock
NORD VPN
Website Backup
Website Builder
SEO Tools
Professional Email
Hire Professional
Social Media Services
SSL Certificates
Domains
Register A Domain
Transfer Domains to Us
Domain Search
Pages
Domain
Support
Affiliate
SSL Certificate
Site Lock
Contact
Login/Register
Categories
0
Account & Billing
1
Career
4
cPanel
8
Domain
4
Email
6
Hosting
1
Nameservers
1
PHP
3
Softaculous
3
SSL/TLS
3
Task & Earn
1
Website Backup
7
WordPress
Categories
Account & Billing
(0)
Career
(1)
cPanel
(4)
Domain
(8)
Email
(4)
Hosting
(6)
Nameservers
(1)
PHP
(1)
Softaculous
(3)
SSL/TLS
(3)
Task & Earn
(3)
Website Backup
(1)
WordPress
(7)
Tag Cloud
earn
Make money
lytehosting
Make money on social media
earn and post
post
domain
Nameserver
Lytehosting Nameserver
Wordpress
MySQL
Wordpress error
cloudflare
cname
email
ox app suite
smtp
appsuite
blogger
namecheap
Connect a Domain Name from Namecheap
Connect a Domain Name
Connect a Domain Name from Namecheap to Lytehosting
SSL
FREE SSL
CPANEL
career
internship
.edu.ng
install
softaculous
DNS management
Domains
Client Area
Error 500
Hosting
Reseller Hosting
php
php versions
SSL/TLS
SSL Certification
HTTP
HTTPS
Emails
Email Account
Password
Addon Domain
phpMyAdmin
Folder
Directory
SSL Certificate
Shared Hosting
VPS
Dedicated Hosting
WordPress Hosting
Installation Backup
Backup
Delete Backup
Password & Security
MySQL Database
User
File Manager
How to Import a MySQL Database There are various ways to import
and frequently asked questions. Note: cPanel has a 50MB upload s
you can refer to the article: “How to Create or Delete a MySQL D
scroll down and click on Import. STEP 8: A confirmation messag
please reach out to us via phone or chat for support. How to Imp
we can assist you.) Here's an example of the outdated username r
it’s recommended to upload your database to the /home/USERNAME d
providing the file name and database name for the import. Script
then create a user and grant that user full privileges through M
click on the Import tab in the main section. STEP 6: Use the C
your database names must include the cPanel username prefix (e.g
something_something). #1049 - Unknown Database 'username1_wrdp9'
indicating that the import was successful. Common Issues Import
you can increase this limit by adjusting the cPanel PHP max uplo
try importing the file again. #1007 - Can't Create Database 'use
upload the database backup file to your LyteHosting account and
go to cPanel > MySQL Databases and create the database with the
feel free to reach out.) Here's an example of the problematic qu
you can create one through cPanel's MySQL Databases section. How
the import file needs to be edited to remove the CREATE DATABASE
and it will work. Frequently Asked Questions How do you creat
and you lack the permissions to do so. The import file should be
we're happy to assist you.) Here's an example of the outdated qu
you must first DROP/DELETE all database tables. If you don’t dro
you need an existing database and a database user to import the
tables that don’t exist in the new .sql file will remain and may
choose the newly created database name from the left-hand menu.
you can choose to retain some tables in the database. Tables in
go to cPanel and click the MySQL Databases icon. Create the data
here's a workaround. The issue is that the import file contains
resulting in the process being terminated. If you encounter this
you’ll need to create a separate database for each one in cPanel
or is that done automatically? If you plan to import a different
please refer to the article How to Create or Delete a MySQL Data
Support
My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket
Search
Viewing articles tagged 'HTTP'
How to Install SSL
Installing your SSL certificate requires the following steps; STEP 1: Log in to cPanel. STEP 2:...
« Back
Tag Cloud
earn
Make money
lytehosting
Make money on social media
earn and post
post
domain
Nameserver
Lytehosting Nameserver
Wordpress
MySQL
Wordpress error
cloudflare
cname
email
ox app suite
smtp
appsuite
blogger
namecheap
Connect a Domain Name from Namecheap
Connect a Domain Name
Connect a Domain Name from Namecheap to Lytehosting
SSL
FREE SSL
CPANEL
career
internship
.edu.ng
install
softaculous
DNS management
Domains
Client Area
Error 500
Hosting
Reseller Hosting
php
php versions
SSL/TLS
SSL Certification
HTTP
HTTPS
Emails
Email Account
Password
Addon Domain
phpMyAdmin
Folder
Directory
SSL Certificate
Shared Hosting
VPS
Dedicated Hosting
WordPress Hosting
Installation Backup
Backup
Delete Backup
Password & Security
MySQL Database
User
File Manager
How to Import a MySQL Database There are various ways to import
and frequently asked questions. Note: cPanel has a 50MB upload s
you can refer to the article: “How to Create or Delete a MySQL D
scroll down and click on Import. STEP 8: A confirmation messag
please reach out to us via phone or chat for support. How to Imp
we can assist you.) Here's an example of the outdated username r
it’s recommended to upload your database to the /home/USERNAME d
providing the file name and database name for the import. Script
then create a user and grant that user full privileges through M
click on the Import tab in the main section. STEP 6: Use the C
your database names must include the cPanel username prefix (e.g
something_something). #1049 - Unknown Database 'username1_wrdp9'
indicating that the import was successful. Common Issues Import
you can increase this limit by adjusting the cPanel PHP max uplo
try importing the file again. #1007 - Can't Create Database 'use
upload the database backup file to your LyteHosting account and
go to cPanel > MySQL Databases and create the database with the
feel free to reach out.) Here's an example of the problematic qu
you can create one through cPanel's MySQL Databases section. How
the import file needs to be edited to remove the CREATE DATABASE
and it will work. Frequently Asked Questions How do you creat
and you lack the permissions to do so. The import file should be
we're happy to assist you.) Here's an example of the outdated qu
you must first DROP/DELETE all database tables. If you don’t dro
you need an existing database and a database user to import the
tables that don’t exist in the new .sql file will remain and may
choose the newly created database name from the left-hand menu.
you can choose to retain some tables in the database. Tables in
go to cPanel and click the MySQL Databases icon. Create the data
here's a workaround. The issue is that the import file contains
resulting in the process being terminated. If you encounter this
you’ll need to create a separate database for each one in cPanel
or is that done automatically? If you plan to import a different
please refer to the article How to Create or Delete a MySQL Data
Support
My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket
Live Support
Live Chat & Support Solution
Send Ticket
Ticket You’ve Just Created
Knowledge Base
Build Knowledge Base System
×
Close
Loading...
×
Choose language
العربية
Azerbaijani
Català
中文
Čeština
Dansk
Nederlands
English
Estonian
Persian
Français
Deutsch
עברית
Magyar
Italiano
Macedonian
Norwegian
Português
Português
Română
Русский
Español
Svenska
Türkçe
Українська
Choose Currency
$ USD
N NGN
Є EUR
£ GBP
Ksh KES
Generate Password
×
Please enter a number between 8 and 64 for the password length
Password Length
Generated Password
Generate new password
Copy