http://homepage.mac.com/kelleherk/iblog/C711669388/E351220100/index.html
I hope this helps :-)
- Kieran
________________________________________________________________
Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL 4.0.20 / Connector-J 3.0.11
Blog: http://webobjects.webhop.org/
On Jun 24, 2004, at 9:16 AM, [EMAIL PROTECTED] wrote:
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 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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]