MySQL Problems - SOLVED

[Martin109]

Good news!

I'm actually at another location, but at another laptop also with Vector Linux 5.9 installed, and I've got mysql working!

I followed all the steps you listed and finally got to the mysql> prompt.  Now I have to learn how to use it!

Lost it again when I rebooted, but recovered it again by following the relevant steps.  Now have to set it up so that it is available via VASMCC.

Hopefully, it'll work on the other VL 5.9 machine, when I get back to it on Thursday.

Many thanks for all your dogged help!  I'll wait until I've got the other machine working OK before I mark this 'SOLVED'.

[Martin109]

If you want to add a service that can be enabled/disabled to start at boot time via VASM:
cp /usr/share/mysql/mysql.server /etc/rc.d/init.d/mysql
you will now find mysql in the services section in VASM

This works fine, and I can get mysql to work by using VASMCC.

However, now that I'm learning how to use mysql, I see that I have to have '--local-infile=1' (ie activated) if I am conveniently to load pre-written data files into a database.

Which command do I append this to?

If you want to have mysql daemon started at boot automatically (not interactive via VASM):
chmod -x /etc/rc.d/rc.mysqld

Could it be added to rc.mysqld, for example?

[newt]

One of the steps when setting up mysql was to create a my.cnf configuration file in /etc/ (i.e. /etc/my.cnf).  You can add your option to that file in the appropriate places: under the [mysqld] and [mysql] subheads, simply append 'local-infile=1' as the last line, and restart mysql (/etc/rc.d/init.d/mysql restart)

ex)
[mysqld]
.......
local-infile=1

[mysql]
.......
local-infile=1

[Martin109]

Thanks, Newtor!

That's worked great!  Now to sort the other machine tomorrow.

[Martin109]

With many thanks due to Newtor, I've got both VL 5.9 laptops working with mysql!

Learned a lot in the process.