Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is larger you will need to use SSH instead of phpMyAdmin.To Export a database in phpMyAdmin:
- Login to your cPanel
- Under the category "Databases", click on phpMyAdmin
- On the left column, select the database name you wish to import to
- Along the top of the screen click the "Import" tab
- Click browse under "File to Import" and locate the .sql file on your computer
- After you have selected the file, click GO and it will import your database.
- Login to your cPanel
- Under the category "Databases", click on phpMyAdmin
- On the left column, select the database name you wish to export to
- Along the top of the screen click the "Export" tab
- Click Select All or just the tables you need.
- Check the box saying Save as file and enter a name.
- Press Go button at bottom right.
- 0 Users Found This Useful