EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Blank database with doors and zonelines? (https://www.eqemulator.org/forums/showthread.php?t=29110)

Kiniyen 08-02-2009 05:10 PM

Blank database with doors and zonelines?
 
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 08-02-2009 06:11 PM

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 08-02-2009 07:16 PM

Thank you, exactly what I needed :)

trevius 08-02-2009 07:51 PM

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.


All times are GMT -4. The time now is 09:45 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.