Fast CSV import to MySQL

From the mysql command line:

load data local infile ‘d:/file.csv’ into table TABLENAME fields terminated by ‘,’;

Intel ME FW Downgrade – Request MeSpiLock Failed message on boot

tl;dr shut your machine down, remove the battery and charger to make sure all power is drained from the system, and power it up again.

I started to see this message at boot on an HP Elitebook 840 G3 after disabling Intel AMT in the BIOS. I was not able to reflash the Intel ME (Management engine) firmware from Windows because of this, and it would show error 76.

Some solutions online involved resetting the BIOS to defaults, disabling and re-enabling secure boot and re-flashing the BIOS, none of which worked for me.

My fix was to remove all power from the system, wait a while, and turn it back on. This laptop has a built in battery making that a more involved process than a “normal” laptop with a removable battery.

If you have an HP business laptop, you can enable Ship Mode, which disables the battery and is essentially the same as removing the battery (but it’s easier, since you don’t have to take the bottom cover off and unplug the battery).

Option 1: Set shipping mode by powering the computer off with key sequence
  1. Power the computer off
  2. Connect the AC adapter
  3. Press and hold Windows+ Backspace keys
  4. Power the computer on
  5. Let go of the buttons when the HP logo appears and disconnect the AC adapter
  6. The computer will either:Power off and be in shiping mode or Boot into windows and then enter shipping mode the next time it is shut down

This resolved the message on boot up for me, and when I run the Intel ME information tool, it now returns all the expected info (whereas before, it would fail to show anything because the ME was somehow crashed or locked up).

Ubuntu Apache/PHP file size upload – no change after editing PHP.ini

After editing upload_max_filesize and post_max_size in php.ini, the upload limit didn’t actually change.

Create a phpinfo.php file and check the directory listed for “Scan this dir for additional .ini files”. On Ubuntu 16.04 (and probably other versions), this is /etc/php/7.0/apache2/conf.d.

In that conf.d folder, create a file called user.ini (I don’t know one if the name matters). Then put the lines in there you want to change; for example:

post_max_size = 1500M
upload_max_filesize = 1500M

then save it.

Check phpinfo.php again and you should now see the changes reflected.

Blog at

Up ↑