<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hello all,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am having some database problems, I have posted the
following on one of the MySQL support forums this morning.........<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>QUOTE<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am using MySQL 5.0.51b community edition on an Windows XP
machine (all the latest updates installed). MySQL was installed using the
default options. I use MySQL to satisfy the database requirements of
Opensimulator (www.opensimulator.org). Currently 25 tables of varying numbers
of columns holding a varity of data types.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Recently I decided to upgrade to a bigger machine running
Vista Business and the latest download of MySQL. I took a backup intending to
copy this over and then restore it on the new machine, almost immediately the
restore failed because of an error in one of the tables called
"assets" only the second of the tables, I tried again ignoring the errors
this time and after over an hour it finished but there were only two tables and
the "assets" table only had 23 entries. I tried several more times
with the same results, I have also tried MySQLDump, this failed the restore and
told me it had a problem with line 24 of "assets". I have now also
tried several of my regular backups and they have all failed to restore.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Using MySQLAdministrator to inspect the database I am told
that "assets" has over 17,000 rows and using the maintenance options
everything checks out as OK. If I look at the "assets" table in
MySqlBrowser a SELECT * takes 30 seconds to display what it claims is
everything and only show just over 8,000 rows. There is a similar inconsistency
in row numbers in other tables as well.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I am a complete novice when it comes to database programs
but have many years experience with PC's and Windows as well as a variety of
other systems.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Can anybody explain why there are inconsistencies in the
line numbers and suggest what might be going wrong, I guess it is the backup
that is failing rather than the restore and that the problem is caused by some
database corruption but I haven't a clue where to look.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Any assistance would be gratefully received, if any more
information is required please let me know and if possible how to obtain it, in
simple language. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>END QUOTE<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I don’t think the problem is opensim related other
than the fact I’m using the database for opensim but if anybody has
experienced anything similar I would be interested to hear, if it helps the row
in the assets table it fails on is the texture “gravel”. I download
the latest opensim version several times a week so am reasonably up to date, I
have no error messages on the servers I am aware of. In fact everything seems
to be working reasonably OK, I can apply the texture and use it normally, but
if I can provide any more information please let me know.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Dave<o:p></o:p></p>
</div>
</body>
</html>