[Opensim-users] MYSQL upgrade

[M.E. Verhagen]

Indeed it looks like mysql updated to 5.5, it apparently updated on my
fedora box.

I did thought the phpmyadmin look a bit different.

There appear to be no issues though, i did not notice any probs.

It is a good practice to backup your data once in a while, my opensim
box makes oar backups automatic everytime my opensim shutdown.
Use save iar to backup your inventory.

2011/6/24, Chris <mewtwo0641 at cox.net>:
> On 6/23/2011 8:14 PM, InuYasha Meiji wrote:
>> I am currently using MYSQL 5.1.41 community edition, and I make
>> opensim.sql backup every other night.  Would it be possible for me to
>> upgrade to version 5.5.13 community and restore my opensim.sql to it,
>> and have opensim 0.7.1.1 run fine with it.  Or is there some
>> incompatibility with opensim now and version 5.5.13 of MYSQL.
>>
>> I don't want to run into some kind of horrible problem because I
>> upgraded.  All has been running fine so far.  I was looking for a
>> database speed boost, but don't want to mess things up in the
>> meantime.  I have a 2000 item inventory so far, and don't want to
>> loose it all.
>>
>> Thanks in advance,
>> InuYasha Meiji
>
> Aside from figuring out how to use the weird new GUI tools suite (MySQL
> Admin's replacement) which seems to be about as intuitive (yeah
> right...) as Windows Vista; I did not have any problems upgrading to
> MySQL 5.5.x from 5.1.x and restoring a SQL dump to it. But as always I'd
> recommend saving OARs of your regions and IARs of your inventories
> before attempting.
>
> If there are any incompatibilities or other nuances with restoring a
> 5.1.x SQL dump to 5.5.x I would definitely be interested to know as well.
>