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 [...]

Tags: database, database user, mysql, postgresql, ubuntu server
Categories: Linux, Open Source, Tutorials Advanced, software

Running a local Apache web server is essential for many webmasters. It is always a good idea to test code locally before publishing it on the Internet. Professional webmasters usually test their code in a local web server before it gets published. Mainly to avoid possible downtimes in the live environment but also to avoid [...]

Tags: apache, apache server, apache web server, mysql, php, wampserver, webmaster, xampp
Categories: Open Source, Windows, software

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 [...]

Tags: blackfish sql, database, database monitoring, db2rss, interbase, mysql, mysql database, Network Monitoring
Categories: Windows, software

If you’ve read enough of my Ghacks tutorials you have most likely come across mention of a LAMP server. If you are not sure what a LAMP server is:

Linux
Apache
MySQL
P (can mean PHP or PERL – depends upon your needs)

LAMP servers are very popular, cheap, effective, flexible, and reliable servers. But how are they installed? Actually, [...]

Tags: apache, LAMP, lamp server, mysql, php, tasksel
Categories: Linux, Networks, Open Source, Server, Tutorials Basic, software

Webmasters have to make sure that their websites and files are getting backed up regularly to be prepared when something unforeseen happens. This unforeseen event can be a hacker attack, a database crash, a fire in the data center of the hoster or human error. Whatever the cause is it can have a severe impact [...]

Tags: database backup database, gmail, linux server, mysql, mysql backup, mysql database backup, server, sql backup
Categories: Online Services, Server

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 [...]

Tags: database, database replication, Linux, mysql, replication
Categories: Advice, Linux, Open Source, Tutorials Advanced, software

Last week was a bit less active in web development terms, but here’s a roundup of what you can find on Scriptastique if you haven’t been taking a look recently.
We had a look at how a mysql query basically works, which will come in handy if you’re just learning about MySQL and PHP. The [...]

Tags: mysql, php, web development
Categories: Web Development