On 6/9/06, Ben Burford <[EMAIL PROTECTED]> wrote:
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.
man mysqldump
Has everything you need to know.
And also, consider using an updated version, the one you're using is too old.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]