pajodex 0 Posted May 1, 2014 How can I wipe all of the data in database without re-doing the database. I mean A total server wipeout. Quote Share this post Link to post Share on other sites
0 Emistry 145 Posted May 1, 2014 shut down server and truncate all the sql table. Quote Share this post Link to post Share on other sites
0 pajodex 0 Posted May 1, 2014 If you dont mind, how do I do it? I mean the code in Sql. Sorry i have no idea Quote Share this post Link to post Share on other sites
0 jaBote 438 Posted May 1, 2014 TRUNCATE TABLE `table_name1`;TRUNCATE TABLE `table_name2`; And so on. If you don't have permissions to truncate tables, I'd reccommend you to use: DELETE FROM `table_name` But what I should truly reccommend is dropping all tables for the database then loading them again, which can even be faster than that. Quote Share this post Link to post Share on other sites
0 pajodex 0 Posted May 1, 2014 Okay, thank you so much Quote Share this post Link to post Share on other sites
How can I wipe all of the data in database without re-doing the database. I mean A total server wipeout.
Share this post
Link to post
Share on other sites