This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Tag: MySQL
-
How to monitor you replicated MySql database
You have finished setting up your MySQL replication, next you need to periodically monitor your replication to ensure that MySql replication continues to work seamlessly. You can monitor the MySql replication with some basic commands, I have summarized them below.
-
How To Safely Rename a Database in MySql
So you want to Safely Rename your MySql Database, here is a tip on how to do it. If you do not have phpmyadmin installed on your server, then below are the steps to safely rename a MySql database.
-
How to setup a MySql replication database for WordPress
WordPress uses MySql database to store all the plugin options, theme options, your pages, your posts, users and comments, with more visitors your site need to be able to scale or in my case, I had user spikes (increased traffic) that took out the connection to MySql, as memory on the server was used up.…
-
So you want to monitor your MySql replication database
You have configured your MySql replication, the next step is to perform maintenance and monitor your replication. Percona Toolkit for MySQL is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks.
-
Connecting backend CodeIgniter to two databases after receiving an API call
The use case I got was to connect to a 2nd Db, to retrieve data from a 2nd database and respond with a JSON string, the request would come in as an API call that looks like this “localhost/api/1/noonreport?API-KEY=oBThDgLsHOi8WJpwgf6IvJVQQ45E9LTudUN9i1RL”
-
Converting data from MySQL to MongoDB
There is no straight way of converting data from MySQL to MongoDB, but there are a few techniques that you can use.
-
Merging two MySql tables
How to merge two MySql tables that have the same structure and were the primary keys of the two tables will clash.
-
Useful mysql to remove / in a db column
Here is a handy sql statement for removing a trailing ‘/’ in the column url
-
MySql Store Procedure (Routine) to break a date range into a record per day for reporting
Problem! Project resource assignments are tracked in an Excel Spreadsheet, the following data as outlined in the table below is tracked.
-
Recover root Password for MySQL
You can recover MySQL database server password with following five easy steps.