<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
There is a table called 'mysql' that contains the users.<br>
<br>
At a minimum you will need to investigate that section of the .sql
files.<br>
<br>
Tony C. Loosle wrote:
<blockquote cite="mid:200952713336.010406@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;">I was merging two old BQ servers
to a new BX server. Pretty sure the mysql users and database names
where different, so if it did drop a table it would not exist and be no
problem. </span></div>
<div> </div>
<div><span style="font-size: 10pt;">What seemed to happen was that it
dropped users on the current server, but did not drop any tables or
databases.</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 is fine
for a migration.</span></div>
<div><span style="font-size: 10pt; color: navy;">></span></div>
<div><span style="font-size: 10pt; color: navy;">> What you want
is more of a 'merge' it sounds like.</span></div>
<div><span style="font-size: 10pt; color: navy;">></span></div>
<div><span style="font-size: 10pt; color: navy;">> If you look at
the mysqldump.sql file, it is going to contain</span></div>
<div><span style="font-size: 10pt; color: navy;">> strings like
'if table exists, drop table'.</span></div>
<div><span style="font-size: 10pt; color: navy;">></span></div>
<div><span style="font-size: 10pt; color: navy;">> The idea is
that it is going to replace whatever is on the dst</span></div>
<div><span style="font-size: 10pt; color: navy;">> server with
what was on the src.</span></div>
<div><span style="font-size: 10pt; color: navy;">></span></div>
<div><span style="font-size: 10pt; color: navy;">> To do what you
are trying to do, it's going to take a little manual</span></div>
<div><span style="font-size: 10pt; color: navy;">> work.</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;">>> I
followed Nuonce's backup</span></div>
<div><span style="font-size: 10pt; color: maroon;">>>
instructions:</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: navy;">> mysql -uroot
-ppassword <</span></div>
<div><span style="font-size: 10pt; color: maroon;">>>
hostname.of.source.mysqldump.sql</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></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;">>> Tony C.
Loosle</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> wrote:</span></div>
<div><span style="font-size: 10pt; color: purple;">>>> I
tried</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> to move
several sites from a bq server to a bx server.</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: purple;">>>> the
sites</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> went ok,
but the sql is very messed up.</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: purple;">>>> the</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> import
deleted all the users that were there before.</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: purple;">>>> Is
there</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> a
different way to import the mysql and not delete the</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: purple;">>>>
existing</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> users?</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;">>> Hmmmm....
how</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> did you
import it? It's possible to run a mysql import and</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> overwrite
everything, or just add to the existing.</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: maroon;">>> More</span></div>
<div><span style="font-size: 10pt; color: maroon;">>>
information is needed for us to help.</span></div>
<div><span style="font-size: 10pt; color: maroon;">>></span></div>
<div><span style="font-size: 10pt; color: maroon;">>>
_______________________________________________ Blueonyx mailing</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> list
<a class="moz-txt-link-abbreviated" href="mailto:Blueonyx@blueonyx.it">Blueonyx@blueonyx.it</a></span></div>
<div><span style="font-size: 10pt; color: maroon;">>> <a
moz-do-not-send="true"
href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a></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>