|
| Backup question |
 |
Mon, 13 Mar 2006 08:45:13 GMT |
Hi!
Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver.
4.0.15a, PHP 4.2.3, all of them on same machine.
Is it a secure way to Backup \ Restore the MySQL DB, using the M$-Windows COPY
command \utility from the DATA folder to a DVD media?
TIA
|
| Post Reply
|
| Re: Backup question |
 |
Wed, 15 Mar 2006 05:53:22 GMT |
Hi!
>
> Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver.
4.0.15a, PHP 4.2.3, all of them on same machine.
>
> Is it a secure way to Backup \ Restore the MySQL DB, using the M$-Windows
COPY command \utility from the DATA folder to a DVD media?
>
Don't do the above while MySQL is running. If you really want to, first
open a mysql session and run FLUSH TABLES WITH READ LOCK. Then, keeping the
mysql session open, do the xcopy of entire data directory. After xcopy
completed, run UNLOCK TABLES in the session.
Or, just use mysqldump to get a backup. You can run
"mysqldump --single-transaction --quick -uroot -p --all-databases".
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Remember if doing filesystem backups of InnoDB, it's required to copy all
the ibdata* and ib_logfile* files in addition to the database directories.
Regards,
deva
|
| Post Reply
|
| Re: Backup question |
 |
Wed, 15 Mar 2006 07:18:18 GMT |
Thanks!
Can I use the "FLUSH TABLES WITH READ LOCK" command on a Win 2000
workstation while the DVD drive is on the station and server is NW 6.5?
TIA
Nanu
>>> deva<shane@absamail.co.za> 15/03/2006 07:53:22 >>>
Hi!
>
> Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver.
4.0.15a, PHP 4.2.3, all of them on same machine.
>
> Is it a secure way to Backup \ Restore the MySQL DB, using the M$-Windows
COPY command \utility from the DATA folder to a DVD media?
>
Don't do the above while MySQL is running. If you really want to, first
open a mysql session and run FLUSH TABLES WITH READ LOCK. Then, keeping the
mysql session open, do the xcopy of entire data directory. After xcopy
completed, run UNLOCK TABLES in the session.
Or, just use mysqldump to get a backup. You can run
"mysqldump --single-transaction --quick -uroot -p --all-databases".
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Remember if doing filesystem backups of InnoDB, it's required to copy all
the ibdata* and ib_logfile* files in addition to the database directories.
Regards,
deva
|
| Post Reply
|
|
|
|
|
|
|
|
|
|