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 RESTART SERVER 2) FLUSH TABLES WITH READ LOCK see the 'SHOW MASTER STATUS' sentence shutdown master database use 'mysqldump ...' command RESTART SERVER 3) use 'LOAD DATA FROM MASTER' sentence ( i havent studied this option ) i prefer option number 2.. but my question is: is it possible to do a 'mysqldump ..' ( remember innodb ) without shutdowning the server? thanks 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]
