Re: [webmin-l] How to empty databases? What SQL command to use?

[Kris D. <kd...@vi...>]

pr...@pr... wrote:
> I would like to empty the databases on one of my sites.
> 
> Could someone please tell me how to format the SQL command?

That depends on what you mean by "empty the databases".

Do you mean "clear out all data from all tables in this database"?

Do you mean "delete all tables from this database"?

Do you mean "delete this database entirely"?

> In the text area under "Enter an SQL command to execute on database
> [nameofdatabase]"
> I enter a command or querie for each "table". Correct?
> 
> But what is the format of each of the commands, please?
> 
> I've searched the webmin site and Google but haven't been
> able to find the answer. Maybe I'm using the wrong terminology.

Try searching for "SQL tutorial".  Adding "MySQL" as a search term as 
well may produce some results that are more specific to MySQL;  there 
*are* differences in how some tasks like this can be accomplished in 
different database systems.

Also, IIRC Webmin has a fairly good interface to deal with MySQL (and 
several other DBMS's);  you should be able to delete data, tables, or 
whole databases without writing any SQL.  I think you'd look for this 
functionality under the Servers->MySQL section.

-kgd