Repost: MySQL Backup and Restore Using Binary Log

2001-08-13 Thread Deon de Villiers
Hi I am reposting this just in case someone who would be able to assist me did not see it first time around. Thanks Deon. I am currently putting together a backup system for our MySQL server. The way I want to do this is to make use of mysqldump to perform the backup and have the binary log (o

MySQL Backup and Restore Using Binary Log

2001-08-08 Thread Deon de Villiers
Hi There I have only just subscribed to this list - thank you in advance for any assistance. I am currently putting together a backup system for our MySQL server. The way I want to do this is to make use of mysqldump to perform the backup and have the binary log (on a different disk to my datab

Re: MySql backup and restore.

2001-03-20 Thread John Barton
You dont need a script or command to restore the database, mysqlhotcopy just creates a copy of your database files (.MYI, etc.) in the /pathToTheBackupDirectory/. It basicaly performs the same function as the unix command cp, only it does the necessary locking, etc. John Barton Unix Systems Admin

MySql backup and restore.

2001-03-20 Thread Zhu George-CZZ010
Hi, If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the whole database, what's the script/command to restore it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the m