New answers tagged

1

Check your mysql error log. tail -100 /var/log/mysql/error.log If your log says (like mine did): InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 [ERROR] InnoDB: Cannot allocate memory for the buffer pool You don't have enough memory to use the default buffer size of 128M Edit the config file ...


-1

According to the MariaDB doc, innodb_file_per_table is disabled by default. And yes, it can impact performance (like when doing bulk queries to search and replace values in a newly cloned WordPress instance). But on balance enabling it seems to increase the odds of surviving in a situation where individual database files have been corrupted (or accidentally ...


0

Basically the files ib_logfile0,ib_logfile1 contains the databse table structure and responsible for identifying the path for database connection. You will be able to find all the databases in /var/lib/mysql but all the tables using innoDB database engine are corrupted and will show the database connection error, because of removal of ...


0

You just deleted datafiles for your DB. MySQL has structure of DBs and data in separated files. Your database left with structure files (so it know about databases and tables) but your data are gone. You have to restore your database from backup. Good to know for next try - you should validate anything from the Internet with documentation of your software ...



Top 50 recent answers are included