MySQL

LAMP servers – the solution for dynamic websites

If independently installing the software package for your hosting project is your goal, then you might consider choosing one of the many free components out there. Sooner or later you are bound to encounter the widely used and very popular LAMP stack software bundle. But what exactly makes this package so attractive in comparison to alternative options?

Learn MySQL in simple steps

Along with Oracle and Microsoft SQL server, MySQL is one of the most popular management systems for relational databases. Nowadays the software developed by MySQL AB belongs to the product portfolio of the Oracle Corporation and is proprietarily marketed under a dual license. Since 2009, an open source MySQL fork, known as MariaDB, has also been available from the original developers. Here we give...

How does data backup work for databases?

Backing up your data is a popular option for securing your database. In order to create backup copies, you need additional hardware and to install a suitable backup structure. How do you secure your own network and web server against attacks and proceed to protect your databases?

Creating backups with MySQLDumper

“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.

WordPress Migration: Tips for server migration

There is much more going on behind WordPress blogs than the average visitor is aware of. In addition to texts, pictures and other graphics, it is primarily the behind-the-scenes aspects like plugins and user settings that make the site what it is. All of these features have to be taken into account when migrating from A to B. Thanks to tools like migration plugins, moving your WordPress blog to a...

papaya CMS: content management for professionals

  • CMS

The CMS, papaya, is lauded by its developers as a high performance content management system – a fully justified claim, considering the software’s wide range of smart and powerful functions. But is papaya CMS a viable option for any web project? And what exactly are this program’s strengths and weaknesses?

Composr 10: the new CMS from ocPortal

  • CMS

The UK-based CMS ocPortal has undergone a rebrand: presenting Composr 10. Following in the footsteps of ocPortal 9, this CMS offers an all-in-one solution for web presences, with no need for extensions or templates. But who is Composr 10 suited to? And how does it compare to the CMS market leaders?

Alchemy CMS: the CMS based on Ruby

  • CMS

While most content management systems are based on the PHP scripting language, Alchemy CMS uses a less common but more dynamic programming language: Ruby. There are also countless add-ons available from Ruby on Rails that can help to extend your web framework to create complex projects like company websites or online shops. Find out what makes this intuitive CMS a good bet for beginners.

SQL injection: Fundamentals and safeguards

There are daily reports on how security gaps in applications are exploited – because hardly a day goes by without a new gap being discovered or a known gap being closed. One attack method, which has always been based on exploiting such weak points, is called SQL injection. But what is actually hidden behind the malicious database exploitation and how can you protect your database system from it?

Magento: an introduction to the open source software

  • CMS

Many contemporary content management systems such as WordPress and TYPO3 can be used to design and program web stores with the help of plugins. But depending on the CMS, plugins can be pretty inconvenient to manage, making them a poor choice for larger projects. Some content management systems like Magento, however, are specially tailored for e-commerce, and therefore present a considerably more...