How do I dump account and character data?

[Arley McFarley]

Is it possible to dump the account and character information from an eq database I use for v4.2 emulator?

I'd like to start using the v4.3 and Drawde's new worlddata, but I'd like to import the account and character data from my 4.2 setup.

Can I do a dump of just those areas of my current db to import into a new eq database?

Thanks.

[Trumpcard]

mysqldump <databasename> <tablename> > table.sql


So, say you want to dump account and character_ in a database called eq.


mysqldump eq character_ > character.sql
mysqldump eq account > account.sql


That will create the source files for those 2 tables. Then to put them back in

mysql eq < filename

will reload them...

[Arley McFarley]

Thanks, Trumpcard.

I'll use those commands.

Do any other "tables" come to mind that I should dump to retain account information?

Any other "tables" to retain character names, level, stats, equipment?

I appreciate the response.

Arley

[Trumpcard]

nope, those should be it.. those are the only 2 i update when i upgrade my database.. if you've done custom items, or other custom things, those are things you might want to save

[Arley McFarley]

Thanks.
No other item updates, etc., in my db.

I appreciate the help.

Arley

[tcsmyworld]

Now that factions work , if you want ALL char info , dump faction_values also.

[Arley McFarley]

Thanks, Trumpcard.

I successfully dumped the account and character info from my current db and sourced it into an updated db.

I didn't mess with the factions data, though. I'll do that next time.

Arley

What is the Mysql console command to get rid of a DB?

[Memener]

LOL it is
drop database eq;
or where ever you database name is