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 replication slave. Each night a system cron script stops MySQL, backs
up the slave XServe, and then restarts MySQL
On Jun 24, 2004, at 7:01 AM, [EMAIL PROTECTED] wrote:
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 set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1."
:).. but dont worry i write the sentences by hand.
thx
d2clon
On Thursday 24 June 2004 11:44, Egor Egorov wrote:
"[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 work right
i have read: "try to use mysqldump --single-transaction ..." but i
dont
see any difference.. and doesnt work right too
i have read: "use this: http://www.innodb.com/order.php .." but it
isnt
free :/
the problem is not how to do the backup.. but recovering from it..
because it complains about the foreign keys.
How to restore tables that have foreign key relationships is
described at:
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
You should set FOREIGN_KEY_CHECKS to 0 before restoring tables.
and then i think:
how is it possible that i cant do backup, and recover it, of my
innodb
tables?
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
