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. …
Tag: MySQL
Find everything Torbjorn has written about MySQL
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 …
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 …
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 …
There is no straight way of converting data from MySQL to MongoDB, but there are a few techniques that you can use. …
How to merge two MySql tables that have the same structure and were the primary keys of the two tables will clash. …
Here is a handy sql statement for removing a trailing ‘/’ in the column url …
Problem! Project resource assignments are tracked in an Excel Spreadsheet, the following data as outlined in the table below is tracked. …
You can recover MySQL database server password with following five easy steps. …
For various reasons, database tables could get corrupted, and when it happens you should not panic. Reasons could be many, table corruption should be rare when using MySQL (though an overheating server continually restarting at the …