[Opensim-users] Question on migrating database from Linux to Windows and vice versa

[Chris Kennedy]

I do make seperate OAR and IAR backups along side my SQL dumps =)

I was just wondering if there would be any definite data loss when 
saving and restoring these SQL dumps across multiple platforms... or if 
data loss would be a "freak" kind of thing (i.e. a bug in the My SQL 
server or MySQL Admin when it comes to Linux or Windows, or 
configuration differences between the default setup of the MySQL server 
on Linux vs. Windows, etc).

Would it be a noticeable thing if data loss did occur such as missing 
inventory, or something more subtle that would take a bit of digging to 
find; such as missing textures or even "blank" data (i.e. open a texture 
and all you see is a white box where the texture should have been. Or 
try to play an animation / sound from your inventory and it won't play)?

Thank you very much for the suggestions! =)

On 7/11/2010 7:25 PM, Karen Palen wrote:
> I don't have a lot of experience with porting MySql between different 
> OSes, but general "belt and suspenders" considerations says that a 
> second and independent path would be a very good "safety net".
>
> I would definitely suggest making an IAR backup of every user 
> inventory and an OAR backup of every region! In that way you have a 
> totally separate way to transfer the data and at least the opportunity 
> to recover anything which is corrupted or lost in the transfer!
>
> I believe there are tutorials on how to automate these backups 
> although I have not personally tried them. If you have more that 2 or 
> 3 users and/or 2 or 3 regions then this will significantly reduce the 
> workload.
>
> It pays to be VER conservative (careful) in making backups since if 
> information is LOST it can be extremely hard to re-create, finding 
> something in multiple backups is trivial compared to re-creating content!
>
> remember: Jesus saves - EARLY AND OFTEN!
>
> Karen
>
> On Sun, Jul 11, 2010 at 4:22 PM, Chris Kennedy <mewtwo0641 at cox.net 
> <mailto:mewtwo0641 at cox.net>> wrote:
>
>     Hi, I want to migrate my OpenSim MySQL database from Linux to
>     Windows and vice versa (for traveling reasons) using the MySQL
>     Admin's SQL dump ( MySQL Admin Backup) feature.
>
>     Is there anything special that I need to know or to look out for
>     when doing this (besides making sure Max Packet Size is set to 16
>     MB on the target system)?
>
>     The way I normally do my database backup in the Linux environment
>     is to shut down the OpenSim server, go to the backup tool in MySQL
>     Admin, create a backup project (if it doesn't already exist) for
>     my OpenSim schema making sure all the tables are selected for
>     backup. Then I go into advanced options and click on Normal
>     Backup, and check Complete Backup and run the backup to save my
>     database to a .sql file. This method has worked perfectly fine for
>     me under Linux with no data loss after a restore from backup that
>     I can tell. I have even restored my database to a Windows
>     environment from a Linux created MySQL dump file with no problems
>     that I can see.
>
>     My concern is creating a database backup in a Windows environment
>     and then restoring it to Linux (or even another Windows
>     environment). Would this, under normal circumstances, cause data loss?
>
>     The reason I ask is: I have successfully been able to restore my
>     Windows created SQL dump file to Linux and other Windows systems
>     running XP... But the moment I try to restore my database to a
>     Windows 7 system I get an error that says "Object Type not
>     recognized" (or it might have said Object Type not Found, I don't
>     remember off the top of my head) and the restore fails.
>
>     In a nutshell, is it safe to port my backups between different
>     operating systems like this? Or am I better off creating OARs of
>     my regions and IAR of my inventory(s)? I always make both OAR/IAR
>     and SQL dump backups just to be safe, but I would like to know.
>
>     Any suggestions and/or tips would be much appreciated! =)
>     _______________________________________________
>     Opensim-users mailing list
>     Opensim-users at lists.berlios.de <mailto:Opensim-users at lists.berlios.de>
>     https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>    

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20100711/7444cada/attachment.html>