	Home Web Hosting domains Domains

Customer Support

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:

How do I export a MySQL dumpfile via phpMyAdmin?

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

First login to phpMyAdmin as the administrator for your site.

Select the database server your database is currently on under the "Server Choice" heading.

Select the database that you want from the dropdown menu on the left under the "Database:" heading.

Select the "Export" tab towards the top of the page.

The default settings should work for you.

Check the box next to "Save as file."

Select the file name that you would like for the new dumpfile to be called.

Click on the "Go" button.

Save the file locally to your machine wherever you would like.

If your dumpfile is smaller than 8,192KB then you can follow this FAQ to import your database somewhere else using phpMyAdmin. If the dumpfile is too large, then you should use our FAQ on importing a mySQL dumpfile via the shell here.

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 change my MySQL password?

How do I import a MySQL dumpfile into my database?

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

How do I connect to my MySQL database?

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?

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

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

What is my database server name?

How do I change MySQL timezone?

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 import a MySQL dumpfile into my database via phpMyAdmin?

Do you offer MySQL 5?

Browse Categories: