If you have a need to manage MySQL databases, you know that learning the syntax for the various MySQL tools can be a real nightmare. Fortunately there are tools out there that make this job far more easy. But of the web-based tools, which are easiest? You might have given phpMyAdmin a try, but found [...]

Categories: Linux, Open Source, Server, Software, Tutorials Basic

This morning I woke up to find one of the sites I administer down. The error on the page was very clear in that it could not connect to the database due to a corrupt table. I had two choices, recover from a backup or attempt to repair the corrupted tables. I opted to try [...]

Categories: Advice, Linux, Open Source, troubleshooting, Tutorials Advanced

If you’ve ever had to work with a database in Linux you most likely are aware of three or four tools that can handle the task: MySQL, PostgreSQL, PhpMyAdmin, and OpenOffice Base. These are all outstanding applications, but the first two are complex command-line only tools, the third requires a web server, and the last [...]

Categories: Advice, Linux, Open Source, Software, Tutorials Advanced, Windows

So many tool require databases. If you are a web administrator or a company with large stores of information, then you know the importance of databases. One of the most oft-used databases available is MySQL. But that is not the only player on the court. Another cross platform object-relational database management tool is PostgreSQL. Many [...]

Categories: Linux, Open Source, Software, Tutorials Advanced

In the first entry to this “series” I worked through the process of creating a database with OpenOffice.org Base (“How to create a database with OpenOffice Base“.) Upon completion of that article you found yourself with a working database with no data. Fortunately OpenOffice Base includes tools to help you add data to your database. [...]

Categories: Advice, Linux, Open Source, Software, Tutorials Basic, Windows

If you have ever used Microsoft Office Access you know that the database is a powerful component of office life. There are many reasons to create databases. For some databases are a way of life (or a way to make a living). For others databases are a means to keep tabs on inventory, collections, or [...]

Categories: Linux, Open Source, Software, Tutorials Basic, Windows

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

It is pretty obvious that the developers of the Internet Movie Script Database have taken lots of inspiration from the Internet Movie Database IMDB. The website offers movie scripts that can be viewed online or downloaded as txt files to a local computer system or mobile device. It is possible to search the database or [...]

Categories: Entertainment

If you use databases then you know how important it is to back them up. But backing up a database and being able to use that backup depends upon the back up being always up to date. There is a method that ensures you will always have an up to date backup. That method is [...]

Categories: Advice, Linux, Open Source, Software, Tutorials Advanced