Moving a database

[Anon]

ok how do i move a mysql database from an nt box to my unix box ?? are we talking create the database and move the directory or is it muck more involved

[Anon]

Well, I am not too sure from an NT to Unix..but when I move my databases between my boxes, all I do is this. from the bin directory of your mysql install...

./mysqldump database > location where you want the file to go

Then from the unix prompt. also be in the bin directory again.

first, create the database.

then type

./mysql database < location/filename

That will load all table structure and data in to the db