> Erick:
>
> Do not try to copy the database files themselves. Instead use mysqldump to
> dump the structure and contents to text files, which you can easily copy
> across the network from your Windoze to Linux.
>
> My advice is to create an empty database on the Linux machine,
> and set your
> permissions using GRANT. Then import the text file(s) into the new Linux
> database.

As a matter of fact, you *can* make a simple move in many
cases. If all the tables were created (or converted to) MyISAM
in v. 3.23, there shouldn't be many problems. Watch out for
errors in database and tables names, tho' -- sometimes MySQL
gets confused after such a move because WIN does not distinguish
between lower and upper case.

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to