How do I empty my MySQL Database?

I want to clear my Wordpress MySQL database but I dont want to delete it.

How do I clear all the tables of data without deleting the structure or the database or the tables?

Thanks,

JH

 

hop into either Navicat or your phpMyAdmin - anywhere you can run SQL on your DB. then execute this query for every table

Delete from [tablename]

I would backup the tables first though

 

1. Login into your phpmyadmin.
2. Select the tables you want on the left handside.
3. Check the tables you want to empty, there is a drop down menu at the bottom right, choose empty.

Make sure you do a complete backup first

 

Thanks guys, I'll try these suggestions.

JH

 

OK, this backfired.

I wanted to empty the data but not have to reinstall the whole Wordpress blog again. In other words, I wanted to get rid of all the posts inside the blog.

Any way I could do that?

JH

 

In phpmyadmin click "Empty"

 

Yeah, I did that but it made me reinstall my whole blog.

 

yeh u deleted the database structure. To delete the content, go into the table that has the content, and select all rows and drop them.