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 »

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 »

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

Connect to a MySQL database remotely Read More »

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

Open chat