Import/export large mysql databases

Which scripts/solutions do use for import and export large mysql databases?

Phpmyadmin gives an err开发者_Go百科or for these operations, if there is a big amount of data.

http://sypex.net/en/ is better than Phpmyadmin in that

If you have access to the command line in both locations, mysqldump

For more verbose answers, you'll need to add much more information about your setup, e.g. whether you are on some sort of hosting package or a server of your own.

Using phpmyadmin is pointless for large databases. As of yet I have been using databases just over 1 GB in size, with over 12 million records. In my experience, the best way to export data is to use

mysqldump -h HOST -u USER -p database_name > export_file.sql

-h is optional in most cases. If you are on a remote server and the error "mysqldump: Got error: 1044: Access denied for user..." pops up, add --single-transaction;

mysqldump --single-transaction -h HOST -u USER -p database_name > export_file.sql

You can look up the reason here. To import the database you can use

mysql -h HOST -u USER -p database_name < export_file.sql