Big command based SQL dumps fixer!

[pirata]

Hi, a lot of ppl (like me) were having problem importing those giga-insert-comand sql dumps files (mainly with recent NCDB upload), so I developed this program that "fixes" them, use is very trivial, just run:

sqlfix <nameofdb.sql>

It will generate a file with same name with "_fix" suffix in name (ie: sqlfix database.sql generates database_fix.sql) with all insert commands truncated to 32 inserts, if u wanna try bigger inserts just pass second parameter (numeric of course), ie sqlfix database.sql 128 will make database_fix.sql with 128 row-based inserts..

I've put a nice banner with mi nick to the program so nobody flame me about stolen content

I'm new here so.. if u like it.. +Rep would be appreciated

Here is the link:

sqlfix

[bsod-staff14]

First post Yay!

And very nice...I will +Rep you when I can just dont ask for rep next time...

[pirata]

Hehehe well.. this site tell us to do so, I see that everywhere and it's not very nice to see "a leecher if.." :s and one cannot do lot of things w/o rep -.-

Sth I didn't told and I see question coming.. YES! this program fixes the "MySQL gone away" msg..

[j00nas]

Easiest way to get rid of that ``Error 2006 MySQL server has gone away``
would have been just adding a line to mysql config-ini:
max_allowed_packet=60M

But anyways, +Rep

[y2kss66]

don't ask for +Rep

[bsod-staff14]

Weve already covered the Dont Ask for +Rep but however this is still a awesome release I want him to keep em commin!

[KaMakaZe]

A bit more detail how to run this please? Will +Rep if i get a bit more detail how to get this working.

Do the steps like describing it to a total noob. Cheers

[bsod-staff14]

Lol well first buddy do you have a server?

[volitle]

lol he wouldnt be in this section if he didnt have a server

[KaMakaZe]

I do indeed own a server. I need NCDB but im getting the mysql "MySQL server has gone away" error when extracting NCDB. I understand that this is NCDB compressing the quierys and overloading the packet sizes that MySQL is set to accept.

Hopefully this tool is easier than changing mysql configurations. But i need a bit more detail on how to do it. :P

Please...

[pirata]

Just as first post say, "sqlfix database.sql"

What's so complicated? o.O

[KaMakaZe]

Well, the console closes instantly when i run the program, if thats where im meant to type it? I dont even get a chance... thats why im a little confused.

[pirata]

Strange behaviour, console closes? seems like a M$-Win restriction..

BTW, r u running it at same dir you sql dump is? (and using right file name of course..)

Lets say you downloaded a "Repack" you extracted into C:\WotLK Repack, it then has a subdir named "SQL", and a dump for world database named "world.sql", you just put sqlfix.exe into C:\WotLK Repack\SQL, then execute CMD.EXE, cd "C:\Wotlk Repack\SQL", run "sqlfix world.sql", that's all

Or are u just "double clicking" sqlfix.exe? obviously that would make NOTHING...

[KaMakaZe]

lol, didn't relise had to be ran through cmd. Works perfect. +Repx2

No longer a leecher
Editing the MySQL config is easier though. xD

[pirata]

lol, didn't relise had to be ran through cmd. Works perfect. +Repx2

No longer a leecher

Hahaha tx! BTW it keeps saying I'm a leecher

Editing the MySQL config is easier though. xD

Mmm I don't think so, I just don't like too-many stepped setups :yuck:, so with this tool u just forget about it :wave: