How do I use phpMyAdmin?




Buyhttp offer Unlimited Admin time for Dedicated server

Text Version

In this tutorial we will be use phpMyAdmin to manage a database.

In this tutorial we will be use phpMyAdmin to manage a database.

Begin by clicking the phpMyAdmin button.

Begin by clicking the phpMyAdmin button.

Select the database you want to work with.

Select the database you want to work with.

The first thing we will do is import a .sql script. Click on the SQL tab.

The first thing we will do is import a .sql script. Click on the SQL tab.

If you have a script you can copy/paste the contents into this text box to run the script.

If you have a script you can copy/paste the contents into this text box to run the script.

Alternately you can click on the Browse button to locate a file on your computer to run.

Alternately you can click on the Browse button to locate a file on your computer to run.

Double click on the name of the file you want to open.

Double click on the name of the file you want to open.

Scroll to the right and click on the Go button.

Scroll to the right and click on the Go button.

You will see that your script has been successfully run.
Next we will create a backup of your database. Click on the Export tab.

You will see that your script has been successfully run.
Next we will create a backup of your database. Click on the Export tab.

You can select which tables you want to backup by selecting them from the list.

You can select which tables you want to backup by selecting them from the list.

Click Select All to backup all of your tables.

Click Select All to backup all of your tables.

You can change your settings for what to export with the checkboxes here.

You can change your settings for what to export with the checkboxes here.

If you want to save the file click the Save as File checkbox.

If you want to save the file click the Save as File checkbox.

You can name your file here.

You can name your file here.

Once you have all of your settings the way you want them, click Go

Once you have all of your settings the way you want them, click Go

Confirm that you want to save the file.

Confirm that you want to save the file.

Now let's edit the database a little. Click the Structure tab.

Now let's edit the database a little. Click the Structure tab.

Let's delete a few of the tables. Click the checkbox next to the tables you want to delete.

Let's delete a few of the tables. Click the checkbox next to the tables you want to delete.

Click on the With selected: drop down

Click on the With selected: drop down

And select Drop to delete the tables.

And select Drop to delete the tables.

Confirm that you want to delete those tables

Confirm that you want to delete those tables

phpMyAdmin will verify the tables were deleted. You can use this same method for changing many thing with the tables.

phpMyAdmin will verify the tables were deleted. You can use this same method for changing many thing with the tables.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

What is my email login information?

You can access your email using IMAP or POP3 protocols. Your login is: username@domain.com...

How do I change my BuyHTTP account email address?

Your email address is very important in our systems. It is the piece of information that we use...

How do i configure Outlook?

Buyhttp offer professional service for Joomla and  wordpress site

How do I change my email password in cPanel?

To change the password associated with individual email accounts, login to your cPanel and enter...