Backup all databases nightly w/ mysqldump This is something very useful and everybody should be doing this. Because you can’t trusted the hosting provider backup. So you should always make your own backup and here is the tools will help you make your own mysql backup with ease. #!/bin/bash DB_BACKUP=”/backups/mysql_backup/`date +%Y-%m-%d`” DB_USER=”root” DB_PASSWD=”secretttt” HN=`hostname | […]
How to Recover InnoDB Corruption for MySQL Assume you’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk […]
Replace MySQL with MariaDB on DirectAdmin MySQL…It seems these days everybody doing something in the IT branch has used it, or still does. However, there are some problems: you only get the fun stuff (like clustering etc) if you pay big time, its development is stalling (more and more core developers are leaving), a […]
Convert from INNODB to MYISAM MYISAM is use by very less hosting companies now a days, as its mostly provided with the shared hosting account. But sometimes, we needed to change mysql engine, when its create a problem while exporting and importing sql data from INNODB to MYISAM engine. Steps to follow: Take backup of […]
