phpMyAdmin is a tool used for database management. It can be used to import a database to your hosting, in cases where you need to restore a database backup or are migrating your site from another host.
Here we cover the steps to recreate the database and import the database .sql, .zip, or tar.gz file using phpMyAdmin in cPanel.
Related Articles
Import MySQL Database From Command Line
Export MySQL Database Using phpMyAdmin
Creating the Database
- Access the appropriate cPanel
- Create the new database to import to in cPanel with the MySQL Database Wizard or using MySQL Databases
- Enter a name in the New Database field and click Create Database
- Create a new user and add the user to the database, ensuring the new user has all permissions needed
- Enter a name in the New Database field and click Create Database
Importing the Database File
- Access the appropriate cPanel
- Under Databases, open phpMyAdmin
- Select the new database from the left menu
- Choose Import in the top menu
- Choose Choose File to Browse your computer and select the file you'll be working with from your local computer
CAUTION: Database must be below 50MB for shared hosting. This upload limit can be increased on VPS and above. On shared, databases over 50MB can be imported from Command Line. - Choose Go to begin the import
- If there were no errors, the database will be imported successfully.
Comments
0 comments
Article is closed for comments.