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

[Khan, M. [SMO] <MK...@fr...>]

What I need is all my users should login to one usermin and they should be =
able to access multiple hosts from there.

-----Original Message-----
From: web...@li...
[mailto:web...@li...]On Behalf Of Jamie
Cameron
Sent: Friday, February 24, 2006 1:53 AM
To: web...@li...
Subject: RE: [webmin-l] How to empty databases? What SQL command to use?


I am not sure what you mean exactly ... do you mean sharing Usermin setting=
s 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 s=
ite 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 th=
e list of tables in a DB, click the Select All link, then hit the Drop Sele=
cted 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 ---




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=3Dk&kid=110944&bid$1720&dat=121642
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list
Notice:  All email and instant messages (including attachments) sent to
or from Franklin Templeton Investments (FTI) personnel may be retained,
monitored and/or reviewed by FTI and its agents, or authorized
law enforcement personnel, without further notice or consent.