by sarkarijob | Mar 12, 2020 | mysql
You cannot repair an InnoDB type table, If you want to repair them you’ll have to change the table engine from InnoDB to MyIsam.To Do this, follow these simple stepsOpen your phpmyadminSelect the database you want to repair.Look for the table(s) with InnoDB type...
by sarkarijob | Feb 25, 2020 | mysql
vi /usr/local/directadmin/conf/my.cnfcat /usr/local/directadmin/conf/mysql.conf/home/sas/dbbackup_scripts.sh
by sarkarijob | Jan 2, 2020 | mysql
/usr/share/mysqlmy-huge.cnfmy-large.cnfmy-medium.cnfmy-small.cnfjust rename to my.cnf or MySQL config file in the respective location
by sarkarijob | Dec 28, 2019 | mysql
A common use of mysqldump is for making a backup of an entire database:shell> mysqldump db_name > backup-file.sqlYou can load the dump file back into the server like this:UNIXshell> mysql db_name < backup-file.sqlThe same...
by sarkarijob | Dec 24, 2019 | mysql
Mysqldump Command SyntaxBefore going into how to use the mysqldump command, let’s start by reviewing the basic syntax.The mysqldump utility expressions take the following form:mysqldump [options] > file.sqlCopyoptions – The mysqldump...
by sarkarijob | Dec 21, 2019 | mysql
set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
