[BlueOnyx:03391] Re: Shared MySQL - Vsite Deleted

[Dr. Blunt]

Michael --

Thanks for the clarification (but) I create all the MySQLs at the
command line [$mysql], then go to the GUI to finish giving the (or a )
user from a site access to the Db (if needed). Perhaps somewhere in the process
I am cross linking the purpose of the GUI and vsite however, with all due
respect my heart felt frustration was site [A] thinking it can just delete the
database everyone from other sites is sharing. However, a STOP do not
pass GO would be helpful when it comes to the SQL. IF the Q is "when
does it end" I am not well qualified to address that as I am more of
a listener on this forum as Gerald knows so I may be mis-stating
may steps. Nonetheless the thought of losing 3 million records
was a wake-up call even though the backups were in place as I lost
one days worth of transactions.

David


At 09:56 AM 1/21/2010, you wrote:
>Hi Dr. Blunt,
>
> > ..I build the MySQL database for the WordPress (WP) installs at the
> > $ mysql -u root... then I go to the GUI > security > phpMyAdmin >
> > [database] > Privileges > and make sure I have the correct settings
> > (e.g., GRANT) as I am a complete novice from the COMMAND line.
> > Perhaps I am forgetting a step somewhere but I give several sites
> > on the same BO access to the same database which in this case had
> > 168 tables and 3 million + records.
>
>Sorry, but that cannot be.
>
>If you use the BlueOnyx GUI to create a MySQL database and user for a site,
>then - and only THEN - is that MySQL database (and its user) under "GUI
>control". And only in that case the GUI will delete this MySQL user and
>database if that site is deleted.
>
>It doesn't matter if PHP scripts from other sites are using that same 
>database
>or not.
>
>Databases that are created manually (command line or phpMyAdmin) will not get
>under "GUI management" all by themselves and therefore are not subjected to
>deletion when a site is removed.
>
>--
>With best regards
>
>Michael Stauber
>
>_______________________________________________
>Blueonyx mailing list
>Blueonyx at blueonyx.it
>http://www.blueonyx.it/mailman/listinfo/blueonyx

.....