<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
That'd do it.<br>
<br>
Tony C. Loosle wrote:
<blockquote cite="mid:200952894141.984446@Tback" type="cite">
<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>
<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>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Blueonyx mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Blueonyx@blueonyx.it">Blueonyx@blueonyx.it</a>
<a class="moz-txt-link-freetext" href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a>
</pre>
</blockquote>
</body>
</html>