Solved Copy a DB Table

[hmaddy]

i have two Databases on an account. DB1 and DB2.

DB1 have 11 Tables. and one table name clients have around 700 MB Data, approximately 60 Lakh Records.

I need to copy only this table to DB2. How to copy this table to DB2.

Export and import tried. But its failed. Only 50 MB Limit in phpmyadmin.

Is there any other solution for this.

 

[Zhenyapan]

You can backup it from SSH console where you will work without this limits.

 

[Richard G]

And the users can do this themselves using bigdump.php

BigDump: Staggered MySQL Dump Importer

www.ozerov.de

 

[hmaddy]

solved with the following command

INSERT INTO tblclients(firstname,email,state,phonenumber)
SELECT firstname,email,state,phonenumber
FROM mal6_customers.tblclients