Re: [PHP] Need to move all MySQL tables to another server

2002-10-04 Thread Jason Wong 

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

[PHP] Need to move all MySQL tables to another server

2002-10-04 Thread Peter Janett 

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
[EMAIL PROTECTED]
(303)828-9882



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php