On Friday 28 Jan 2011 08:37:07 Per Jessen wrote:
Cristian Rodríguez wrote:
El 27/01/11 12:56, Per Jessen escribió:
This means editing /etc/init.d/mysql or stopping and starting the server manually.
No!, you should add load-infile to the mysqld section in /etc/my.cnf
Very true, a much better place.
OK, I'm following all this. What is the syntax for adding load-infile to this file? All the entries seem to be of the form option = value Ah. I see 'skip-locking' on a line by itself. So, I just need to add 'load- infile' under that? My other problem has been getting the server running. Because I'd forgotten the root password (I must have set it a long time ago), I've been through various convolutions involving stopping the server, running mysql_safe --skip- grant-tables, and updating the password. Mysql_safe dumps me at a promptless console, which seems to accept input commands, but doesn't honour exit or quit, so I end up killing it by closing the terminal. This doesn't seem very satisfactory, as shown by the fact that the server won't restart. I'm starting and stopping it in Yast > System Services (Runlevel). I think I might have to try that old rebooting trick. :-o Thanks for your help. Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.3 64-bit, Kernel 2.6.36.90-desktop, KDE 4.5.3 Intel Core2 Quad Q9400 2.66GHz, 8GB DDR RAM, nVidia GeForce 9600GT -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org