i have been reading..
and i have found 3 ways to have a copy of mysql master datas for initilize the
mysql slave
( always having in mind innodb compatibility )
1)
FLUSH TABLES WITH READ LOCK
see the 'SHOW MASTER STATUS' sentence
shutdown master database
copy all data, log and .frm files
RESTAR
I have just documented how I set it up a new slave last week to
replicate against an existing master and it was really easier than I
expected. It works like a charm so far. Here is the instructions
http://homepage.mac.com/kelleherk/iblog/C711669388/E351220100/index.html
I hope this helps :
that is just what we want to do..
but it isnt "The simplest thing to do" as you say
:P
i am studying this:
http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html
thx another time
d2clon
On Thursday 24 June 2004 15:22, Kieran Kelleher wrote:
> The simplest thing to do is set up a replication
The simplest thing to do is set up a replication slave and run a script
every night that shuts down the MySQL slave, performs the backup, and
then restarts MySQL. We have a dedicated XServe running MySQL and we
use another XServe whose primary function is filesharing to also act as
a replicatio
thx thx :D
thats work right.
the only problem is that mysqldump dont write the 'set FOREIGN_KEY_CHECKS'
sentences until version 4.1.1:
"To make it easier to reload dump files for tables that have foreign key
relationships, mysqldump automatically includes a statement in the dump
output to se
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> i have read multiple websites and posts.. and this mail list archive
> but i have not found the answer to the question:
>
> how is it possible to do a backup of a innodb table?
>
>
>
> i have read: "try to use mysqldump.." but this does not w
