Categories
Learning Journal

Is MySQL Up?

These days I’m trying to develop a BASH script to help me copy quickly my MySQL database from my (live) remote site straight into my PC, where I do all my development work. Right at the top of the script I was writing, I needed a way for the script to figure out if the (development PC‘s) MySQL server (mysqld) was already started and running. And if not, to let me know.

Categories
Learning Journal

Backup MySQL databases

There are so many ways to back up your MySQL databases (and tables) and all of them work just as well… until the database (DB) tables get really big.

Categories
Learning Journal

Create a MySQL Table with PHP

One thing I often asked myself, when I first started programming in PHP, was How do I create a MySQL database table with PHP? Of course, I have come a long way since then, and creating a MySQL table from within a PHP script is no longer a mystery to me.