Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14655 reviews 1734 hosting providers

Questions & Answers

Importing/Exporting large mysql tables

Feb 2, 2013 by darkshark
I have three tables in mysql database and all my tables are quiet large (more than 200 MB). The problem is that since they are so large  I am not able to import/export them using PhpMyadmin. I already have the database setup on the server and I just need to export the tables without loosing any data. Can anyone please help

3 Answers

0 votes
Feb 2, 2013 by lionhost
If you have root access in your server, you can dump your tables from shell:

for Table1 in `mysql -u root -pmypassword -N -B -e ‘show tables from database_name’`; do echo $Table1; mysqldump database_name $Table1 > database_name_$Table1.gz ; done
0 votes
Feb 2, 2013 by lightSpeed
you can use a free version of SQLyog to transfer your tables
0 votes
Feb 2, 2013 by SmartHost