How to split sql file into two using an editor

Viewing 5 replies - 1 through 5 (of 5 total)

  • If you look through the file you’ll see the tables with a lot of data rows will have breaks in the rows every so-many lines. You’ll be able to see it break into a new INSERT INTO line every few 100 or so lines. You can break it up anywhere that you see something like that.

    Thread Starter AndyiBM

    (@andyibm)

    catacaustic… thank you for your response ??

    But do I need to make edits to the ‘table structure’ – particularly the AUTO_INCREMENT value in order to avoid any overwriting? (please forgive my minimal sql understanding)…

    And any other values?

    Cheers

    There’s no need to worry about any other things. Anything like AUTO_INCREMENT will be what it needs to be, and as long as you import the files in the order that you split them in you’ll be fine.

    Thread Starter AndyiBM

    (@andyibm)

    Brilliant – thanks again catacaustic… giving it a test go now ??

    Thread Starter AndyiBM

    (@andyibm)

    Worked ?? Cheers!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to split sql file into two using an editor’ is closed to new replies.