Heikki: 1. I am reading "Managing and using MySQL" from O'Reilly.
The book suggests (page 74) to use the -opt option, but that will make the db go offline for all practically purposes. Could I just use: $ mysqldump --flush-logs mydb > /opt/backup/mydb and have complete recovery and my users still able to connect to the database, like in Oracle? 2. Could I use mysqlhotcopy with innodb? $ mysqlhotcopy --flushlog mydb /opt/backup I am not interested in portability of the files only that my users can connect to the db and that I can do a complete (last commit) recovery of the db. Thanks for your reply. Ciao, Enrico Il dom, 2003-01-26 alle 04:38, Heikki Tuuri ha scritto: > Salvatore, > > ----- Original Message ----- > From: "Salvatore Enrico Indiogine" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, January 25, 2003 6:22 AM > Subject: GPL online backup for innodb tables > > > > Greetings! > > > > I would like to know whether in MySQL I can do an online (hot) backup of > > innodb type tables using a 'free' (GPL) tool. Or even if it is possible > > by writing my own shell script as you can do in Oracle with: > > > > alter tablespace <tablespace_name_1> begin backup; > > > > then use cp to copy the tablespace file > > > > alter tablespace <tablespace_name_1> end backup; > > > > alter tablespace <tablespace_name_2> begin backup; > > > > and so on for all tablespaces. > > > mysqldump is one. > > InnoDB Hot Backup is a way to make binary backups whose restoration is > faster than table dumps. > > > > Thanks in advance. > > > > Enrico > > Heikki Tuuri > Innobase Oy > --- > InnoDB - transactions, hot backup, and foreign key support for MySQL > See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > > sql query > > > > > > -- > > Enrico Indiogine > > Systems Analyst > > Information Systems > > Eastern New Mexico University - Roswell > > 505-624-7493 > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Enrico Indiogine Systems Analyst Information Systems Eastern New Mexico University - Roswell 505-624-7493 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
