Re: Mysql backup

On 08/03/15 15:11, Michael Vilain wrote:
> In article <23766381.ZMWZCBpQVG_at_pc-jasio.stozek.waw.pl>,
> Jan Stozek <conus-spm_at_chello.pl> wrote:
>
>> Hi all,
>>
>> I have a MariaDB server for my home purposes. Recently it went
>> nuts, so I wanted to restore a last day's state - I make an almost
>> full backup every night.
>>
>> I stopped the mysql service, zipped the current contents of the
>> /var/lib/mysql directory (just in case), restored the contents of the
>> directory from a backup, and tried to start the service. It failed,
>> with no meaningful trace in the system log - just an info that
>> something had gone wrong, the mysqld did not appear within 30 seconds,
>> and there was no /var/run/mysql.pid.
>>
>> I tried to restore the previous state of the server by
>> unzipping the /var/lib/mysql files back, but the result was exactly
>> the same: the server did not start any more.
>>
>> Reboot did not help either.
>>
>> How can I fix the situation?
>>
>> Thank you very much for your help.
>
> That's not a backup.

IF you use ISAM it effectively is.

I suspect the permissions may be wring.

>
> We use mysqldump to create exports of the table structure and the data.
>
> <http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html>
>
> It works great in that it quiets the database, does the backup to a SQL
> format which can go to any server,
>

-- 
Everything you read in newspapers is absolutely true, except for the 
rare story of which you happen to have first-hand knowledge. – Erwin Knoll