mysql

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 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 »

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

Restore database in mysql Read More »

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 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 »

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 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 »