How to split sql file into two using an editor

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

    (@catacaustic)

    9 years, 7 months ago

    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)

    9 years, 7 months ago

    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

    catacaustic

    (@catacaustic)

    9 years, 7 months ago

    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)

    9 years, 7 months ago

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

    Thread Starter AndyiBM

    (@andyibm)

    9 years, 7 months ago

    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.