Hi Terry,
It's a Perl script which effectively boils down to:
/usr/bin/mysqldump --user=$mysql_user --password=$mysql_pw --opt
--all-databases | gzip -c > mysql-dump-$theTime.sql.gz
So, yes.
Cheers,
Matt
On 25 February 2016 at 13:40, Terry Froy <[log in to unmask]> wrote:
> On Thu, 2016-02-25 at 12:39 +0000, Matt Williams wrote:
>
>> <snip>
>> Now, the error in there "Column count of mysql.db is wrong. Expected
>> 22, found 20. The table is probably corrupted" looks pretty bad. Has
>> anyone else seen this error before and does anyone have any ideas
>> about possible fixes? We have backups of the database so a restore
>> from yesterday would be possible but I'm also unsure about the best
>> way to do that.
>
> Hi Matt,
>
> What method do you use to backup your MySQL databases ?
>
> mysqldump ?
>
> Regards,
> Terry
> --
> Terry Froy
> Cluster Systems Manager, Particle Physics
> Queen Mary, University of London
> Tel: +44 (0)207 882 6560
> E-mail: [log in to unmask]
|