"DANIELE Paolo" <[EMAIL PROTECTED]> wrote: > > 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 > > all_databases.sql > > 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. >
UPDATE is a reserved word: http://www.mysql.com/doc/en/Reserved_words.html Use -Q (--quote-names) option of the mysqldump: http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]