Web Hosting Contact

How-to Guides, Tips & Tricks

Category: PHP and MySQL

PHP is an open source, server-side, HTML embedded scripting language used to create dynamic Web pages. PHP can perform any task that any CGI program can do, but its strength lies in its compatibility with many types of databases.

MySQL is most commonly used for Web applications and has become a popular alternative to proprietary database systems because of its speed and reliability. MySQL can run on UNIX, Windows and Mac OS.

cPanel Hosting / PHP and MySQL / phpMyAdmin

How to Duplicate a cPanel MySQL Database

 Do you want to duplicate or copy a cPanel MySQL database? This can be done using phpMyAdmin by following the steps below: Note: It’s important that you BACKUP your database first before performing the steps below. Login to your cPanel Account Create a new Database with the cPanel MySql Wizard Select the “phpMyAdmin” icon Select […]

Read More
MySQL-Logo

phpMyAdmin

Copy a database table with phpMyAdmin

This tutorial will show you how to copy a database table with phpMyAdmin 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 […]

Read More
phpMyAdmin-Logo

phpMyAdmin

Delete fields from a database using phpMyAdmin

This tutorial will show you how to delete fields from a database using phpMyAdmin Select the details table here Let’s delete the city field Click the Delete (or Drop) icon Click Yes to confirm That’s it! We’ve successfully deleted the city field from our database table This is the end of the tutorial. You now […]

Read More
phpMyAdmin-Logo

phpMyAdmin

Inserting fields into database tables using phpMyAdmin

This tutorial will show you the steps for inserting fields into database tables using phpMyAdmin Now let’s learn how to insert fields into database tables Select the details table here In this case, let’s choose to add an address field AFTER the name field Next, select the drop-down menu item: Click Save when finished That’s […]

Read More

phpMyAdmin

Importing databases and tables in phpMyAdmin

This tutorial will show you the steps for importing databases and tables in phpMyAdmin Click the database you wish to import here Let’s assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data. Therefore, let’s first delete the existing details table from our database […]

Read More

phpMyAdmin

Becoming familiar with databases and phpMyAdmin

This tutorial will show you how to become familiar with databases and phpMyAdmin Now let’s familiarize ourselves with databases and phpmyadmin From this phpMyAdmin screen, we have access directly to the database demo1234_members, listed here. A database consists of one or more tables, and it is in the tables that database information is recorded. This […]

Read More

phpMyAdmin

Export databases and tables using phpMyAdmin

This tutorial will show you how to export databases and tables using phpMyAdmin Now let’s learn how to export a database Click the database you wish to export here Then click the Export button In this case, we want to export the entire database in SQL format, so we can easily import it later. This […]

Read More

phpMyAdmin

Modify fields in database tables using phpMyAdmin

This tutorial will show you how to modify fields in database tables using phpMyAdmin Now let’s learn how to modify fields in database tables Select the details table here Let’s modify the address field Click the Change icon Make the changes you want, then click Save That’s it! We’ve successfully changed the name of the […]

Read More

phpMyAdmin

SQL queries on a database with phpMyAdmin

This tutorial will show you how to run SQL queries on a database with 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 As demonstrated in another tutorial, you can delete (or drop) a field from a table by selecting […]

Read More

phpMyAdmin

Rename database tables with phpMyAdmin

This tutorial will show you how to rename database tables with phpMyAdmin Click the database table you wish to rename Then click the Operations button Enter a new name for the table here Then click Go That’s it! The information table has been renamed infotable, and is listed here This is the end of the […]

Read More
Hosting Partners