Export Data As Sql Statements – No Line Feed

[sdozono]

I used 'Export Data As SQL Statements' feature.

Then it produced a text format '*.sql' file with No Line Feeds.

It was like '***),(***),(****)…….' only one line!

So, my file became a text file of almost 2MB with no line feeds.

Could you add 'Line feed' after each comma?

It will be like

(*****),

(*****),

(*****),

Then, it will be easier to open with 'NotePad' or other Text Editor.

😮

[Ritesh]

Are you using Create Bulk Insert Statements?

[sdozono]

Yes. That's right.

If that 'Create Bulk Insert statements' checkbox is OFF, SQLyog will create a dump with line feeds.

I tested phpMyAdmin.

It will make a bulk dump with line feeds.

It's like this:

INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1),[line feeds]

(2, 'Deutsch', 'de', 'icon.gif', 'german', 2),[line feeds]

(3, 'Espanol', 'es', 'icon.gif', 'espanol', 3),[line feeds]

(4, 'Japanese', 'ja', 'icon.gif', 'japanese', 4);[line feeds]

[Ritesh]

Hmmm. Nice.

I have added it in the TO-DO list. Will be implemented in v4.2 BETA 6.

[peterlaursen]

Then I shall repeat my request that the bulk size is user configurable.

Reason for that:

importing to my ISP w/o bulks is incredible slow. But the default bulk size is much too big for the configuration (fails to of three times) I would like an option to choose for instance 200 K as bulk size. That is reasonable fast and safe too.

[Author]

Posts