4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Clearing a database in phpMyAdmin
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
billdavies
Senior WebHelper
Senior WebHelper


Joined: 22 Jan 2002
Posts: 107
Location: UK

PostPosted: Sun Mar 31, 2002 8:22 pm (15 years, 7 months ago) Reply with QuoteBack to Top

Hey

How do I clear my database in phpMyAdmin? I dont know how to do anything in it!

Bill
OfflineView User's ProfileFind all posts by billdaviesSend Personal MessageVisit Poster's WebsiteMSN Messenger
Justin
4WebHelp Addict
4WebHelp Addict


Joined: 07 Jan 2002
Posts: 1060

PostPosted: Sun Mar 31, 2002 9:10 pm (15 years, 7 months ago) Reply with QuoteBack to Top

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.
OfflineView User's ProfileFind all posts by JustinSend Personal MessageSend email
Gemmy
Junior WebHelper
Junior WebHelper


Joined: 13 Mar 2004
Posts: 1

PostPosted: Sat Mar 13, 2004 1:55 am (13 years, 7 months ago) Reply with QuoteBack to Top

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?
OfflineView User's ProfileFind all posts by GemmySend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Sat Mar 13, 2004 8:11 am (13 years, 7 months ago) Reply with QuoteBack to Top

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.

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




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.04653 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme