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

How do I configure Thunderbird?

Start your own  hosting business with Buyhttp reseller package

Why am I getting an unrouteable mail domain error?

The most likely cause for unrouteable email domain error is exceeding the hourly email sending...

How do I configure Incredimail?

Customized hosting plan for Advanced Guestbook Hosting

How do I enable SMTP Authentication in MS Outlook Client?

Open Outlook. From the Tools menu, select Email Accounts.The Email Accounts box appears. Verify...

How do I configure Opera?

Buyhttp offer wide-ranging SSL certificate