Re: import/export db from windows to linux

[Ulf Tornert]

Nick (and others :),

I've had some difficulties recreating databases from mysqldump-files. When viewing the files created from mysqldump I see that they contain redundant (?) information and they are not purely SQL-formatted, am I right? I've managed to recreate databases after having all non-SQL information disposed, but this cannot be done when dealing with LARGE databases. So, when I saw your suggestion I immediately tried it out. I did something like this:

% mysqldump -u root -p some_database > some_database2005-03-26.sql

then I logged on typing

% mysql -u root -p

mysql>create database some_other_database;
mysql>use some_other_database;
mysql>source path/to/some_database2005-03-26.sql;

But I get an error 22: "Failed to open file...". This happens both when the generated sql-file is outside of the mysql directory as well as inside.

Can you (or anybody else) help me?

By the way I'm using mysql 4.0.12 on a win xp machine.

Thanks!
Uffe