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