If you are running a dedicated server, optimization is very important to maximize speed, efficiency, and save time and energy. We have already looked at ways to optimize Apache web server, but many dynamic websites also use databases that hold the data for their dynamic web applications. You can accomplish …
June, 2010
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 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 …
December, 2009
-
28 December
How to manually grant privileges in MySQL
There are plenty of reasons why you might want to grant various privileges to a user in MySQL manually rather than with a control panel or phpMyAdmin. But regardless of the reason, the process is quick and easy, once you learn how to do it. For this you will need …
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. …
October, 2009
-
28 October
Database Management with phpMyAdmin
Question: I have a shared hosting account and need an easy way to manage my databases. What can I use? Answer: Chances are, if you are using a server that has both PHP and MySQL, your web hosting provider has given you some type of tool to manage your databases. …
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 …