Difference between revisions of "How to drop all the database tables"

From Imaginet FAQ
Jump to navigation Jump to search
Line 2: Line 2:
  
 
* Step 1
 
* Step 1
Select the database
+
  Login to http://phpmyadmin.yourdomain.co.za and Select the database
 
[[File:databasedrop_img1.PNG|600px|thumb|center]]
 
[[File:databasedrop_img1.PNG|600px|thumb|center]]
  

Revision as of 12:23, 6 November 2012

If you would like to remove all the existing database tables, you need to use the MySQL drop tables function.

  • Step 1
 Login to http://phpmyadmin.yourdomain.co.za and Select the database
Databasedrop img1.PNG
  • Step 2
You then need to select all the database tables by selecting "Check All" and then select "Drop Tables" from the drop down option.
Databasedrop img2.PNG
  • Step 3
You will then be asked if you want to drop the select tables, select "Yes".
Databasedrop img3.PNG
  • Step 4
Once all the tables have been removed, you should see the following and notice that there will now be a (0) next to the database.
Databasedrop img4.PNG