I installed WP-DBManager 2.20 on my WP site. What does it mean to empty/drop a table? Is all data lost when that is done?
Yes the data would be lost and the data for that table would no longer be stored which would cause functionality issues as well.
What is the difference between dropping a table and emptying a table? Am I going to run out of space on my site once I reach 2,200 posts (considering 200 takes me to 9 MB)?
Dropping a table means basically that you’re deleting it. Emptying it means you’d get rid of the information in the table. Getting rid of the info in the tables would mess up your install so don’t do that. As for space issues, I’m not sure exactly how it works. Probably there’s some way you can optimize the database to hold more than that or maybe there’s a reason why only 200 posts are taking up 9 MB of space. Sorry, someone who knows more about that kinda stuff will have to help you 🙂
using that plugin i downloaded- it says wp_posts in the database has 2,222 records. i read somewhere else that WP 2.6 counts revisions- is there anyway to delete those old revisions and just keep the current versions? i have made a lot of revisions to all the posts. it also says data usage is 6.1 MB and index usage is 2.1 MB. any idea what those numbers mean and which is actually being consumed in my DB? 6.1 MB or 2.1 MB?
