Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    68

    Unanswered: moving a mysql database

    i am migrating an access db to mysql. i loaded the access db, fixed it, and migrated it. i tried to compress the db folder and email it. it went through, but i can't open the tables. i read one post that said you need to reset the permissions, but i am logged on as the root user. any help would be much appreciated.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    dump the database to a file, send the file, import the file in the new location.

    http://www.dbforums.com/showthread.php?postid=4488008

  3. #3
    Join Date
    Jan 2005
    Posts
    68

    using mySQL administrator

    thanks a lot for your help. i basically did the same with a backup-restore with mySQL administrator

  4. #4
    Join Date
    Dec 2004
    Location
    Malaysia
    Posts
    24
    http://www.fonlow.com/zijianhuang/dbconverter/

    u can try this one... never tried b4 .... but have done b4 using some tools like this... easier...

  5. #5
    Join Date
    Mar 2004
    Posts
    33

    Lightbulb

    Hi,

    Check this products :

    SwisSQL
    http://www.swissql.com


    MySQL Migration Toolkit 2.3
    http://www.convert-in.com

    MySQL Turbo Manager
    http://www.mentattech.com


    Regards,

Posting Permissions

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