Site5 - Built For Designers & Developers MENU
Home  ›  Databases  ›  PHPMyAdmin

phpMyAdmin: How to Backup Large Databases

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 […]

phpMyAdmin: Optimize & Repair Tables

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 Overview

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 […]

phpMyAdmin: Searching through a database

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 […]

phpMyAdmin: Renaming database tables

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 […]

phpMyAdmin: Running SQL queries on a database

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 […]

phpMyAdmin: Importing databases and tables

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 […]

phpMyAdmin: Deleting tables from a database

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. […]

phpMyAdmin: Creating tables in a database

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 […]

phpMyAdmin: Copying a database 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 […]

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.