migrate mysql from windows to unix. syntax error on generated file

Question

So, I'm trying to move an existing MySQL database from a Win2008 server to an Ubuntu machine, however when I try to import the dump file, MySQL is giving me a syntax error.

Below are the steps I took

(on windows machine, in mysql\bin)

.\mysqldump.exe -u root -p test > test.sql

(on windows machine, in cygwin)
```
 scp test.sql myusername@hostname:~/
```

(on ubuntu machine)

$ mysql
mysql> create table test2;
$ mysql -u root -p test2 < test.sql

MySQL then stalls for a litle bit, and then throws... ERROR 1064 (42000) at line 1: You have an error...

It's as if the error is in the dump file generated by windows. It is something in character conversion? or formatting? or something that I'm just just missing?

EDIT:

The error was that I needed to run a refresh before running mysqldump.exe. The command that did the trick was....

./mysqladmin.exe -u root -p refresh

It's hard to tell without seeing the entire error message as well as the query where it is raised. — Mchl
– Mchl, Commented Aug 24, 2011 at 22:51
The only error that was generated was the standard run-of-the-mill MySQL syntax error with just a single quote (') about 100 blank lines, and then a closing single quote. — theangryhornet
– theangryhornet, Commented Aug 25, 2011 at 17:42
Yes, the file made sense, it was too large to fully parse, however, it seemed a refresh fixed my problem. See edit above. Thanks anyways! :) — theangryhornet
– theangryhornet, Commented Aug 25, 2011 at 21:21

theangryhornet · Accepted Answer · 2011-08-30 21:00:11Z

1

EDIT:

The error was that I needed to run a refresh before running mysqldump.exe. The command that did the trick was....

./mysqladmin.exe -u root -p refresh

answered Aug 30, 2011 at 21:00

theangryhornet

4032 gold badges5 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

migrate mysql from windows to unix. syntax error on generated file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related