How to export a large database using phpMyAdmin?

If you have a large database, it may be difficult to export all of its tables at once through phpMyAdmin. The most common reason for this is the timeout limit most web hosting companies set on their shared servers.


Fortunately, there is an easy solution for this issue. Instead of selecting all tables in the database and then exporting them, you should export the large database by selecting only several tables at a time.


This way, if you wish to import the database, you will have to import smaller SQL dumps and thus you will avoid a phpMyAdmin timeout during the import process.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Can I change the name of a MySQL database?

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...

How can I empty a MySQL database?

The easiest way to empty a MySQL database is through phpMyAdmin.  Once in phpMyAdmin, select the...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...