What steps will reproduce the problem?
1. Create a table with 400 rows (total data size is around 200 kB).
2. Export using SQL Buddy.
3. Import using SQL Buddy (e.g. into another database).
What is the expected output? What do you see instead?
I expect all queries to be imported.
What version of the product are you using? On what operating system?
SB 1.3.1
Apache 2.0
PHP version 5.2.6-3ubuntu4.1
MySQL 5.0.75
Please provide any additional information below.
I believe the issue is due to the fact that when exporting, there is
actually only one query in the file (when using "Compact inserts"). You
have an "INSERT INTO" line, followed by 400 lines of data.
When exporting SB should split compact inserts into groups of 50 or so (as
phpMyAdmin does). In other words, one "INSERT INTO" line, then 50 data
lines, semicolon, another "INSERT INTO" line, 50 data lines, etc etc.
Original issue reported on code.google.com by
scott.vi...@gmail.comon 5 Jul 2009 at 11:26