Tag Archives: MySQL

Import and export SQL tables

You should not use phpmyadmin to export big tables from mysql. You may get partial exports because of php server timeouts.

Best way is to connect via SSH to the server and use mysqldump to export the dataset. Then you can download it and transfer it to the new server. There you could use the mysql command to import the dataset.

Continue reading Import and export SQL tables