How to backup and restore

2006-06-09 Thread Ben Burford 
Hello,

This is my first message, I'm an absolute beginner in Mysql.  I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0.  I want to be a able to
 do a backup and a restore.

The user's manual says:
5.9.2.1 Backup Policy
The following command makes a full backup . . :
mysqldump --single-transaction --all-databases  backup_06082006.sql

When I did this I got the message:
unrecognized option '--single-transaction'

So I tried the following:
mysqldump --verbose --all-databases  backup_06082006.sql

It seemed to work OK (no error messages) and created the file backup_0608200
6.sql

According to the manual:
5.9.2.2 Using Backups for Recovery
 . . restoring it is very easy:
mysql  backup_06082006.sql

When I tried this I got the following error message:
ERROR 1050 at line 19: Table 'Indian' already exists

Do I need to delete the table 'Indian'??

I hope someone can tell me in a simple, clear way (minimum of commands, noth
ing fancy) how to do a full backup and a full restore (I don't need partials).

Thanks very much in advance.

Ben



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to backup and restore

2006-06-09 Thread Ben Burford 
Hi Eugene,

Good to hear from you.  Should I use this on the creation or the restore?  A
s in:

mysqldump --verbose --add_drop-table --all-databases  backup_06082006.sql

or 

mysql --add_drop-table  backup_06082006.sql

or maybe

mysql  --add_drop-table backup_06082006.sql


or maybe something else??

Thank you,

Ben


At 16:53 2006/06/09 +0400, you wrote:
 
 
 Ben Burford wrote:
  Hello,
  
  Do I need to delete the table 'Indian'??
 
 Try --add_drop-table option
 man mysqldump
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
  



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]