<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;}
body{}
--></style>
</head><BODY ><div><SPAN style="font-size:10pt;">I am still trying to restore bq and bx servers to a new bx build. </SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">when Importing the sites I get these errors:</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">ERROR Could not find file:</SPAN></div>
<div><SPAN style="font-size:10pt;">ERROR Could not find file:</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">and these:</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">ERROR Cannot set ownership for file: </SPAN></div>
<div><SPAN style="font-size:10pt;">ERROR Cannot set ownership for file: </SPAN></div>
<div><SPAN style="font-size:10pt;">ERROR Cannot set ownership for file: <br /><br /></span></div>
<div> </div>
<div><SPAN style="font-size:10pt;">of course it lists the files it errors on. </SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">I have done restores in the past without these errors. I am using these commands:</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">tar zxvf hostname.of.source.cmu-sml-files.tar.gz</SPAN></div>
<div><SPAN style="font-size:10pt;">then cp files to home/restore</SPAN></div>
<div><SPAN style="font-size:10pt;">then:</SPAN></div>
<div><SPAN style="font-size:10pt;">/usr/sbin/cmuImport -d /home/restore</SPAN></div>
<div> </div>
<div> </div>
<div><SPAN style="font-size:10pt;">something is wrong, probably me??</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">any help is greatly appreciated!</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">tony</SPAN></div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><SPAN style="font-size:10pt;color:navy;">> so, to respond to my own question.l I have been trying to edit the</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> mysqldump.sql files, and trying to use Navicat to backup and</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> restore the files.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Seems that moving 2 or 3 servers to one is not very common. So</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> far, the best method I have is to do each database on its own? not</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> very good with several hundred sql users per server.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Still working on a way to do this.</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;">>> How can I restore mysql users from 3 servers?</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> I have to bq servers and one bx server. I have exported all of</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> the sites on all servers and want to put them onto one new bx</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> server. Last time the raqbackup.sh wrote over the exisiting</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> mysql users. Is there a way to avoid this?</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> tony</SPAN></div>
</body></html>