MySQL Import and Export (.sql file) via PhpMyAdmin

Problem:

I need to Export or Import a MySQL database

Solution:

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. 
  1. Login to the MostHost cPanel
  2. Under the category "Databases", click on phpMyAdmin
  3. On the left column, select the database name you wish to import to
  4. Along the top of the screen click the "Import" tab
  5. Click browse under "File to Import" and locate the .sql file on your computer
  6. After you have selected the file, click GO and it will import your database.
To Export a database in phpMyAdmin:
  1. Login to the MostHost cPanel
  2. Under the category "Databases", click on phpMyAdmin
  3. On the left column, select the database name you wish to export to
  4. Along the top of the screen click the "Export" tab
  5. Click Select All or just the tables you need.
  6. Check the box saying Save as file and enter a name.
  7. Press Go button at bottom right.
  • 51 Users Found This Useful
Was this answer helpful?

Related Articles

Configuring the PHP Environment With php.ini

Problem: How do I change the PHP environment for my site with php.ini? Solution:   To...

PHP with FastCGI

Problem: What is FastCGI for PHP? Solution: FastCGI for PHP makes all your PHP applications...

Upload_Max_Filesize

Problem: How do I change my upload_max_filesize? Solution: Summary Locate the php.ini...

Cron Jobs with PHP Files

How do I run a php file using Cron jobs?   From the cPanel, click the Cron Jobs icon and enter...

Basic Site Security Checklist

Remove malicious files and/or files you are not familiar with. While many PHP applications...