With the mysqldump utility (comes with mysql) you can backup/restore any
I don't know if you can tell it to dump all databases and their tables too.
If you've got root access, you can simply copy the 'data' (i.e:
C:\mysql\data) from a server to another.
"Peter Janett" <[EMAIL PROTECTED]> wrote in message
> I'm upgrading a web server, and need to move all the MySQL data from the
> 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
> 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?
> 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!
> [EMAIL PROTECTED]
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php