How do I update my DB without wiping server?

[Mongoose]

Was wondering how to update the spawns on my server with a new DB without wiping everyone's characters and my new armor that I created. Also, wondering how you can create zones. Any information will help :)

[Trumpcard]

Easy way..

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

Then, launch mysql

create database eqnew;

from dos again:
mysql -f eqnew < [new database file]
mysql -f eqnew < account.sql
mysql -f eqnew < character.sql
mysql -f eqnew < items.sql

this should create a new database called eqnew with all the attributes of your old one (characters, accounts and items) with the new database in it..

Your old one will still be there, just change your ini file to use the new database name so you can test it out and switch back to the old one if you have problems.

[Mongoose]

Ahhhhhh, thank you :)

[Mongoose]

When I put in mysql -f eqnew < db.sql(The new db file), I got all duplicate entry errors, what now?

[Trumpcard]

If that was the 1st file you sourced in, you shouldnt see any duplicate errors..

Did you source in one of the other files 1st?

[Lurker_005]

If your doing this and want to use the same database name, you need to drop the old database and recreate it (after doing the mysqldump part

mysql> drop database eq;
mysql> create database eq;