Home / Tag Archives: mysql (page 2)

Tag Archives: mysql

April, 2010

  • 28 April

    PHP: How to Select Multiple Database Tables

    Selecting a MySQL database table with a PHP document is a quick way to get certain output onto a web page with very little coding or effort. You may want nothing more than a simple printout of the database table or something more complex like a full web application. Regardless …

  • 19 April

    How to create a table using phpMyAdmin

    After you create a MySQL database, the next thing you will most likely want to do is to fill it with data. To do that, you need to setup tables. If you are installing a content management system or other type of script with an installer, it will probably create …

  • 14 April

    How to create backups with cPanel

    Many VPS and dedicated server users have cPanel installed as their control panel. Therefore, it is very useful to know how to create backups of your website or entire server using cPanel. Follow these instructions to make your backups. 1. Login to cPanel on your website (usually something like http://yourdomain.com/cpanel) …

  • 14 April

    How to create a database in phpMyAdmin

    In a previous post, we learned how to create a MySQL database from the Linux command line. Today, we will learn how to accomplish the same task with a graphical interface using the free web-based MySQL administration tool: phpMyAdmin. Just follow these steps. 1. Login to phpMyAdmin either through your …

  • 9 April

    Data migration tips

    Anytime you move to a new web host or upgrade to a new server, you will need to migrate your data. In the old days, data was often stored in flat files or simply directly within the HTML files. While the management eventually proved to be inefficient, it was much …

March, 2010

  • 25 March

    Database management with MySQL Workbench

    MySQL is one of the most popular databases for web servers. The MySQL website offers a free download of MySQL Workbench, a GUI database management program. I decided to download it and give it a try. It is available for Microsoft Windows, Mac OS X, and several versions of Linux. …

  • 3 March

    New server setup

    Question: I want to setup my own server. What software and tools will I need? Answer: The first major decision to make after you have purchased server hardware is what operating system to use. Many servers come with one already, but if yours does not, you will need to decide …

  • 1 March

    Twitter the latest among big players to leave MySQL for Cassandra

    With a name that even sounds like the beautiful love interest of a secret affair, Cassandra appears to be positioning itself to steal the hearts of those once in love with MySQL. Twitter is now set to replace its MySQLdatabase system with the open source home wrecker. Cassandra was originally …

February, 2010

  • 17 February

    How to check and optimize MySQL databases automatically

    MySQL databases require regular maintenance, but usually the databases just need to be re-optimized and checked for errors. In such cases, having to go through each database on your server can be time consuming. Following these steps, you can setup a cron job that will automatically check and repair your …

  • 11 February

    Micro-blogging on your own domain with StatusNet


    Twitter has become very popular in a short amount of time. With it, users can post short updates about what they are currently doing, working on, thinking, or viewing/accessing. For businesses, it is a good way to communicate with others who might not be in the same office or even …