<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
>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 <span style="font-style: italic;">newdatabasename</span>". 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 /><font size="2"><b>---------- Original Message
-----------</b>
<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 target="_blank" href="http://mail.blueonyx.it/mailman/listinfo/blueonyx">http://mail.blueonyx.it/mailman/listinfo/blueonyx</a>
<br /><b>------- End of Original Message
-------</b>
<br />
</font>
</BODY>
</HTML>