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 steps Open your phpmyadmin Select the database you want to repair. Look for the table(s) with InnoDB type storage engine and note down their names. …
The storage engine for the table doesn’t support repair. InnoDB or MyISAM? Read More »
vi /usr/local/directadmin/conf/my.cnf cat /usr/local/directadmin/conf/mysql.conf /home/sas/dbbackup_scripts.sh
/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
A common use of mysqldump is for making a backup of an entire database: shell> mysqldump db_name > backup-file.sql You can load the dump file back into the server like this: UNIX shell> mysql db_name < backup-file.sql The same in Windows command prompt: mysql -p -u [user] [database] < backup-file.sql PowerShell C:> cmd.exe /c “mysql -u root -p db_name …
Mysqldump Command Syntax Before 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.sql Copy options – The mysqldump options file.sql – The dump (backup) file To use the mysqldump command the MySQL server must be accessible and running. Backup a …
How to Back Up and Restore MySQL Databases with Mysqldump Read More »
set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
Introduction MySQL is an open-source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial will give a short overview of a few of the many options. What the Highlights Mean Throughout this tutorial, any lines that …
How To Create a New User and Grant Permissions in MySQL Read More »
Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation solution: download the SQL file then import it as a root user then give permission to the same database with the IP based user. GRANT ALL PRIVILAGES ON tacportal_db.* to tacportal_db@’IP’ IDENTIFIED BY ‘tacportal_db’;
In order to perform these steps, you must have local server access to log in as the root MySQL user. Retrieve your IP address You need to know the Internet Protocol (IP) address of the computer from which you’re connecting. You can retrieve this information by visiting one of the following sites: https://icanhazip.com https://www.whatismyip.com Grant access Perform …
When you try to import a large SQL file to your MySQL database but midway through the process, it shows this error: “General error: 2006 MySQL server has gone away“ There are two reasons for that error: The server timed out and closed the connection. The server dropped an incorrect or too large packet. If …
“MySQL server has gone away“ while importing SQL Dump – Solved Read More »