Most webmasters have started to learn HTML before they moved on to programming languages such as PHP. With PHP come databases like MySQL as the primary storage for project data. Many popular online applications, such as WordPress, use the PHP and MySQL combination to power sites online. You usually do not need to know PHP [...]

Categories: Online Services, Web Development

Recently I covered the MySQL GUI tool MySQL Administrator (see the article “Create a database with MySQL Administrator“). However, this tool was just given the official EOL (End of Life) announcement by the MySQL dev team. Although this is sad news for a tool that had recently become my standard for working with databases, this [...]

Categories: Linux, Open Source, Software, Tutorials Basic

A website that is run by one of my friends got hacked recently resulting in several unpleasant manipulations like redirecting visitors to another domain. My friend suspected that the hacker manipulated the MySQL database of the website but there was not an easy way to find out. The only way he could think of was [...]

Categories: Linux, Software, Windows

My last article illustrated how to manage your MySQL databases with a simple (albeit outdated) GUI MySQL Navigator (see my article “Manage your MySQL databases with an easy to use GUI“). Although that tool is outdated, it does still work for basic functionality. But there are better tools for managing your MySQL databases. One of [...]

Categories: Linux, Open Source, Software, Tutorials Basic

If you’ve read my Linux content here on Ghacks enough, you have most likely noticed my preference for not using the MySQL command line. That is not to say I don’t ever use it, I just prefer tools to help make that aspect of database use easier. My preference, until recent, has been PhpMyAdmin (see [...]

Categories: Linux, Open Source, Software, Tutorials Advanced

Database monitoring is not only important for businesses who want to monitor their online and offline services and applications but also for individuals. Webmasters who make use of databases like MySQL need to make sure that the databases are up and running and the best way to ensure that is to monitor them 24/7. Quite [...]

Categories: Software, Windows

The post Using Cron to Automate Linux Tasks by Jack got me thinking that some users might be interested in a practical example. The following tutorial will explain how to setup a small script to backup MySQL databases on a Linux server which will be run daily using a cron job. The best way to [...]

Categories: Linux, Tutorials Basic

It is sometimes necessary to convert between data formats. This is most of the time the case if you have a data format that is not accepted by a specific software. Adding the data manually is usually not an option which means that it is only possible to convert the data from the original data [...]

Categories: Software, Windows