|
Author |
Message |
billdavies
Senior WebHelper
Joined: 22 Jan 2002
Posts: 107
Location: UK
|
Posted:
Sun Mar 31, 2002 8:22 pm (22 years, 9 months ago) |
|
Hey
How do I clear my database in phpMyAdmin? I dont know how to do anything in it!
Bill |
|
|
|
|
Justin
4WebHelp Addict
Joined: 07 Jan 2002
Posts: 1060
|
Posted:
Sun Mar 31, 2002 9:10 pm (22 years, 9 months ago) |
|
Click on your database name on the left hand side
Just make sure all the tables checkboxes are ticked, and then click drop on the menu below. |
|
|
|
|
Gemmy
Junior WebHelper
Joined: 13 Mar 2004
Posts: 1
|
Posted:
Sat Mar 13, 2004 1:55 am (20 years, 9 months ago) |
|
Justin wrote: | Click on your database name on the left hand side
Just make sure all the tables checkboxes are ticked, and then click drop on the menu below. |
This was a huge help to me...thank you so much!
However, my question is this -- what if someone doesn't have phpmyadmin on their server? Is there a way to clear the tables? |
|
|
|
|
Daniel
Team Member
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Sat Mar 13, 2004 8:11 am (20 years, 9 months ago) |
|
You can delete tables by running the DROP TABLE command:
http://www.mysql.com/doc/en/DROP_TABLE.html
You can do this through a PHP (or Perl) script, or via the MySQL command line if you have access to it. |
________________________________
|
|
|
|
|
|
You cannot post new topics in this forum. You cannot reply to topics in this forum. You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot vote in polls in this forum.
|
Page generation time: 0.116571 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |