From: Jamie C. <jca...@we...> - 2006-02-23 22:55:11
|
I am not sure what you mean exactly ... do you mean sharing Usermin setti= ngs between multiple hosts? - Jamie -----Original Message----- From: "Khan, Mohammed [SMO]" <MK...@fr...> Subj: RE: [webmin-l] How to empty databases? What SQL command to use? Date: Fri 24 Feb 2006 8:50 am Size: 2K To: <web...@li...> Hi Jamie, Is there a way to centralize the usermin to user can access one= site but able to login to multiple hosts. -----Original Message----- From: web...@li... [mailto:web...@li...]On Behalf Of jca...@we... Sent: Friday, February 24, 2006 1:09 AM To: web...@li...; web...@li... Subject: RE: [webmin-l] How to empty databases? What SQL command to use? There are actually buttons in Webmin's MySQL module for this. Just go to = the list of tables in a DB, click the Select All link, then hit the Drop = Selected Tables button. - Jamie -----Original Message----- From: "pr...@pr..." <pr...@pr...> Subj: RE: [webmin-l] How to empty databases? What SQL command to use? Date: Fri 24 Feb 2006 7:46 am Size: 1K To: web...@li... From: Prodos To: Kris Deugau=20 Dear Kris, Good morning. Me: > > I would like to empty the databases on one of my sites. > >=20 > > Could someone please tell me how to format the SQL command? >=20 KGD: > That depends on what you mean by "empty the databases". >=20 > Do you mean "clear out all data from all tables in this database"? >=20 > Do you mean "delete all tables from this database"? >=20 > Do you mean "delete this database entirely"? >=20 Sorry for not being clearer. I meant "clear out all data from all tables in this database" Me: > > I've searched the webmin site and Google but haven't been > > able to find the answer. Maybe I'm using the wrong terminology. >=20 KGD: > Try searching for "SQL tutorial". Adding "MySQL" as a search term as=20 > well may produce some results that are more specific to MySQL; there=20 > *are* differences in how some tasks like this can be accomplished in=20 > different database systems. >=20 > Also, IIRC Webmin has a fairly good interface to deal with MySQL (and=20 > several other DBMS's); you should be able to delete data, tables, or=20 > whole databases without writing any SQL. I think you'd look for this=20 > functionality under the Servers->MySQL section. >=20 Thanks for those suggestions! I'll check them out. Best Wishes, PRODOS http://prodos.thinkertothinker.com "Boring updates on exciting projects." --- message truncated --- |