…here. SiteAdmin To access phpMyAdmin from within SiteAdmin, click databases from the left-hand menu in SiteAdmin, then click phpMyAdmin. cPanel To access phpMyAdmin from within cpanel, go to the databases section, then clikc phpMyAdmin. phpMyAdmin Instructions Creating Database Tables Copying Database Tables Deleting Database Tables Exporting Database Tables Importing Database Tables Renaming Database Tables Searching Through Database Tables…
…optimal database performance. Note: WordPress users are able to install 3rd party plugins to will assist them in the optimization and repair process without the need for PHPMyAdmin. How to optimize your database tables using PHPMyAdmin How to repair your database tables using PHPMyAdmin Optimizing your database tables We will be demonstrating how to optimize your MySQL tables. Note: Some tables can not be optimized. 1) Log into your…
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 command has been executed. For more information on learning about SQL query syntax, visit the MySQL documentation available here This is the end of the…
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 limit your search to specific tables here. When ready, click Go to perform the search The search found one match. Click Browse…
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 We also want this first field to be the Primary key that will be automatically filled in (auto_increment) when new entries are added to…
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 the new table here, then click Go Copying a table actually creates a new table altogether (that’s identical to the one we’re…
…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. You now know how to delete tables from a database using phpMyAdmin…
…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 end of the tutorial. You now know how to rename database tables using phpMyAdmin…
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 here 2) Click the Import tab 3) Select the file you wish to import 4) Click the Go button at the bottom of the page…
…this section, we will show you how to check the size of your database so you can know if you can use Zip, or if you need to use another compression type. 1) Login to SiteAdmin or cPanel 2) From the Databases section, click phpMyAdmin 3) Click on the database you wish to check 4) Locate the total size at the bottom of the size column How do I backup a MySQL database using compression? In this section, we will show you how to make a backup…
