<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;">thanks!</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">I will give it a try</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;">> That'd do it.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Tony C. Loosle wrote:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Here is what I had or did:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> I setup a BX server, had a few</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> users, sites and sql database's on it.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Then I imported a BQ server, all</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> seemed ok, then the 2nd BQ and it lost the original users on the</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> BX.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> So, Michael, I need to edit the</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> mysqldump before importing it? Removing the "drop" command and</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> check for duplicate users?</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;">> thanks</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> t</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hi Darrell,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Could</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> this be a result of BX's name schema for new MySQL</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></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:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> No, he tried to</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> merge MySQL data from two different BQ servers into one BX box.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> For Databases that's fine, but the 2nd MySQL-Import (done from the</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> command line) dropped the MySQL usertable from the first MySQL</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> import.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Merging MySQL</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> user databases is tricky regardless of platform. If you really</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> want to do that, then the standard NuOnce reciepe for migrations</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> won't do. For the 2nd MySQL import you need to have a dump of the</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> "mysql" table without the "drop" command in it *and* you need to</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> manualy edit out all user names that are already present.</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:maroon;">>> _______________________________________________</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Blueonyx mailing list</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Blueonyx@blueonyx.it</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> <a href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a></SPAN></div>
</body></html>