how to reset the database ?

[waturl]

Hello, i found:

 

TRUNCATE `tblaccounts` ;

TRUNCATE `tblaffiliates` ;

TRUNCATE `tblaffiliatesaccounts` ;

TRUNCATE `tblbillableitems` ;

TRUNCATE `tblcancelrequests` ;

TRUNCATE `tblclients` ;

TRUNCATE `tblcontacts` ;

TRUNCATE `tblcustomfields` ;

TRUNCATE `tblcustomfieldsvalues` ;

TRUNCATE `tbldomains` ;

TRUNCATE `tblemails` ;

TRUNCATE `tblhosting` ;

TRUNCATE `tblhostingaddons` ;

TRUNCATE `tblhostingconfigoptions` ;

TRUNCATE `tblinvoiceitems` ;

TRUNCATE `tblinvoices` ;

TRUNCATE `tblorders` ;

TRUNCATE `tblticketlog` ;

TRUNCATE `tblticketnotes` ;

TRUNCATE `tblticketreplies` ;

TRUNCATE `tbltickets` ;

 

but how to do that ? any more details ?

[bear]

This can be done through PHPMyadmin if that's installed, or via command line if you have shell access and the correct permissions. Alternately, you could probably set this into a PHP script if you know how to do that.

[waturl]

I'm now in php admin, i can see "use table" with all table list, so what to do here exactly ?

[waturl]

well, i did it, it works, thnx