This might be of some use? http://www.mysql.com/doc/m/y/mysqlhotcopy.html ========================== Karl Phillipson PHP SQL Programmer Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 Direct Line: 0207 693 8318 -----Original Message----- From: elias [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 14:53 To: [EMAIL PROTECTED] Subject: [PHP] Best way to take a copy of a Database from Server to server Hello. I have two MySql databases running on different servers. I have no root access and only PHP + Mysql and MysqlAdmin. How can i take a dump of first database (which is about 1MB) and restore that dump on the second one? Actually, I'm doing a structure dump, but the outputed SQL text is very big!..I'm not able to paste it all in the second server's sql query textbox. Any ideas? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
