Change and Update WordPress URLS in Database

After migrating a WordPress site to a new URL either to a live production or a testing development server, the new URL strings in the mysql database need to be changed and updated in the various mysql database tables.

This method just uses the whole mysql database rather than a WordPress export/import from within, and is best suited for a straight swap. So you would copy all the WordPress files/folders to the new destination, set the correct ownership to those files,  then do the database switcheroo.

[Read more…]

How to monitor sql queries with zabbix

If you want to monitor some parameters in mysql database,  you can do it with ODBC monitoring in Zabbix.

ODBC monitoring corresponds to the Database monitor item type in the Zabbix frontend.

ODBC is a C programming language middle-ware API for accessing database management systems (DBMS). The ODBC concept was developed by Microsoft and later ported to other platforms.

[Read more…]