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]