Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
January 25, 2006, 1:52 pm
rate this thread
i dont have much experience in databases or Mysql.i have my data
in development m/c with Mysql 4.1.12, i have to move them to production
m/c with Mysql 5.0.3 .when tried it showed error with displaying
[root@hostname mysql]# mysql -u root mydatabase < backup1.sql
ERROR 1064 (42000) at line 1: 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 'r
at line 1
was i am going wrong?
any ideas for making happen moving backup from Mysql 4.1.12 to Mysql
Re: moving mysql backup from Version 4.1.12 to 5.0.3
What is the first line in your backup1.sql file? As the 1064 error is a
parse error there might be some strange data there...
I'm not sure but I tought it was not neccesarry to specify the database
name as this should be specified in the dump file.
Does your root user have a password, did you specify it either by
command line or when prompted using the -p option?
- » Getting Success or Failure Detection in Stored Procedure
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum