I am duping the database contents (Mysql 4.0.20 on FreeBSD) from my life database. Now I want to import the dump into a freshly installed 5.0.18 on my local testserver (Suse Linux 10). I however get an error that I have an error in the mysql syntax.
I used
mysqldump -u root -p --opt --all-databases > backup.sql
and
mysql -u root -p < backup.sql
Is there a problem with different versions or have I overlooked something?
Problem importing a mysqldump
Moderator: General Moderators
You might want to disable the checking of constraints while inserting contents etc...
I wrote a simply shell script that should do that: http://timvw.madoka.be/programming/bash/myrestore.txt
I wrote a simply shell script that should do that: http://timvw.madoka.be/programming/bash/myrestore.txt