Helpful Information
 
 
Category: mySQL 3.23.39
mySQL 3.23.39 ->4.0 Upgrade Confusion

Apologies in advance if I have posted this to the wrong forum, as the solution may be part Linux.

I am currently researching how to upgrade MySQL (3.23.39) to 4.0.x which is running on a Raq4 and have found some detailed articles. So far so good. However, after looking in /usr/local could not find the mySQL folder.

Did a 'locate' which seems to show files all over the place (sample below):

/home/mysql
/home/mysql/BLU
/home/mysql/BLU/news_articles.frm
/home/mysql/BLU/news_articles.MYI
/home/mysql/BLU/news_articles.MYD
etc…
/etc/rc.d/init.d/mysql
/etc/rc.d/rc0.d/K90mysql
/etc/rc.d/rc1.d/K90mysql
/etc/rc.d/rc2.d/S90mysql
etc..
/root/.mysql_history
/usr/bin/mysql_convert_table_format
/usr/bin/mysql_fix_privilege_tables
/usr/bin/mysql_install_db
/usr/bin/mysql_setpermission
etc…
/usr/bin/mysql
/usr/bin/mysql_find_rows
/usr/bin/mysqlaccess
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
etc…
/usr/info/mysql.info.gz
/usr/lib/mysql
/usr/lib/mysql/libdbug.a
etc…
/usr/sbin/mysqld
/usr/share/mysql
/usr/share/mysql/binary-configure
/usr/share/mysql/charsets
/usr/share/mysql/charsets/Index
/usr/share/mysql/charsets/README
etc…
/usr/share/mysql/make_binary_distribution
/usr/share/mysql/mi_test_all
/usr/share/mysql/mi_test_all.res
etc…
/usr/share/mysql/swedish
/usr/share/mysql/swedish/errmsg.sys
/usr/share/mysql/swedish/errmsg.txt

I was looking to back up the mysql folder before attempting to upgrade - but does not seem to be one as indicated in the guide. The guide is telling me to simply change the name of the current mysql directory to avoid overwriting it.

Obviously, I am reluctant to proceed and my knowledge in this area is lacking.

Any ideas on where to start or why my installation does not include a /usr/local/mysql directory :confused:

I really need to back up before attempting an upgrade.

Thanks in advance,

KFY