Re: Need to move all MySQL tables to another server

With the mysqldump utility (comes with mysql) you can backup/restore any database. 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. good luck, Elias "Peter Janett" <phplist@newmediaone.com> wrote in message news:026d01c26b95$0bf65f70$55285742@peters... > 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 > >