Title: How to split sql file into two using an editor
Last modified: August 22, 2016

---

# How to split sql file into two using an editor

 *  Resolved [AndyiBM](https://wordpress.org/support/users/andyibm/)
 * (@andyibm)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/)
 * I have an sql file downloaded (as a zip) of just under 4Mb. My client’s PHPMyAdmin
   will only upload < 2Mb. I don’t have access to any other part of his server, 
   so can’t use a command line to import the data, so can I split my sql file (without
   losing integrity)? I have tried splitting the export file into separate tables
   from the original PHPMyAdmin, but it’s just one table (wp_posts) that is around
   90% of the data. I see in this WP thread [https://wordpress.org/support/topic/cant-restore-db-in-phpmyadmin](https://wordpress.org/support/topic/cant-restore-db-in-phpmyadmin)
   there is a link to these four options: [https://www.interspire.com/support/kb/questions/851/Overcoming+file+size+limits+when+uploading+SQL+files+to+phpMyAdmin](https://www.interspire.com/support/kb/questions/851/Overcoming+file+size+limits+when+uploading+SQL+files+to+phpMyAdmin),
   but my (seemingly) only option (3) doesn’t give much guidance. Does anyone have
   any suggestions?
    Many thanks 🙂

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

 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/#post-5316539)
 * 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](https://wordpress.org/support/users/andyibm/)
 * (@andyibm)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/#post-5316560)
 * 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](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/#post-5316567)
 * 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](https://wordpress.org/support/users/andyibm/)
 * (@andyibm)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/#post-5316572)
 * Brilliant – thanks again catacaustic… giving it a test go now 🙂
 *  Thread Starter [AndyiBM](https://wordpress.org/support/users/andyibm/)
 * (@andyibm)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/#post-5316585)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 2 participants
 * Last reply from: [AndyiBM](https://wordpress.org/support/users/andyibm/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/how-to-split-sql-file-into-two-using-an-editor/#post-5316585)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics