If I use "innodb_file_per_table", how do I properly back-up that table so it
could be imported to another server should something happen to my main
server if I do not have the hot-back-up utility?
If I lock & then copy the table, can I simply use "ALTER TABLE tbl_name
IMPORT TABLESPACE" for it
comes with MySQL distribution:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
There is also non-free InnoDB Hot Backup program:
http://www.innodb.com/order.php
Some info about backing up InnoDB database find at:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
Also, as has b
omes with MySQL distribution:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
There is also non-free InnoDB Hot Backup program:
http://www.innodb.com/order.php
Some info about backing up InnoDB database find at:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
--
For technical s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 26 May 2004 02:34 pm, ColdFusion Lists wrote:
> we're using MySQL 4.0.12 with InnoDB... please do you have any scripts,
> comments, suggestions, ideas, tutorials... about how to backup from that
> DB? It's possible to?
If you can afford t
Hi all
we're using MySQL 4.0.12 with InnoDB... please do you have any scripts, comments,
suggestions, ideas, tutorials... about how to backup from that DB? It's possible to?
Thanx for your time.
Diga-me e eu esquecerei
Mostre-me e lembrarei
Ensina-me e aprenderei
-
Hendrik,
- Original Message -
From: ""Hendrik Schalekamp"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, June 18, 2002 11:12 AM
Subject: Backing up InnoDb
> Hi,
>
> I'm just trying out the hotbackup utility
(http://www.
Hi,
I'm just trying out the hotbackup utility (http://www.innodb.com/hotbackup.html)
for a MySql InnoDb based database and was hoping somebody could
help me with a few questions about the utility and InnoDb:
1. Firstly I'd like to know how mature the hotbackup utility is. The
implementation I
