Dump Mysql Tables via command line

If you are facing the problem from importing large databases via phpmyadmin. In that case, you need to Dump Mysql Tables via command lines by using the following command.

for Y in `mysql -N -B -e ‘show tables from database_name’`; do echo $Y; mysqldump database_name $Y > database_name_$Y.gz ; done

Now you can restore the tables one by one through phpmyadmin.