On Friday 04 October 2002 18:58, Peter Janett wrote:
> I'm upgrading a web server, and need to move all the MySQL data from the
> old box to the new one. I have approx. 50 databases, some of which have a
> lot of tables in them.
> I know I can write a script to list all the databases, then export the sql
> for each database, then each table in it, then the data, but I'm guessing
> someone else has faced this need, so there may be a PHP solution out there.
> I'm hoping I can find an open source Perl or PHP script that I can simply
> point at the old and new server and tell it to copy all databases and data
> to the new server.
> Any ideas?
Stop the mysql server on old box.
Copy all the directories/files in the data directory to the new box.
Start up mysql server on the new box.
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Man is an animal that makes bargains: no other animal does this--
no dog exchanges bones with another.
-- Adam Smith
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php