View | Details | Raw Unified
Collapse All | Expand All

(-) mysql-upgrading.xml (-3 / +10 lines)
 Lines 22-29    Link Here  
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<!-- See http://creativecommons.org/licenses/by-sa/2.5 -->
<license/>
<license/>

            

              
<version>1.12</version>

              
<version>1.13</version>

            

            

              
<date>2006-09-10</date>

              
<date>2006-10-28</date>

            

        

        
<chapter>
<chapter>

        
<title>Straight upgrade, suggested for 4.1 =&gt; 5.0 migration</title>
<title>Straight upgrade, suggested for 4.1 =&gt; 5.0 migration</title>

  

    

    

       Lines 43-49
       
    
  Link Here 
    

  

        
     <i>| sed -e 's|datadir[ \t]||')</i>
     <i>| sed -e 's|datadir[ \t]||')</i>

        
# <i>MYSQL --execute="FLUSH TABLES WITH READ LOCK;"</i>
# <i>MYSQL --execute="FLUSH TABLES WITH READ LOCK;"</i>

        
# <i>tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \</i>
# <i>tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \</i>

            

              
     <i>/etc/mysql/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}"</i>

              
     <i>/etc/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}"</i>

            

        
# <i>MYSQL --execute="UNLOCK TABLES;"</i>
# <i>MYSQL --execute="UNLOCK TABLES;"</i>

        
# <i>tar -tjvf ~/mysql.*.tar.bz2</i>
# <i>tar -tjvf ~/mysql.*.tar.bz2</i>

        
# <i>emerge -av "&gt;mysql-5.0"</i>
# <i>emerge -av "&gt;mysql-5.0"</i>

  

    

    

       Lines 85-90
       
    
  Link Here 
    

  

        
<section>
<section>

        
<body>
<body>

        

            

              
              
<impo>

            

            

              
              
Values inside primary keys are handled differently in the various MySQL

            

            

              
              
versions, see <uri>link="https://bugs.gentoo.org/108502">bug #108502</uri>

            

            

              
              
for some implications, it's higly recommended to scan your tables for values

            

            

              
              
of "0" (zero) or less and move them to a value greater or equal than "1".

            

            

              
              
</impo>

            

            

              
              

            

        
<p>
<p>

        
One of the most important tasks that every database administrator has to
One of the most important tasks that every database administrator has to

        
perform is backing up data. Here we go:
perform is backing up data. Here we go: