469,934 Members | 1,903 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Import Database from MySQL3.x to MySQL 4.x

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

Jul 19 '05 #1
0 2122

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Vidhya CS | last post: by
reply views Thread by Mario Ohnewald | last post: by
2 posts views Thread by Brian Huether | last post: by
4 posts views Thread by news | last post: by
7 posts views Thread by phillip.s.powell | last post: by
2 posts views Thread by Dave | last post: by
1 post views Thread by Dave | last post: by
7 posts views Thread by Randy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.