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