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

[N e s s]

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

 

[kisuka]

Can you explain what you mean by 'reset'?

 

[aero011]

Delete all tables then Import your fresh sql files~

 

[N e s s]

Delete all tables then Import your fresh sql files~

no deletion of accc and items will done?

 

[Emistry]

use 

TRUNCATE `table_name`;
do this for all the table that you want to reset.

 

[N e s s]

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?

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

 

[evilpuncker]

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

 

[N e s s]

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

how to do that sir ? newbie

 

[jaBote]

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.