[BlueOnyx:04441] Re: Suggestion to Change Location of Domain MySQL Databases

[MuntadaNet Webmaster]

I guess then the other approach to really meet the objective I was 
going for was some method of registering the databases that are being 
used by a site.  I realize now that Blue Onyx has this now for at 
least one database but what if there are several databases for a 
site?  Then at least when a cmuExport is done, a mysqldump call could 
be done against each database registered for the site.  That is 
really want I am going for here.

I guess I am making the suggestion in part as I migrate one BQ box to 
BX, I am realizing there are databases that may no longer be part of 
any site because the site was deleted without recalling due to no 
record keeping of what database was created for what site and for the 
databases that are active, how am I going to go easily migrate the 
databases over with their site.  I am not necessarily migrating all 
databases and all sites at the same time and all to the same server 
which makes the full cmuExport not exactly what I am looking for.

-Rashid

At 10:37 PM 5/10/2010, you wrote:
>Hi Greg,
>
> >   * Database backups with cmuexport will not necessarily be any use to
> > you, unless you shutdown the database. You have to remember that the
> > database has these files open at all times, and is constantly making
> > updates...
> >    * What about innodb files - Not all data is in the www.mydomain.com
> > directory - so a restore will not give you a full working database anyway.
>
>Correct. Those two alone make it a non issue. Additionally: This 
>won't back up
>the privilege tables either, so while you may retain (possibly wrecked!)
>databases during CMU, you still loose the MySQL users and their privilege
>settings.
>
>A bad backup is like having none, because creates a wrong sense of security
>and it'll usually fail you when you need it the most.
>
>Best way to fully backup MySQL is still doing a MySQL-dump.
>
>--
>With best regards
>
>Michael Stauber
>_______________________________________________
>Blueonyx mailing list
>Blueonyx at blueonyx.it
>http://www.blueonyx.it/mailman/listinfo/blueonyx