How to Reset A Database?

[axewound]

I have a server i hosted a few years back, but it has all the old players with there accounts on it.
the prob is it was a high exp server, and i'm leaning towards a low exp server now.
but inside my database file i have to select one by one, and delete the players/accounts..
selecting them all still only deletes one.
does anyone know how to remove them all without removing the Account manager?

 

[Royal Inferno]

I don't know if you can reset it, but I know you can drop it, then it's totally gone, and you can make it from the beginning, if that is what you asked for

 

[Deleted member 148307]

DELETE FROM `DBNAME`.`accounts` WHERE `accounts`.`id` > 1;

This command deletes all the characters and accounts except account manager.

 

[Hanoger]

But if is he using samples, then:

DELETE FROM `DBNAME`.`accounts` WHERE `accounts`.`id` > 5;

 

[Deleted member 148307]

But if is he using samples, then:

DELETE FROM `DBNAME`.`accounts` WHERE `accounts`.`id` > 5;

Account manager and samples are in one account with id 1. I recommend you take a look at TFS schema.

 

[axewound]

My issue is I'm using a sql editor to edit the Database files(were all the server info is saved) so inside my xamp, it has none
of the info from the server. =\

 

[Deleted member 148307]

MySQL or SQLite ?

 

[axewound]

sqlType = "sqlite"

 

[Hanoger]

Account manager and samples are in one account with id 1. I recommend you take a look at TFS schema.

Woops, yeh, my mistake, sry

 

[Agataa]

MySQL or SQLite ?

MySQL <