hi

Stop MySql on both servers to avoid changes to database during the move

Copy the whole directory to the new server

restart both Mysql servers

Grant permissions on new server

Done :)

HTH

Peter

-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
----------------------------------------------- 

> -----Original Message-----
> From: Todd Cary [mailto:[EMAIL PROTECTED]]
> Sent: 08 July 2002 13:39
> To: [EMAIL PROTECTED]
> Subject: Moving a DB from one Server to another
> 
> 
> Is there a quick and simple way to move a MySQL DB from one 
> server to another
> MySQL server?  Can I just copy the tables?
> 
> Todd
> 
> --
> Todd Cary
> Ariste Software
> 2200 D Street Extension
> Petaluma, CA 94952
> 707-773-4523
> [EMAIL PROTECTED]
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to