murilo
138
1
Tips

MYSQL Big DB importing via MySQL Workbench is giving error , importing in wrong orde

Posted 11 months ago by murilo

Hello , I have a question , I have a BIG database to import via Mysql Work bench . I am using MYSQL 5.7 , I am trying to import my database via workbanch ,but is giving error of raletad ID , it is not importing on right order .

It shoud import first -

  • STATE TABLE
  • CITY TABLE ( with state_id )

but is importing city table before state table, so it is giving error , becose city table has state_id .

I have to import all the columns that comes first ( STATE TABLE ), after import those columns that comes after (CITY TABLE) .

IT is giving me a lot of problem this .Does this happened with some one ? Does some one know what to do ? Thanks

Please sign in or create an account to participate in this conversation.

Reply to

Use Markdown with GitHub-flavored code blocks.