Home / Tag Archives: database (page 2)

Tag Archives: database

April, 2010

  • 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. …

  • 23 March

    Quad-Core vs Dual-Core servers

    Many web hosts are proudly offering servers with single quad-core processors or with two dual-core processors. While they certainly sound impressive, are there actual benefits? Does a quad-core system deliver better results than a dual-core of the same processing speed? The truth is that it depends on what the server’s …

  • 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 …

  • 5 February

    Before you commit your data…

    When you have a small to medium-sized business (SMB), it is tempted to take lowest service offer, especially when a vendor makes big promises. There are plenty of database vendors on the market, and some of them offer very attractive custom proprietary packages or cloud computing solutions. But before you …

December, 2009

  • 21 December

    How to create a MySQL database in cPanel

    Question: How can I use cPanel to create a MySQL database? Answer: cPanel uses its own web-based frontend to make database creation very easy. Just follow these simple steps: 1. Login to cPanel 2. Under the Databases section, click “MySQL Databases” 3. Where it says “Create New Database” enter a …

November, 2009

  • 26 November

    Restoring a huge MySQL database

    Question: I have a shared hosting account but need to import a 3GB MySQL database. I do not have shell access, and phpMyAdmin always times out. How can I restore it? Answer: You can use a script called BigDump to import your dumped MySQL database a little at a time. …

September, 2009

  • 15 September

    How to Import a MySQL Database

    In a previous post, I explained a couple methods of exporting MySQL databases. Today, we will do just the opposite: import a mysql database. As with the previous example, you may use either phpMyAdmin, your web hosting company’s custom control panel interface (if available), or the Linux command line, if …

  • 4 September

    How to Export a MySQL Database

    Question: How do I export and download a MySQL database? Answer: There are two primary ways to export a MySQL database if you are a website owner. The first is to use phpMyAdmin, a web-based graphical interface for managing databases. The second is to login through SSH and use MySQL …