Customer Support

• FAQ & Knowledge Base
• Password Help
• Email Help
• Contact Support
• System Status >>
• Feedback

  Support Categories:

Getting Started FTP Moving Domains E-mail Stat Reports Mailing Lists Apache PHP CGI MySQL Database Other Software Billing & Terms Control Panel E-commerce Pre-Sales

Search for keywords:

Browse by category: -- Select Topic -- Getting Started FTP Telnet/SSH Moving Domains E-mail Traffic Reports Mailing Lists Apache PHP CGI Other Server-Side Scripting MySQL Database Imaging Libraries Other Software Billing & Terms Control Panel E-commerce Pre-Sales

How do I import a MySQL dumpfile into my database via
phpMyAdmin?

Please note that this FAQ only applies to SQL dumpfiles smaller than 8,192KB. For larger dumpfiles, please see our FAQ on dumpfile importing via the shell

• After you have dumped out your data into a file as described here, move this file from your old server to your local computer via FTP or SCP.


• Once you have this file saved locally, log in to phpMyAdmin using your database username and password (this is typically the same as your admin username and password unless it has been manually changed by you).


• Select the database you would like to import into from the drop down menu in the left-hand sidebar.


• In the main pane, click on the "SQL" tab.


• Underneath "Location of the text file", click the "Browse" button to select the SQL dumpfile you had had moved to your local computer in the previous step.


• Click "Go" to begin the import.


• When it has successfully completed, phpMyAdmin will display "Your SQL query has been executed successfully: The content of your file has been inserted."

User-Contributed Notes

There are no user-contributed notes for this topic.

Related Questions:

How do I import delimited data into MySQL?

How do I import a MySQL dumpfile into my database?

How do I connect to my MySQL database?

How do I change my MySQL password?

How can I export data in CSV or tab delimited format?

Why do i get a query syntax error 1064 from MySQL when the syntax seems correct?

How do I export and move my database tables between servers or copy databases?

How do I create a .my.cnf MySQL preference file?

I can't connect to local MySQL server through socket 'mysql.sock'

How do I change MySQL timezone?

What is my database server name?

What is my MySQL Username or Database Name?

MySQL says I have too many connections.

How do I check how much disk space my database is using?

A MySQL MYI table has errors in it.

Can I connect to MySQL remotely?

Can I connect to my MySQL database from my own computer?

I can't get phpMyAdmin to work.

phpMyAdmin gives SQL syntax error when I try to create table.

How can I use odbc_connect() in my PHP scripts to connect to MySQL?

What kind of database server do you offer?

How many databases do I get?

What am I allowed to do with my MySQL database?

Will we be able to do our own MySQL admin?

How do I export a MySQL dumpfile via phpMyAdmin?

Do you offer MySQL 5?

How do I create a MYSQL dumpfile?

Browse Categories: Getting Started, FTP, Telnet/SSH, Moving Domains, E-mail, Traffic Reports, Mailing Lists, Apache, PHP, CGI, Other Server-Side Scripting, MySQL Database, Imaging Libraries, Other Software, Billing & Terms, Control Panel, E-commerce, Pre-Sales