copy data from one database to another

[Sana'a_1]

Hi,
I'm trying to copy the data from a table in one database to another table (with the same fields of the origin table) in another database. And this is my code

$con= mysqli_connect("localhost", "root", "") or die("error");
        $sql="insert motcenter.d select * from mot_hrms.d ";
        $result=$con->query($sql);

But nothing happens when I run the code, or just few records copied with other tables.

I appriciate any help, and sorry for my poor english.

[rproffitt]

Be aware I don't know what the LIMIT is set to today either default or your install. MySQL used to limit the return results.
Read https://superuser.com/questions/240291/how-to-remove-1000-row-limit-in-mysql-workbench-queries for a prior kick around on this area.

[Stefce]

Why not download the table and upload it to other ?

[benanamen]

Writing a proper query would be helpful.

INSERT INTO table2
SELECT * FROM table1

https://dev.mysql.com/doc/refman/5.7/en/insert-select.html

[Santanu.Das]

INSERT INTO <DESTINATION TABLE NAME> SELECT * FROM <SOURCE TABLE NAME>

BUT FIELDS NAME AND TYPE OF DESTINATION SHOULD BE SAME AS SOURCE.

[Sana'a_1]

Thanks all
I figured out the problem