Some Linux distros now come installed with MariaDB instead MySQL. MariaDB is a fork of MySQL due to licensing fears by others about Oracle. Sun Microsystems bought MySQL and Oracle bought Sun for ownership of MySQL. Here are comparisons between MariaDB and MySQL. From InfoWorld, Dice, and SkySQL.
What do you do if your database server is down? Well, you can certainly reboot the server. That might solve the problem, but I rather restart the database first before doing something as drastic as rebooting a server. There are instances were rebooting doesn’t always solve the problem if there’s an issue with the database. Now, most open-source blogs and web applications today use MySQL as their database of choice. So, here are instructions on how to start, stop and restart MySQL on Ubuntu and Debian-based systems.
Stop MySQL database
$ sudo /etc/init.d/mysql stop
Start MySQL database
$ sudo /etc/init.d/mysql start
Restart MySQL database
$ sudo /etc/init.d/mysql restart
I want to share a database connection access problem I had last week, while working with a custom PHP script inside WordPress. I had created this WordPress Page Template containing some PHP code that needs access to the database. The problem was that the database connection for my custom script overwrote the WordPress database connection that was previously establish, causing certain parts of WordPress to not display properly.
It took me a while to figure out that it was the newer database connection of my custom PHP script that was causing the previously established WordPress database connection to disappear. Hence, certain parts of the WordPress page were not displayed. Little did I know, that the fix was quite simple. So, here’s a sample of my mysql_connect code. Prior to this line, I’ve already set the variables.
Simply add a fourth parameter called new_link and set it to TRUE.
What this does is basically telling mysql_connect to establish a new connection, while keeping the older mysql_connect connection around, in case we need to access it at a later time. It’s amazing how one little switch in a command can make a huge difference to this seemingly simple code. Anyways, adding a fourth parameter and setting it to TRUE was the solution.