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
MySQL - Category Archive
How to Export a MySQL Database With Only Location, Username, and Password Using MySQL Workbench
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