If you need to test web site applications such as WordPress blogs, you can try XAMPP for Windows. It is an easy way to install Apache, MySQL and PHP and use them even without terminating the native Windows Internet Information Services. PHP/Apache and ASP/IIS web sites can run in the same time on a Windows machine. The […]
Tag: Phpmyadmin
If after a blog transfer or import etc you need to change the author of several posts, give them some author, if the author field is now blank, or attribute them to a different author, you can do it easily without a plugin (which may not even exist), just by using PhpMyAdmin. Enter PhpMyAdmin and […]
Adminer is a management tool that resembles phpMyAdmin, but works directly from a blog’s dashboard. You can use Adminer for basic database operations to avoid opening the control panel of your hosting provider to use phpMyAdmin. Adminer is able to restore a database backup, zipped or not, is easy to use and is reliable. Do […]
Some time ago you could use the category_name or cat keys in order to search for your posts using an SQL query at PHPmyAdmin. You cannot do this anymore since categories are replaced by taxonomy terms. In the following example you see a query you can execute through PHPmyAdmin in order to delete all posts […]
EasyPHP is a free installation package that will setup automatically on your PC a complete WAMP environment, so that a PHP developers can work in Windows. The package installs automatically PHP, Apache, MySQL, PhpMyAdmin, Xdebug. To use it, you don’t have to stop IIS (if you have it installed); just run the EasyPHP executable and […]
I tried some plugins promising that they will backup a WordPress database, only to discover how many problems they were able to cause. I need a plugin first of all able to create a reliable backup, then zip it and put it somewhere on the server, even restore it, if I need a restoration. The […]