MyISAM and innodb engine
I have a VM that hosts a few websites there. Today, I ran the mysqltuner.pl script to check the performance and see if there is any recommondation. I know I have a database with over 900M data. There are 67...
Tag: MyISAM
Repaire corrupted MyISAM tables
To repare the corrupted MyISAM tables, just cd to the directory that holds the MyISAM datafiles, then run this: $ myisamchk -r -q table_name If it doesn’t work, try this command, $ myisamchk –safe-recover table_name The above two commands can...
MySQL Backup and Recovery Methodologies
MySQL is very popular. Many open source or free software use MySQL as their main database engine. To make our data safe, please remember to backup your data regularly. There are two methodologies you can use to back up MySQL...