Jump To: Support > KB > NetManager > Update > MySQL

Upgrading MySQL databases

Here is the procedure for reference. The instructions will be somewhat terse. You should watch out for errors at every step and go no further if you see anything untoward

1. Dump SQL:

   backup 1# mkdir /usr/mysqlbackup
   backup 2# mysqladd -o /usr/mysqlbackup
   

2. Stop MySQL server:

   backup 3# /etc/rc.d/mysqld stop
   Stopping mysqld.
   Waiting for PIDS: 224.
   

3. Backup raw databases and dump SQL:

   backup 4# cp -pR /usr/mysql /usr/mysqlbackup/mysql
   

4. Check and repair database files:

   backup 5# myisamchk -r /usr/mysql/*/*.MYI
   

5. Start MySQL server:

   backup 6# /etc/rc.d/mysqld start
   Starting mysqld.
   

6. Update structure:

   backup 7# mysqlaction upgrade
   [snip]
   Running 'mysql_fix_privilege_tables'...
   OK
   

7. If above step gives a command not found error, ensure you have already tried to run updateserver (to update the tools) and type rehash before trying again
8. Run pre-upgrade check again:

   backup 8# updatecheck
   

9. Update server:

   backup 9# updateserver
   

10. Reboot:

    backup 10# shutdown -r now
    

11. Log in as root and check MySQL server is running:

    backup 1# /etc/rc.d/mysqld status
    mysqld is running as pid 14871.
    

12. Check databases are present:

    backup 2# mysqladd -l
    intranet
    jabberd
    

13. Delete backups:

    backup 3# rm -r /usr/mysqlbackup