Thread: 3.12 Delta#2
View Single Post
  #24  
Old 11-20-2002, 10:55 AM
BootyBill
Fire Beetle
 
Join Date: Nov 2002
Posts: 27
Default

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?
Reply With Quote