The storage engine for the table doesn’t support repair. InnoDB or MyISAM?
You cannot repair an InnoDB type table, If you want to repair them you’ll have to change the table engine…
directadmin mysql password change
vi /usr/local/directadmin/conf/my.cnf cat /usr/local/directadmin/conf/mysql.conf /home/sas/dbbackup_scripts.sh
mysql modes
/usr/share/mysql my-huge.cnfmy-large.cnfmy-medium.cnfmy-small.cnf just rename to my.cnf or MySQL config file in the respective location
Restore database in mysql
A common use of mysqldump is for making a backup of an entire database: shell> mysqldump db_name > backup-file.sql You can load…
How to Back Up and Restore MySQL Databases with Mysqldump
Mysqldump Command Syntax Before going into how to use the mysqldump command, let’s start by reviewing the basic syntax. The…
Got a packet bigger than ‘max_allowed_packet’
set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
How To Create a New User and Grant Permissions in MySQL
Introduction MySQL is an open-source database management software that helps users store, organize, and later retrieve data. It has a…
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation solution: download the SQL file then…
Connect to a MySQL database remotely
In order to perform these steps, you must have local server access to log in as the root MySQL user. Retrieve your…
“MySQL server has gone away“ while importing SQL Dump – Solved
When you try to import a large SQL file to your MySQL database but midway through the process, it shows…