Code: Select all
sed -i "s/TYPE/ENGINE/g" ./*.sql
Code: Select all
sed -i "s/TYPE/ENGINE/g" ./*.sql
Ok.., now jajaajja we are having progress although I got another error.., I think this is easiest to solve. What can you tell me about the error?scottwilkerson wrote:Not knowing completely how this was installed we could hit other problems, however from inside the db directory you may be able to do the following:When these scripts were written 10 years ago the TYPE directive was proper however it has been switched to ENGINE and type was deprecated in MySQL/Mariadb 5.5Code: Select all
sed -i "s/TYPE/ENGINE/g" ./*.sql
Code: Select all
[root@ip-10-0-8-150 db]# ./upgradedb -u xxxx -p xxxx -h localhost -d xxxx
Current database version: 1.4b2
** DB upgrade required for 1.4b3
Using mysql-upgrade-1.4b3.sql for upgrade...
ERROR 1060 (42S21) at line 123: Duplicate column name 'last_state'
Upgrade from mysql-upgrade-1.4b3.sql failed at ./upgradedb line 106.
Code: Select all
Current database version: 1.4b2
Code: Select all
mysql -u root -p
> DROP DATABASE nagios;
> CREATE DATABASE nagios;
Code: Select all
SELECT, INSERT, UPDATE, DELETE
Code: Select all
./installdb -u xxxx -p xxxx -h localhost -d xxxx