Transferring Server Database

[Trackye]

I have noticed that the PEQ database takes very little time to install.

I do not have alot of players so there isnt much data other than PEQ ( Some customizations but not a ton)

However if I Dump the Database into an SQL and go to load it in another Database it takes hours...

What command can I use to dump it in the format PEQ uses to make it as quick as that?

[Akkadius]

The eqemu_update.pl comes with a backup script that I wrote that will take care of this for you. It's options 1 and 2

[Shendare]

Hours? Am I ever glad for SSDs, then. Holy crap.

Test export of default peq db to .sql: 1m 5s

Test import as new db: 1m 49s

I'm hoping 'hours' was an exaggeration! lol

[Trackye]

Wasnt an exaggeration :( literally took like 5 hours to reload the DB table on a different DB.

I think its because the default Dump sql splits everything into individual lines of code and some of the tables have SOOO many lines that way (Grid_entries anyone?)
But the PEQ dump is done in large chunks.

Akkadius again thank you so much for the information I will definitely give that a shot ASAP.

[Shendare]

Are you exporting/importing with HeidiSQL? If you change the "Max INSERT size" value to... really anything but the default 0, it'll work a -helluvalot- faster.

I like running at 1024 KB, but you can run it at a -tiny- tiny number like 16 KB, and it'll both export and import an order of magnitude faster.

[Trackye]

I generally use Navicat but I have Heidi installed to. perhaps I can give that a shot as well.

Thanks!

[Akkadius]

Yes the time comes from all of the individual statements that are being ran versus bulk inserts. Once again my script takes care of that on its own.

[Trackye]

Just wanted to report back that that indeed did the trick Akkadius.

Literally minutes instead of hours.

Great work on that update program.