Home •Search •Dr. Hain •Clinic website •Information for Dizzy Patients •Music •FLW • Various and Sundry
Last edited: October 10, 2021
Mysql is a very useful database that runs on Linux machines. It is relied upon and for this reason doesn't undergo as many of the updates that are constantly "improving" PHP. Mysql is most easily manipulated using phpmyadmin, another utility program that provides a web interface. There are a few "gotchas" to Mysql that seem to have escaped documentation. We are writing here about ubuntu.
1. Remote connection to mysql requires both setting up permissions and allowing remote "binding". In addition, not said in the documentation is that the mysql password must be "strong", for a remote connection. Mysql doesn't care about this when you are connecting through localhost.
Backing up mysql is essential in this day of hackers. It is strangely difficult to accomplish this. I have had the most success with the following program:
automatic backup scheduler for mysql.
This paid (one time) program that gets some used to, but with trial/error, it is OK. The program is a windows front end for the mysql database utilities that transfer databases from one server to another, or run "mysqldump" which saves the database as a text file. It has a whole lot more function embedded in it that a casual user will every want to know.
This program is very strange under windows. It doesn't start up as one would expect, and just minimizes itself. When you minimize it, it goes to the task bar. When you run it as a service, it doesn't always respond to more direct interactions.