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

[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.

Just seems that the BO admin should be asked "Hey, do you want
to delete the SQL db as well because I am not sure anyone else is
using it" or something... as you can imagine my heart
hit the deck when I went into the system and nothing was there.

I am chasing down how to update the cron job for the raqbackup.sh
so it will run every 4 hours. Once a day now worries me should I
need to delete a vsite, and this case move one to another BO.

~~David

At 08:17 AM 1/21/2010, you wrote:

>Dr. Blunt wrote:
> > ..well actually I created both the sites in the GUI first, then went to
> > the COMMAND
> > line and created the SQL database, then assigned privileges to both
> > vsites. Thus, it seems
> > a bit over zealous for the GUI to assume it has the authority to delete
> > the SQL files
> > even when others have equal access to it and rights. Perhaps the admin
> > of the BO
> > should have more authority in the GUI when it comes to deleting a vsite.
>
>I've never seen this behavior out of a Sausalito device.  Creating a
>database outside of the GUI, the cce will not "know" about it to delete it.
>
> > It just seems it is an ALL or NOTHING feature and especially when it
> > comes to thinking
> > it has the right to delete files it did not create but has access to. In
> > the end the
> > GUI deleted _3 million_ records of which I am thankful the raqbackup.sh
> > was working.
> > Now I guess I need to adjust the cron to backup more than once a day
> > just in case the
> > GUI wants to do a coup d' etat.
>
>Did you, by chance, create the DB at CLI or phpMyAdmin and then input
>the details for that DB into the site configuration in the GUI?  That's
>the only way I can see what you describe as happening.
>
>--
>Chris Gebhardt
>VIRTBIZ Internet Services
>Access, Web Hosting, Colocation, Dedicated
>www.virtbiz.com | toll-free (866) 4 VIRTBIZ
>_______________________________________________
>Blueonyx mailing list
>Blueonyx at blueonyx.it
>http://www.blueonyx.it/mailman/listinfo/blueonyx

.....