I just got done deleting a bunch of rows on a WordPress MySQL Database only to find that the database didn’t get any smaller! In my case, I deleted about 450,000 total rows, which is obviously a lot! For some reasons this install isn’t deleting wp_session entries in the wp_options table, and they had been accumulating for years. More on … Read More
If you have only the name, location (ip address or web address), and password for you WordPress or other MySQL database, it is possible to easily export the entire database into one single .sql file without having any other admin privileges or the phpmyadmin link. We will be using a free tool called MySQL Workbench. You can download the latest … Read More
DISCLAIMER: Unless you know exactly what you are doing, please back up your database in multiple ways before attempting this. I am not responsible for any lost data if you remove or otherwise change your database without it being backed up properly. See also: What to do if your WordPress site does go down. If you’re like me, you have … Read More
