Transfer mysql from different server

[itnoob]

I want to copy database from this server to another.
Is there mysql query can do this secssion.
Plz help me...

[devinemke]

export/import the schema of the database using phpMyAdmin

[MarkR]

Use the mysqldump program to create a .sql file from your database, then use the mysql program to load it back in at the other end.

For maximum performance, do both of these operations locally on the two servers, and transfer the file (rather than running it on a remote machine).

Read the mysql documentation for more info.

Mark

[itnoob]

🙁 , i mean use "one" query to transfer, not use phpmyadmin or sm sqltools...
Is the query exist ... ????

[mymainoffender]

yeah, but its probably huge depending on the size of ur database...thats all the phpmyadmin produces is a SQL query.