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.

  • 31 Users Found This Useful
Was this answer helpful?

Related Articles

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database.  1) Through...

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

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...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...