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]