In this article, we will talk about how to backup large MySQL databases. If you simply want to export a copy of your small database and do not want to use PHPMyAdmin, you can do so using a few click method from within the backup functionality in SiteAdmin or cPanel. Let’s […]
From time to time it is a good idea to do a some housekeeping within your applications or websites database. This is because MySQL, like your bedroom when you were a kid – does not clean itself. If you have a large database and have a lot of traffic to […]
phpMyAdmin is a database management tool used for mySQL databases. It allows you to easily modify databases with a friendly user interface. Please note that when you try to access phpMyAdmin, it will open in a new window. Some popup blockers may prevent this and should be adjusted accordingly. If you are having […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to use the Search feature Click the database you wish to search here Then click the Search button Enter words or values to search for in the database. There are several options you can use to refine your search. You can also […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to rename database tables Click the database table you wish to rename Now click the table you wish to rename Then click the Operations button Enter a new name for the table here Then click Go That’s it! This is the […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to run SQL queries on a database Click the database table you wish to run a SQL query on Click the SQL button here Then type the SQL command you want to execute Now click Go That’s it! the SQL […]
This tutorial assumes you’ve already logged in to phpMyAdmin Note: Per our Terms Of Service database sizes are limited to 2GB on our shared/reseller servers. This restriction does not occur on VPS servers. Now let’s learn how to import a table into a database 1) Click the database you wish to import your table(s) to […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to delete a table from a database Select the table you wish to delete here Click the Drop button here. Then click OK to confirm The table has been deleted (or dropped) from the database This is the end of the tutorial. […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to create a table within a database Select the database here Enter a Name for our new table Then enter the number of fields this new table is to have. Click Go Now enter the details of each field within the new table […]
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to copy a database table Click the database table you wish to copy Then click the Operations button When copying a table, you can choose to copy the table structure only, the data only, or both. Enter a name for […]
