<!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">
That is fine for a migration.<br>
<br>
What you want is more of a 'merge' it sounds like.<br>
<br>
If you look at the mysqldump.sql file, it is going to contain strings
like 'if table exists, drop table'.<br>
<br>
The idea is that it is going to replace whatever is on the dst server
with what was on the src.<br>
<br>
To do what you are trying to do, it's going to take a little manual
work.<br>
<br>
Tony C. Loosle wrote:
<blockquote cite="mid:200952793851.099903@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 followed Nuonce's backup
instructions:</span></div>
<div> </div>
<div><span style="font-size: 10pt;">mysql -uroot -ppassword <
hostname.of.source.mysqldump.sql</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;">> Tony C. Loosle
wrote:</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> I tried
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: maroon;">>> the sites
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: maroon;">>> the
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: maroon;">>> Is there
a different way to import the mysql and not delete the</span></div>
<div><span style="font-size: 10pt; color: maroon;">>> existing
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;">> Hmmmm.... how
did you import it? It's possible to run a mysql</span></div>
<div><span style="font-size: 10pt; color: navy;">> import and
overwrite everything, or just add to the existing.</span></div>
<div><span style="font-size: 10pt; color: navy;">></span></div>
<div><span style="font-size: 10pt; color: navy;">> More
information is needed for us to help.</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>