<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;">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 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>