Tag: MySQL

Backup all databases nightly w/ mysqldump

5 July 2015

  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

19 April 2015

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 […]

MariaDB on DirectAdmin (Replace MySQL with MariaDB)

6 December 2014

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 […]

MySQL Convert from INNODB to MYISAM

8 October 2013

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 […]