Query to clean db accounts?

[jpxtreme]

I need to clean my account database for ascent. Is there a query to do the job? please help. I need to start with 0 accounts and characters.

[stoneharry]

Right click on the database, and find "truncate". This will clean all data from it. Alternatively, you can run the queries for all the tables:

DELETE FROM `accounts`;
DELETE FROM `account_data`;
DELETE FROM `characters`;
DELETE FROM `player_items`;

And so on.

[jpxtreme]

sorry but is there anything else need to be deleted? or only the one that you've posted.

i'm afraid i might delete the wrong one.

could you please indicate all the ones that need to be cleared.

thank you. + rep.

[Rock Lee]

USE `logon`;
TRUNCATE `accounts`;
USE `character`;
TRUNCATE `account_data`;
TRUNCATE `account_forced_permissions`;
TRUNCATE `arenateams`;
TRUNCATE `auctions`;
TRUNCATE `banned_names`;
TRUNCATE `characters`;
TRUNCATE `characters_insert_queue`;
TRUNCATE `character_achievement`;
TRUNCATE `character_achievement_progress`;
TRUNCATE `charters`;
TRUNCATE `clientaddons`;
TRUNCATE `command_overrides`;
TRUNCATE `corpses`;
TRUNCATE `gm_tickets`;
TRUNCATE `groups`;
TRUNCATE `guilds`;
TRUNCATE `guild_bankitems`;
TRUNCATE `guild_banklogs`;
TRUNCATE `guild_banktabs`;
TRUNCATE `guild_data`;
TRUNCATE `guild_logs`;
TRUNCATE `guild_ranks`;
TRUNCATE `instanceids`;
TRUNCATE `instances`;
TRUNCATE `mailbox`;
TRUNCATE `mailbox_insert_queue`;
TRUNCATE `playercooldowns`;
TRUNCATE `playeritems`;
TRUNCATE `playeritems_insert_queue`;
TRUNCATE `playerpets`;
TRUNCATE `playerpetspells`;
TRUNCATE `playersummons`;
TRUNCATE `playersummonspells`;
TRUNCATE `questlog`;
TRUNCATE `server_settings`;
TRUNCATE `social_friends`;
TRUNCATE `social_ignores`;
TRUNCATE `tutorials`;

Execute that in your database editor.

[jpxtreme]

thank you so much! very fast reply! + rep