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 …