mysql-server


InnoDB Error Table mysql.innodb_table_stats not found

Follow these steps to recover from this innodb error "InnoDB: Error: Table mysql.innodb_table_stats not found.". First try to drop these tables from a mysql console: USE mysql; DROP TABLE innodb_index_stats; DROP TABLE innodb_table_stats; DROP TABLE slave_master_info; DROP TABLE slave_relay_log_info; DROP TABLE slave_worker_info; This may throw some errors. If your mysql data folder is somewhere different than the […]


ProFTPd with MySQL Backend on Debian

First of all we install the needed packages: apt-get install proftpd proftpd-mysql mysql-server The configuration files of the proftpd server are in /etc/proftpd. First we edit the file /etc/proftpd/modules.conf and add the following lines as indicated: LoadModule mod_sql.c LoadModule mod_sql_mysql.c Then we should create the mysql database and the table that will contain the proftpd users: […]