Problem importing a mysqldump
Posted: Sat Feb 04, 2006 11:30 am
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?
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?