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,00100 00000010000,'','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/my***********...ie.nctu.edu.tw