Re: Mysql backup

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.

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,

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]