[Opensim-dev] MySQL Gurus???

[Mic Bowman]

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
>
>