Knowledgebase

Text Version

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

Begin by clicking the phpMyAdmin button.

Select the database you want to work with.

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.

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.

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 can select which tables you want to backup by selecting them from the list.

Click Select All to backup all of your tables.

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.

You can name your file here.

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

Confirm that you want to save the file.

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.

Click on the With selected: drop down

And select Drop to delete the 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.