ghacks Technology News

Incredibly simple MySQL administration with SQL Buddy

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

Check and repair corrupted tables on MySQL database

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

Create and manage databases in Linux with Glom

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

Basic postgresql server setup

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

Creating forms to aid OpenOffice.org Base data entry

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

How to create a database with OpenOffice Base

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 Software Db2rss

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 Internet Movie Script Database IMSDb

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

Set up MySQL database replication

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

Page 1 of 212

© 2005-2012 Ghacks.net. All Rights Reserved. Privacy Policy - About Us