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
On Mon, 8 Jul 2002 [EMAIL PROTECTED] wrote:
> Todd Cary writes:
>
> > 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?
> >
>
> for as far i know, you can just copy the directory ( DB ) from one server to
> the other.
>
* Todd Cary
> Is there a quick and simple way to move a MySQL DB from one
> server to another MySQL server?
There are many ways to do that. How simple it is depends on a lot of
things... many people prefer to use some kind of tool, like phpMyAdmin or
MysqlFront.
http://www.phpmyadmin.net/ >
http
yap . you can coopy the database file although i'd say do dump of the
database (with mysqldump) .
eventuly to make things faster drop the indexes and recreate them on the
target machine
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 08
Todd Cary writes:
> 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?
>
for as far i know, you can just copy the directory ( DB ) from one server to
the other.
i've done it a couple times. and it stil works :)
> Todd
Take a dump
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 1:38 PM
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
If the OS is the same on each server (including patches just to make sure)
and the MySQL version is the same, then yes, you can simply copy the "data"
directories from one server to another
Make sure you FLUSH everything first and take MySQL off-line.
-Original Message-
From: Todd Cary [
