Need to move all MySQL tables to another server
| From: | Peter Janett | 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