|
Home > Archive > MySQL Server Forum > June 2005 > Migrating from 4.0.12 to 4.1.12
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Migrating from 4.0.12 to 4.1.12
|
|
| yasaswi 2005-05-29, 8:23 pm |
| 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 2005-05-30, 1:23 pm |
| 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 2005-06-02, 1:23 pm |
| 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:
>
> 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?
|
|
|
|
|