Blank database with doors and zonelines?

[Kiniyen]

Is it possible to get a blank database with just doors, objects, and zonelines anywhere? If could anyone help me with the sql commands to drop all the data besides these items?

[KLS]

To delete all the data in a table the mysql syntax is:

DELETE FROM tablename;

Just plug in one of those for every table you want empty.

[Kiniyen]

Thank you, exactly what I needed

[trevius]

Also, if using Navicat, you can simply right click the table and select "Empty Table" to do the same thing. I commonly use that to empty out the hackers table.