Quickest route from WAMP to LAMP

sneakyimp

I need to get a large database (~350 mb) from a Windows (WAMP) server to my Linux (LAMP) server.

Actually that's not strictly true. The windows machine containing the data is database only...the active webserver and php are on a separate windows machine.

That said, can i run mysqldump on the windows machine from the command line? Will the resulting file be compatible with mySQL import on the Linux machine?

devinemke

sneakyimp wrote:
...can i run mysqldump on the windows machine from the command line? Will the resulting file be compatible with mySQL import on the Linux machine?

the output from mysqldump is not the data itself but simply the data schema as a plain ASCII text file which can read by just about any OS.

sneakyimp

so on the linux machine, can i run a "insert data infile" query and just import the mysql dump from windows.

and can you actually do a mysqldump from the command line on WAMP machine?

MarkR

The Mysqldump output file is not an ASCII text file, however, it is compatible between different platforms.

evinemke was wrong - the output file will only be an ASCII text file if your database contains ASCII characters exclusively, and no binary data (i.e. blobs).

You do not import it with an "insert data infile" query - instead direct it to the mysql command line tool. See the mysql manual for details. A typical invokation from the Unix shell looks like

mysql -u username -p < mybackupfile.sql

Mark

MarkR

If you're being really clever about it, you don't even need to use a backup file at all, on the Linux side, you can simply do:

mysqldump -h windowsbox -u username -p databasename | mysql -u username -p databasename

Which uses a pipe to connect the dump to the mysql client.

In order for this to succeed you must have at least read and lock access to the database you're backing up, and create access to the new one, which must already exist and not already contain tables of the same names.

Mark

sneakyimp

Mark! Dude! That's like karate! hot CHA! I like it.