Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Question Unanswered: How to migrate mysql db from windows XP to Redhat linux mysql

    Hi! Any one can help me? I have a problem with a migration, this is my configuration:

    Original db located in windows XP pro under mysql with tomcat

    Destination db is located on other machine under Redhat Linux 9.0 with mysql.

    When I can do a secure transfer by network of my db structure and data ?

    I like any tips or help.

    Tnx friends

  2. #2
    Join Date
    Nov 2002
    Posts
    8
    Use

    mysqldump -A dump.sql

    to create sql file wich will do the job

    That command dumps all databases to one sql file. Than you have to send that file to your linux box and execute it undr mysql. It creates databases, tables and inserts data. It's safe and quite fast. Moving about 100000 records took me 10 - 15 minutes.
    I've also tried copying data dirctory and it worked as well in version 3.23.54. But it was RH to RH transfer.
    Good luck.

  3. #3
    Join Date
    Jul 2003
    Posts
    8
    If you dump, you will need to watch out for you table and column names. Many MySQL installations can take lower case or upper case names for the table and column names (there is a MySQL option that prevents this). With Linux, upper case or lower case always matter.

    For example: If you are on Windows and your table name is ACCOUNTS, it will probably be in the database as 'accounts'. Your code may do a query on the ACCOUNTS table. On Windows, this is fine. Once you move to Linux, the table name better be ACCOUNTS and not accounts.

    A dump from Windows will have the table name as accounts (at least it used to be that way).

    If this happens, and your application code uses upper case for table and column names, you can do a search and replace before importing new table into Linux.

  4. #4
    Join Date
    Jul 2003
    Posts
    8
    Forgot to add to the start of the previous post:

    If you're dumping from MySQL running on Windows, . . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •