Skip navigation links
Showing entries 1 to 2

Tags Filter: innobackup.pl (reset)

Articles
Add to Favourites +1 Vote Up -0Vote Down
I was surprised to find out that Innobase's Innobackup script did not read the socket file location from the "my.cnf" file.  So I added in as a feature.A few notes:\tThese modifications are against version 1.4.0 of the script.  A quick search for the "socket" keyword in the 1.5.0 version of the script did not reveal any simillar functionality to what I'm proposing here.\tThese modifications have not actually bee
Articles
Add to Favourites +0 Vote Up -0Vote Down
Recently while we were building a slave with a newer version of MySQL 5.1 from an InnoDB Hot backup, the following error occurred when we ran "mysql_upgrade":mysql.time_zone OKmysql.time_zone_leap_second OKmysql.time_zone_name OKmysql.time_zone_transition OKmysql.time_zone_transition_type OKmysql.user OKRunning 'mysql_fix_privilege_tables'...ERROR 13 (HY000) at line 311: Can't get stat of './mysql/general_log.CSV' (Errcode: 2)ERROR 13 (HY000) at line 316: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)FATAL ERROR: Upgrade failedThe problem is that in MySQL 5.1, it is possible to log the slow query log and general log to tables in the "mysql" schema (source: Selecting General Query and Slow Query Log Output Destinations). These tables are  []
Showing entries 1 to 2