I want to change my sqldatabase server from one machine to another

--_000_59662D5BB74CD84D9FA8E6491ADB51A72C6CD7FFUS01WXMBX1int er_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Can you please send me a script to do that?
I have MySQL Reference Manual for version 3.23.55.
/* Copyright Abandoned 1996, 1999, 2001 MySQL AB
This file is public domain and comes with NO WARRANTY of any kind */

/* Version numbers for protocol & mysqld */

#ifdef _CUSTOMCONFIG_
#include
#else
#define PROTOCOL_VERSION 10
#define MYSQL_SERVER_VERSION "3.23.55"
#define MYSQL_SERVER_SUFFIX ""
#define FRM_VER 6
#define MYSQL_VERSION_ID 32355
#define MYSQL_PORT 3306
#define MYSQL_UNIX_ADDR "/tmp/mysql.sock"
#define MYSQL_CONFIG_NAME "my"

/* mysqld compile time options */
#ifndef MYSQL_CHARSET
#define MYSQL_CHARSET "latin1"
#endif
#endif


I have mysqlhotcopy scripts, but that copies only to the same sql. I want t=
o copy the database to another machine.
All myscripts should access the database from the new machine and new locat=
ion.

Thanks,
Uma-


--_000_59662D5BB74CD84D9FA8E6491ADB51A72C6CD7FFUS01WXMBX1int er_--

Re: I want to change my sqldatabase server from one machine to another

Uma Mudumba wrote:
> Can you please send me a script to do that?
> I have MySQL Reference Manual for version 3.23.55.
> /* Copyright Abandoned 1996, 1999, 2001 MySQL AB
> This file is public domain and comes with NO WARRANTY of any kind */
>
> /* Version numbers for protocol & mysqld */
>
> #ifdef _CUSTOMCONFIG_
> #include
> #else
> #define PROTOCOL_VERSION 10
> #define MYSQL_SERVER_VERSION "3.23.55"
> #define MYSQL_SERVER_SUFFIX ""
> #define FRM_VER 6
> #define MYSQL_VERSION_ID 32355
> #define MYSQL_PORT 3306
> #define MYSQL_UNIX_ADDR "/tmp/mysql.sock"
> #define MYSQL_CONFIG_NAME "my"
>
> /* mysqld compile time options */
> #ifndef MYSQL_CHARSET
> #define MYSQL_CHARSET "latin1"
> #endif
> #endif
>
>
> I have mysqlhotcopy scripts, but that copies only to the same sql. I want to copy the database to another machine.
> All myscripts should access the database from the new machine and new location.
>
> Thanks,
> Uma-
>
>
>
Why don't you use replication to sync the new machine? Once both
databases are synced you can switch to the new machine. In this case you
should not even have a downtime.

http://dev.mysql.com/doc/refman/4.1/en/replication-howto.htm l

cheers,
wolfgang


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org