Re: Mysql backup

On 08/03/15 21:44, Jan Stozek wrote:
> Po głębokim namyśle Peter H. Coffin napisał w niedziela, 8 marca 2015
> 18:16:
>
>> The real question is "What does the error log say?" Everything
>> before that is guesswork and as reliable as pissing upwind.
>
> As I wrote, it's not really invormative:
>
> 2015-03-08T15:11:38.947000+01:00 pc-jasio rcmysql[1575]: Starting
> service MySQL warning: /var/run/mysql/mysql.sock didn't appear within
> 30 seconds
> 2015-03-08T15:11:38.961383+01:00 pc-jasio rcmysql[1575]: chmod: cannot
> access ‘/var/run/mysql/mysqld.pid’: No such file or directory
> 2015-03-08T15:11:38.961478+01:00 pc-jasio rcmysql[1575]: Something
> went wrong
>
> Unless there is another log somewhere, which I could not find.
>

My guess is that there is the wrong owner for /var/run/mysql this has to be owned by the user which the mysql/mariadb is run as. The same user should also own the /var/lib/mysql

ls -ld /var/run/mysql /var/lib/mysql

in most cases it should be the mysql user.

chown mysql:mysql -R /var/run/mysql /var/lib/mysql

should fix the issue.

-- 

  //Aho