bspacer1 bspacer2
webmail hosting forum clients about

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98
Home PagePortal HomeClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloadsRegister

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > How to export a large database using phpMyAdmin?

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.



Was this answer helpful?

Add to Favourites
Print this Article

Also Read
How can I import a large database to my account? PhpMyAdmin times out. (Views: 11278)
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10053)
I get syntax error when trying to run a MySQL query. (Views: 1060)
I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2705)
I have problems accessing my MySQL database remotely (Views: 5298)

Powered by WHMCompleteSolution


Copyright © 1994-2021 PJR Sales and Service All Rights Reserved