how can i reset my database (all sql files in phpadmin)

[N e s s 3]

how can i reset my database in my php admin? without no lost of account and items? thanks in advance!

[kisuka 178]

Can you explain what you mean by 'reset'?

[aero011 3]

Delete all tables then Import your fresh sql files~

[N e s s 3]

Delete all tables then Import your fresh sql files~

no deletion of accc and items will done?

[Emistry 145]

use 

TRUNCATE `table_name`;

do this for all the table that you want to reset.

[N e s s 3]

use 

TRUNCATE `table_name`;

do this for all the table that you want to reset.

sir do you think if i reset elemental db this bug will be fixed now?

 

[evilpuncker 503]

make a backup, reset, test, if not fixed, re-import the backup

[N e s s 3]

make a backup, reset, test, if not fixed, re-import the backup

how to do that sir ? newbie

[jaBote 438]

You can directly do a full database clonation (not an effective backup but will do the job) on the latest PhpMyAdmin versions by using the operations or tools tab (not sure, not using the English PhpMyAdmin version but there's a wrench icon on it) inside a DB.

 

Anyways, I honestly think your question is incomplete. You want to delete ALL but accounts, characters (I suppose) and items? What about guilds, homunculi and pets, or even the account, character and server vars? And so on with other questions related to other possible valuable data.