Home / Tag Archives: phpmyadmin

Tag Archives: phpmyadmin

June, 2010

  • 30 June

    MySQL Server Optimization

    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 …

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 …