List:General Discussion« Previous MessageNext Message »
From:DANIELE Paolo Date:October 22 2003 7:37am
Subject:Backup/Restore all data
View as plain text  
I have a version of MySQL on my server (mysql Worm 11.18 Distrib
3.23.56, for PC-linux (i686)) which I wish to transfer towards a more
recent server (mysql Ver 11.18 Distrib 3.23.58, for PC-linux (i686)).  I
make a complete backup of the data with the following command:  
mysqldump - U root?p<password > -- all-databases -- opt >
Then I have transferred the file on my new server.  For the restore I
have launched the following command:  
mysql - U root -- password=<password > < all_databases.sql 
Unfortunately I have always the following error:  
ERROR 1064 At line 918:  You cuts year error in your SQL syntax near '
upDate datetime NOT NULL default ' 0000-00-00 00:00:00 ', SINGLE KEY id
(id)) You At line 5 
Can you indicate if my procedure is right or if there is another method
for transfers complete from the base.

Backup/Restore all dataDANIELE Paolo22 Oct
  • Re: Backup/Restore all dataVictoria Reznichenko22 Oct