convert from ubuntu pkg to custombuild

[nobaloney]

I'm workng on a client server where mysql appears to be broken; even after resetting root password, the new one doesn't work.

I've decided to go ahead and convert to mysql from custombuild.

Do I have to worry about databases, etc., disappearing or not working?

Jeff

 

[zEitEr]

If MySQL version from ubuntu pkg is the same with one from custombuild, everything should work fine. Of course, you should do backups before replacing.

 

[nobaloney]

I can't seem to do backups; it's a master password issue. I can copy the files but I don't know if I'll be able to use them after the new mysql is installed.

Jeff

 

[SeLLeRoNe]

all user's db use samepassword?

I know is a long time require but you should dump using single db user/pass login no?

Regards

 

[zEitEr]

I can't seem to do backups; it's a master password issue. I can copy the files but I don't know if I'll be able to use them after the new mysql is installed.

Jeff

Sure, you can do a backup of mysql data directory. And if no version will be changed, you'll be definitely able to use those databases. Copy and use it.

Checked several times.

 

[zEitEr]

Custombuild does not do any mysql restoring, it just makes a symlink to mysql data directory:

                cd mysql

                chown -R mysql:mysql /usr/local/mysql
                chown -R mysql:mysql /usr/local/$MYSQLPACK

                rm -rf data
                ln -s /home/mysql ./data

And if mysql version changes it uses mysql_upgrade

                if [ -e /usr/local/mysql/bin/mysql_upgrade ]; then
                        /usr/local/mysql/bin/mysql_upgrade --user=${MYSQLUSER} --password=${MYSQLPASSWORD}
                elif [ -e /usr/local/mysql/bin/mysql_fix_privilege_tables ]; then
                        /usr/local/mysql/bin/mysql_fix_privilege_tables --user=${MYSQLUSER} --password=${MYSQLPASSWORD}
                fi