Transferring Server Database
 

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?

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

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

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.

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.

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

Thanks!

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.

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

Literally minutes instead of hours.

Great work on that update program.