|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
February 19th, 2002, 09:39 AM
|
|||
|
|||
|
deleting ALL database contents
I'm a beginner!
I'm ok if I just have to follow reasonable instructions. However, I've crammed my mysql database with corrupted stuff and I need to get rid of the WHOLE lot. What is the line I type in to do this and do I type this in at the mysql prompt on telnet or after I have changed to "use" my particular database? I've searched all afternoon to find this answer. Cheers, Nigel
|
|
#2
February 19th, 2002, 09:43 AM
|
||||
|
||||
|
Well you can either just drop the database:
http://www.mysql.com/doc/D/R/DROP_DATABASE.html and put it all back again, or delete the contents of each table in turn: http://www.mysql.com/doc/D/E/DELETE.html
|
|
| Viewing: Dev Shed Forums > Other > Beginner Programming > deleting ALL database contents |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
