MySQL Mirgration Scripts

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?

-- 
Regards,

Mr. Sunny Koh

Executive System Administrator
Acorn Edutainment Private Limited
Part of The NurtureCraft Group

#09-05 Parkway Parade Office Tower
80 Marine Parade Road
Singapore 449269

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

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


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

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


-- 
Regards,

Mr. Sunny Koh

Executive System Administrator
Acorn Edutainment Private Limited
Part of The NurtureCraft Group

#09-05 Parkway Parade Office Tower
80 Marine Parade Road
Singapore 449269

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

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


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Thanks Paul, was asking because wondering if I did the
correct thing or 
not or should I omit or add additional parameters.


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


-- 
Regards,

Mr. Sunny Koh

Executive System Administrator
Acorn Edutainment Private Limited
Part of The NurtureCraft Group

#09-05 Parkway Parade Office Tower
80 Marine Parade Road
Singapore 449269

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Sunny Koh wrote:
> Thanks Paul, was asking because wondering if I did the
correct thing 
> or not or should I omit or add additional parameters.
>
>
> 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?
>>>>>
>>>>>             
>>>>         
>>>     
>>
>>
>>   
>
>
does anybody have any concurrency data benchmarks between
mysql and 
postgresql with dbmail???
MIchael
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Newer versions of mysqldump add this to the top of the dump
file:

  SET FOREIGN_KEY_CHECKS = 0;

and then at the end of the file:

  SET FOREIGN_KEY_CHECKS = 1;


On Thu, 2007-03-29 at 10:02 -0500, Curtis Maurand wrote:
> I don't know if anyone else is having this trouble, but
mysqldump for me 
> does not dump the database in the correct order in
order to load the 
> tables back in.  Usually I get failures for dependency
issues (tables 
> depending on other tables that haven't been created,
yet.).  I've found 
> that I've had to dump the tables one at a time and then
restore them the 
> proper order.
> 
> Curtis
> 
> Michael Dean wrote:
> > Sunny Koh wrote:
> >> Thanks Paul, was asking because wondering if I
did the correct thing 
> >> or not or should I omit or add additional
parameters.
> >>
> >>
> >> 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?
> >>>>>>
> >>>>>>             
> >>>>>         
> >>>>     
> >>>
> >>>
> >>>   
> >>
> >>
> > does anybody have any concurrency data benchmarks
between mysql and 
> > postgresql with dbmail???
> > MIchael
> > _______________________________________________
> > DBmail mailing list
> > DBmaildbmail.org
> > htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
> >
> 
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail