Hello! I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A > mysql_lamp_backup.`date '+%Y.%m.%d'`.sql
And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p < mysqlbak The error: ERROR 1064 at line 598: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-en' at line 1 This is teh line 598: CREATE DATABASE /*!32312 IF NOT EXISTS*/ blabla-en; IF i change the name to blabla_en, it works fine. #### Another issue: ERROR 1064 at line 830: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '! ,'poll','Questions','','',10,'r',11.61,11,10,0010000000010000,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? Cheers, Mario -- COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test -------------------------------------------------- 1. GMX TopMail - Platz 1 und Testsieger! 2. GMX ProMail - Platz 2 und Preis-Qualitätssieger! 3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]