Tuesday 15 October 2019

HP printer error - There was a problem connecting to the Server. Press Retry to connect again.

I had this error on my HP Photosmart and after much fruitless searching for the answer, reinstalling drivers and tweaking settings, discovered that as of 1 September 2016, for older models, web services are no longer supported. See the following link to verify [retrieved 15/10/2019]:

https://support.hp.com/gb-en/product/hp-photosmart-wireless-e-all-in-one-printer-series-b110/4022328/model/4022329/document/c05211712/

Thursday 7 March 2019

MySQL Can't create/write to file (Errcode: 13)

I wanted to export a table from MySQL to CSV format, so I wrote the following MySQL to a file:

use mydb;

select *
from mytab
into outfile '/folder/myfile.csv'
fields terminated by ','
enclosed by '"'
lines terminated by '\n';

I then ran the following command line:

sudo mysql -u root < myExport.sql

This generated the following error:

ERROR 1 (HY000): Can't create/write to file '/folder/myfile.csv' (Errcode: 13)

After searching for answers to no avail, I then changed the MySQL code as follows:

select *
from mytab
into outfile 'myfile.csv'
fields terminated by ','
enclosed by '"'
lines terminated by '\n';

I then re-ran the above command line command and used the following Linux command to search the entire file system for the file:

find -name myfile.csv

It found the file in /var/lib/mysql/mydb.