<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=DE link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Chuck,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>the problem is a bit
different. When you use the GUI to manage your sites you will see that two
sites will have the same DB. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>For example: Old site3
has site3_db and newly imported site3 from the other server, now site17 on the
new server also has site3_db.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>When you disable Mysql
for new site17, site3_db of site3 will be destroyed.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>You donīt have a chance
to change the db_name within the GUI.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Even if you give site17 a
new database like site17_db, anyone else who may manage the server would
destroy site3_db by mistake when disabling mysql for site17.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Uwe<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>Von:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
blueonyx-bounces@mail.blueonyx.it [mailto:blueonyx-bounces@mail.blueonyx.it] <b><span
style='font-weight:bold'>Im Auftrag von </span></b>Chuck Tetlow<br>
<b><span style='font-weight:bold'>Gesendet:</span></b> Freitag, 12. August 2011
17:24<br>
<b><span style='font-weight:bold'>An:</span></b> BlueOnyx General Mailing List<br>
<b><span style='font-weight:bold'>Betreff:</span></b> [BlueOnyx:08089] Re: CMU</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>>From my experience using cmuExport/cmuImport - it doesn't do a
thing for the MySQL databases. I've always had to backup/restore those
manually, outside the CMU process. Admittedly, I haven't had to use CMU
in the last 12 months or so. But before that - I got a LOT of experience
with CMU. <br>
<br>
So simply restore the database dump to a different database name on the new
server. Dump the database on the old server to a file like
"site3_db.dump". Copy that to the new server and use something
like "cat site3_db.dump | mysql -u root -p <i><span style='font-style:
italic'>newdatabasename</span></i>". Provide the root MySQL password
and a name for that moved site's database - and you're all set. No damage
to the current site3's database. <br>
<br>
<br>
Chuck <br>
<br>
<br>
P.S. - You might have to create that new database before restoring the dump to
it. I don't remember. But that's easily done. Just create the
empty database first - either at the command line or in phpMyAdmin. <br>
<br>
<br>
<br>
</span></font><b><font size=2><span style='font-size:10.0pt;font-weight:bold'>----------
Original Message -----------</span></font></b><font size=2><span
style='font-size:10.0pt'> <br>
From: "Uwe Spreckelmeyer" <us@itss24.com> <br>
To: "'BlueOnyx General Mailing List'" <blueonyx@blueonyx.it> <br>
Sent: Fri, 12 Aug 2011 10:58:30 +0200 <br>
Subject: [BlueOnyx:08086] CMU <br>
<br>
> When you cmu-export a site -i.e. site3 - and cmu - import it to another <br>
> Server it will become i.e. site17. The sites database name is still
site3_db <br>
> on the new server even though this db is already in use by site3 of this <br>
> server. <br>
> <br>
> What can be done to prevent destruction of site3_db on the new server
using <br>
> the GUI (Websettings of site, MySQL user and database, enable/disable).
<br>
> Is it possible to disable Mysql for a site without destroying the db by
the <br>
> GUI? <br>
> <br>
> Any hint? <br>
> <br>
> Uwe Spreckelmeyer <br>
> <br>
> _______________________________________________ <br>
> Blueonyx mailing list <br>
> Blueonyx@mail.blueonyx.it <br>
> <a href="http://mail.blueonyx.it/mailman/listinfo/blueonyx" target="_blank">http://mail.blueonyx.it/mailman/listinfo/blueonyx</a>
<br>
<b><span style='font-weight:bold'>------- End of Original Message -------</span></b>
</span></font><o:p></o:p></p>
</div>
</body>
</html>