I dont't think --opt is necessary, since it's on by default.

-- 
Med Hilsen/Best regards
Geir Voll Nielsen


Paul J Stevens wrote:
> What's wrong with a simple
> 
> mysqldump -h $host -u $user -p$pass --single-transaction --opt $db
> 
> 
> Sunny Koh wrote:
>> Paul,
>>
>> What I meant was the mysqldump options as well. Currently I have
>> mysqldump -u $MyUSER -h $MyHOST -p$MyPASS $db --opt      --hex-blob  
>> --max_all
>> owed_packet=16M  --quote-names
>>
>> But Is this the correct way?
>>
>> Paul J Stevens wrote:
>>> Load the 2.0.11 database
>>> Run the migrate_from_2.0_to_2.2.mysql
>>> run dbmail-util -by
>>>
>>>
>>> Sunny Koh wrote:
>>>  
>>>> Hello All,
>>>>
>>>> I have just manage to certify the platform to run DBMail on a fresh OS
>>>> Image (Gentoo 2006.1 Stage 2 with full rebuild) and would like to know
>>>> what is the best options to copy the database from the old harddisk
>>>> image to the new one and which script I use to upgrade from 2.0.11 to
>>>> 2.2.4. I know I should be using the mysqldump command but with what
>>>> parameters. Any suggestions from the community?
>>>>
>>>>     
>>>
>>>   
>>
> 

_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to