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 <custom_conf.h> #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-