MySQL

Remove weird special characters from your WordPress Database

A few months ago I had to restore our website from a backup, and noticed that when I did so almost all of the posts that we have done had weird special characters inside them. I started to manually edit the ...

Read More »

How to install a LAMP (Linux, Apache, MySQL, PHP) stack on CentOS/RHEL

What is a LAMP Stack? A LAMP stack is a group of software that you install on a server to serve your own websites. Much like how this blog is being served to you, I purchased a VPS and then ...

Read More »

How to quickly and efficiently delete all data in a LARGE MySQL table using TRUNCATE

If you have a very large table in MySQL and you need to delete all the data from it. Instead of using the DELETE syntax or DELETE FROM tablename; It is best to use the TRUNCATE syntax. This will delete all data ...

Read More »