[Opensim-dev] MySQL Gurus???

[Fish Kungfu]

In Ubuntu (Gutsy 7.10) I use mysqldump and SOURCE to make and restore backups of my opensim database.  
The steps I use are the following:

FOR CREATING .SQL DUMP FILE
---------------------------
1.  From a bash prompt:   mysqldump -u root -p --opt opensim > /home/opensim/Desktop/opensim.sql
2.  From a bash prompt:   Password: *********

That creates my opensim.sql dump file.


FOR RESTORING THE .SQL DUMP FILE TO A NEW opensim DATABASE
----------------------------------------------------------
For example if your current opensim database is hosed and you just want to restore from a backup.  You can also use this method to migrate your opensim database to another server.

1.  From a mysql prompt:  DROP DATABASE opensim;
2.  From a mysql prompt:  CREATE DATABASE opensim;
3.  From a mysql prompt:  USE opensim;
3.  From a mysql prompt:  SOURCE /home/opensim/Desktop/opensim.sql

You'll see a bunch of lines scroll by as the restore progresses and it should eventually stop.  ;-)

That's it.  I hope this helps some.  
Cheers.....Fish



-----Original Message-----
>From: Mic Bowman <cmickeyb at gmail.com>
>Sent: Jun 10, 2008 12:46 AM
>To: opensim-dev at lists.berlios.de
>Subject: Re: [Opensim-dev] MySQL Gurus???
>
>i have a regularly scheduled backup for my databases. and i've
>restored from there a few times. the dump file that is created is just
>a sql command file to recreate the tables and all the records so you
>can actually edit it with a decent large file editor. there are a
>couple things you need to configure to use the command line mysql
>admin tool.. i can't give you specifics until i get back to work
>tomorrow to check the scripts... but basically, you need to increase
>the maximum packet size or many of the larger asset records will fail
>to load. and i had some trouble with timeouts.
>
>--mic
>
>
>On Mon, Jun 9, 2008 at 9:34 PM, liu xiaolu <lulurun at gmail.com> wrote:
>>>The dump executes fine... when I try to restore I always get errors.
>> I think it will be helpful if you paste your error message.
>>
>> How did you "dump" and "restore" mysql data?
>> I use "mysqldump" and "source" to dump table "prims", "primshapes",
>> "terrain", "assets"
>> for many times, and have not got an error.
>>
>>
>> 2008/6/10 Terry F. <terry at usfastweb.com>:
>>>
>>> Hi all,
>>>
>>> I need some help with a "MySQL" related situation and was wondering who
>>> here is familiar with the MySQL portion of the code?
>>> Specifically, I am having trouble with restoring MySQL "Dumps" of the
>>> assets and inventory tables.
>>> I can't for the life of me seem to be able to get a "GOOD" dump of the
>>> inventory or asset tables.
>>> The dump executes fine... when I try to restore I always get errors.
>>> As my tables continue to grow... I cringe to think of the day when my DB
>>> needs a restore as right now I can't do one!
>>>
>>> Thanks,
>>> -Terry
>>> _______________________________________________
>>> Opensim-dev mailing list
>>> Opensim-dev at lists.berlios.de
>>> https://lists.berlios.de/mailman/listinfo/opensim-dev
>>
>>
>>
>> --
>> Liu Xiaolu
>> _______________________________________________
>> Opensim-dev mailing list
>> Opensim-dev at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-dev
>>
>>
>_______________________________________________
>Opensim-dev mailing list
>Opensim-dev at lists.berlios.de
>https://lists.berlios.de/mailman/listinfo/opensim-dev