Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am moving databases between a couple of shared hosting accounts, and both of them only give access to the MySQL databases through phpmyadmin.

The importing account's upload limit is 50MB. I would like to export the database in parts (by selecting only a few tables to export at a time), using the export tool, then use the import tool more than once to get around the limit. Is this possible?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Yes this is possible, although you need to watch out for the following:

a) Export using extended inserts so that the extended SQL syntax is used which will reduce the size of your SQL files (If you are exporting using PHPMyAdmin select both complete and extended insert options, as it creates complete inserts with extended insert syntax for large tables)

b) Try using the GZip format which will compress the SQL files and make them smaller (depending on the hosting provider setup this may be an issue so you need to test it out with a small table)

c) Export the tables in such an order that tables with foreign keys are imported last

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.