Migrating from 4.0.12 to 4.1.12

[yasaswi]

I did a mysqldump --opt database -u username -p > outputfile.txt on
Machine A, which is running 4.0.12.
Then on Machine B, which is running 4.1.12 I did the following,
mysql -u username -p database < outputfile.txt

It loaded about 20 tables file, but then I got an error saying there is
a syntax error. Please help.

Thanks,
Yasaswi

[Jonathan]

yasaswi wrote:

I did a mysqldump --opt database -u username -p > outputfile.txt on
Machine A, which is running 4.0.12.
Then on Machine B, which is running 4.1.12 I did the following,
mysql -u username -p database < outputfile.txt

It loaded about 20 tables file, but then I got an error saying there is
a syntax error. Please help.

Thanks,
Yasaswi

Can you provide us with some information from the sql file you try to
import. Saying that you get an error is not very precise and now you
leave us guessing for what error where occured.

My guess is that the program terminates with some sort of error message
somewhere along the line stating that there was an error somewhere in
the mysql syntax as you say that 20 tables were imported and then the
error occured.

Jonathan

--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

[yasaswi]

Hi Jonathan:
I was getting a syntax error, something like error in line number 2859
....
Therefore I wrote a script which will mysqldump each table separately
and load each table individually. Now I don't have the problem any
more. The error might have occured because the database is very big,
may be....
Thanks,
Yasaswi
Jonathan wrote:

yasaswi wrote:

I did a mysqldump --opt database -u username -p > outputfile.txt on
Machine A, which is running 4.0.12.
Then on Machine B, which is running 4.1.12 I did the following,
mysql -u username -p database < outputfile.txt

It loaded about 20 tables file, but then I got an error saying there is
a syntax error. Please help.

Thanks,
Yasaswi

Can you provide us with some information from the sql file you try to
import. Saying that you get an error is not very precise and now you
leave us guessing for what error where occured.

My guess is that the program terminates with some sort of error message
somewhere along the line stating that there was an error somewhere in
the mysql syntax as you say that 20 tables were imported and then the
error occured.

Jonathan

--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?