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

    Unanswered: mysql migration toolkit

    i just migrated two access databases to mysql. the first db came out fine, with all the data in tact. the second one migrated the schema, and imported the data (it counted out the rows) but i can't find it. anyone have any thoughts?

    the second db was considerably larger that the first (a 2 gig access db @#%$#) if that might have anything to do with it.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    The last step of the mysql toolkit should show you any errors which occurred during the migration. Did you read through that whole screen? If you saved the report then you should be able to check that. If not, rerun the migration (yes this is a pain) and make sure to save the creation, inserts, and migration status report (or whatever it is called) to files.

    Something similar happened to me where it got hung up on a "{" character I believe. It only ended up importing like a tenth of a table. But it should only affect the inserts, not the creates...if the database wasn't created then there is most likely something in the Access schema that the toolkit can't understand.

  3. #3
    Join Date
    Jan 2005
    Posts
    68
    the db i was migrating had been replicated. big pain. i had to run make table queries for each table to eliminate the sytem data

Posting Permissions

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