<html><head><meta name="Generator" content="PSI HTML/CSS Generator"/>
<style type="text/css"><!--
body{font-family:'Arial';font-size:10pt;font-color:'#000000';}
LI{display:list-item;margin:0.00in;}
p{display:block;margin:0.00in;}
--></style>
</head><BODY ><div><SPAN style="font-size:10pt;">Here is what I had or did:</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">I setup a BX server, had a few users, sites and sql database's on it.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Then I imported a BQ server, all seemed ok, then the 2nd BQ and it lost the original users on the BX.</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">So, Michael, I need to edit the mysqldump before importing it? Removing the "drop" command and check for duplicate users?</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">thanks</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">t</SPAN></div>
<div><SPAN style="font-size:10pt;"><br /><br /></span></div>
<div><SPAN style="font-size:10pt;color:navy;">> Hi Darrell,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Could this be a result of BX's name schema for new MySQL</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> databases, something that didn't exist under BQ?</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> No, he tried to merge MySQL data from two different BQ servers into</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> one BX box. For Databases that's fine, but the 2nd MySQL-Import</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> (done from the command line) dropped the MySQL usertable from the</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> first MySQL import.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Merging MySQL user databases is tricky regardless of platform. If</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> you really want to do that, then the standard NuOnce reciepe for</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> migrations won't do. For the 2nd MySQL import you need to have a</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> dump of the "mysql" table without the "drop" command in it *and*</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> you need to manualy edit out all user names that are already</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> present.</SPAN></div>
</body></html>