Menu
  • Home
  • Having fun
  • Tech Tips
  • Contact Me
  • About Torbjorn
  • Resources
  • Software

Torbjorn Zetterlund.

Tag: MySQL

→

Find everything Torbjorn has written about MySQL

How To Safely Rename a Database in MySql

How To Safely Rename a Database in MySql

In My Work, Web DevelopmentTags Database, Linux, MySQLMarch 8, 2015Leave a comment Torbjorn Zetterlund

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. …

Continue Reading
How to setup a MySql replication database for WordPress

How to setup a MySql replication database for WordPress

In My Work, Web DevelopmentTags Content management system, Linux, MySQL, PHP, WordPressMarch 7, 201516 Comments Torbjorn Zetterlund

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 …

Continue Reading
So you want to monitor your MySql replication database

So you want to monitor your MySql replication database

In Data Analysis, My Work, Web DevelopmentTags Linux, MySQLFebruary 10, 20152 Comments Torbjorn Zetterlund

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 …

Continue Reading
Connecting backend CodeIgniter to two databases after receiving an API call

Connecting backend CodeIgniter to two databases after receiving an API call

In Software Development, Web DevelopmentTags CodeIgniter, MySQL, Software Development, Web ApplicationsNovember 26, 20141 Comment Torbjorn Zetterlund

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 …

Continue Reading
Converting data from MySQL to MongoDB

Converting data from MySQL to MongoDB

In My Work, Web DevelopmentTags Converting data, MongoDB, MySQLOctober 11, 2014Leave a comment Torbjorn Zetterlund

There is no straight way of converting data from MySQL to MongoDB, but there are a few techniques that you can use. …

Continue Reading
Merging two MySql tables

Merging two MySql tables

In Web DevelopmentTags MySQLSeptember 2, 2013Leave a comment Torbjorn Zetterlund

How to merge two MySql tables that have the same structure and were the primary keys of the two tables will clash. …

Continue Reading
Useful mysql to remove / in a db column

Useful mysql to remove / in a db column

In Software Development, Web DevelopmentTags Big Data, MySQLAugust 31, 2013Leave a comment Torbjorn Zetterlund

Here is a handy sql statement for removing a trailing ‘/’ in the column url …

Continue Reading

MySql Store Procedure (Routine) to break a date range into a record per day for reporting

In Web DevelopmentTags Big Data, Database, MySQLNovember 30, 2011Leave a comment Torbjorn Zetterlund

Problem! Project resource assignments are tracked in an Excel Spreadsheet, the following data as outlined in the table below is tracked. …

Continue Reading

Recover root Password for MySQL

In Web DevelopmentTags Database, MySQL, PHPNovember 30, 2011Leave a comment Torbjorn Zetterlund

You can recover MySQL database server password with following five easy steps. …

Continue Reading
How to repair a corrupt MySQL Database

How to repair a corrupt MySQL Database

In Software Development, Technology, Web DevelopmentTags Big Data, Database, MySQLNovember 30, 2011Leave a comment Torbjorn Zetterlund

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 …

Continue Reading

Posts navigation

1 2 3

Site Footer

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in settings.

Torbjorn Zetterlund
Powered by  GDPR Cookie Compliance
Privacy Overview

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.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.