Oh, well if you want to back up your characters in your old database & import them into the new one, then do this (before dropping the old one):
Quote:
Go to the mysql\bin directory from a command prompt window & type:
mysqldump.exe -t eq account character_ character_backup > charbackup.sql
When that's done, Drop your existing database with (assuming your database name is "eq"):
drop database eq;
Create the database again:
create database eq;
... and then source the database with your file...
use eq;
source drdb2_2.sql;
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;
(if the last step, the GRANT... command, gives you an access denied error, exit out of mysql.exe & open it again via the command prompt with mysql.exe --user=root eq)
Then source in your character backup (using mysql.exe command prompt):
source charbackup.sql;
(Yes, it will give a 1 line duplicate entry, but don't worry about it)
|
Exit out of that when its done & you should be ready to go!
Once you get the hang of it, you should become fairly comfortable backing up, dropping, & sourcing in new databases for experimentation. You're only messing with the database after all, & that can easily be fixed by going back to your backups. Speaking of which, here's how to backup a solid, working (complete) database when you want to try a new one:
Quote:
Go to the mysql\bin directory from a command prompt window & type:
mysqldump eq > eqbackup00.sql;
(I number my database backups starting with "eqbackup00.sql", then "eqbackup01.sql, etc.)
|
If you have problems with the new database, just restore your old one by dropping the current one & sourcing in your backup. After awhile, this should become fairly routine (I've dropped & sourced in new databases well over a dozen times now). :P