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 …
April, 2010
-
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 …