i think this can be done by dumping your database to a file and then fetch it to mysql cli
i make a batch script to do this daily... i have not use replication, so i just copy the entire database (in windows version): c:\mysql\bin\mysqldump.exe -a -c -C -e --add-drop-table --add-locks -F -f -Q -h theSourceHost --user=theUser --password=thePassword -l -n -r c:\dumpFile.sql -B theDatabase c:\mysql\bin\mysql.exe -h theTargetHost --user=theUser --password=thePassword < c:\dumpfile.sql i hope this help... cmiiw regards -leo- ps: you can see the online help for all the parameter ----- Original Message ----- From: Andrew Simpson To: [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 11:06 PM Subject: How to move database to new server Hi I have a mysql database with 20 tables containing data whch i need to transfer to a new hosting server (i access this server via webmin.) What's the easiest way to move a database from one server to the other?. Can you export full databases from mysql (this would be the easiest), or do i need to create the database and all the tables on the new server first and then find a way to just export and import the data?. TIA
