Need to move all MySQL tables to another server

From: Date: Fri, 04 Oct 2002 10:58:59 +0000
Subject: Need to move all MySQL tables to another server
Groups: php.general 
Request: Send a blank email to php-general+get-118852@lists.php.net to get a copy of this message
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? Thanks, Peter Janett New Media One Web Services ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ New Upgrades Are Now Live!!! Windows 2000 accounts - Cold Fusion 5.0 and Imail 7.1 Sun Solaris (UNIX) accounts - PHP 4.1.2, mod_perl/1.25, Stronghold/3.0 (Apache/1.3.22), MySQL 3.23.43 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ PostgreSQL coming soon! http://www.newmediaone.net webmaster@newmediaone.net (303)828-9882

« previous php.general (#118852) next »