PDA

View Full Version : Import new db


Nada
02-15-2002, 10:58 AM
Whenever a new version of the emu comes out i always have to: use eq, source db.sql and when i do that tons and tons of annoying beeps start happening. Is there a way to import the db, without having to do that?

Trumpcard
02-15-2002, 11:49 AM
Drop the existing database first. Alot of the information is already there, thats why it beeps like crazy.

You may want to save your accounts or character data first though.

mysqldump eq > somefile.sql (Your old version)

then,
mysql>drop database eq
mysql>create database eq
mysql>source <path to db.sql>\db.sql

that will put the new one in with no annoying beeps. Your original data is preserved in the database dump, so just readd
the rows you see in there for your accouts or characters.

Nada
02-15-2002, 01:20 PM
Case closed, thanks stump! :D