Tamarae,
Here are some mysql commands for database backup/ restoration:
To dump entire database into a backup file:
mysqldump --opt database > backup-file.sql;
To Restore database back:
mysql database < backup-file.sql;
To dump a single table:
mysql> SELECT * FROM account INTO OUTFILE 'account.txt'
-> FIELDS TERMINATED BY ','
To restore table data dumped in previous command:
mysql> LOAD DATA LOCAL INFILE "account.txt" INTO TABLE event
mysql> ->FIELDS TERMINATED BY ',';
BTW: I noticed some of your mobs are now KOS even though they don't attack when in agro range. They do assist correctly now though.
Bill
__________________
What is the sound of one hand slashing?
|