user image

Jo Micheal
Published in : 2022-01-09

[solved] Storage engine 'InnoDB' does not support system tables

PHP & Mysql

When i am using my backup from my server I got this error when i upload the DB to the PHPMyAdmin

Storage engine 'InnoDB' does not support system tables. [mysql.columns_priv]

Solved

After searching I realized that I used a command like to export all databases which is 

mysqldump --user root --password  --all-databases > /var/www/html/db-backups/db_backup-8-Jan-2022.sql

but this cause error when i import the file in my DB the right command is by specifying the DB which i want to export.
using this command

mysqldump --user root --password  laravel_DB > /var/www/webbrackets/db-backups/db_backup-9-Jan-2022.sql

Comments

There is no comments yet

Leave a comment

Join us

Join our community and get the chance to solve your code issues & share your opinion with us

Sign up Now

Related posts

[solved] #1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
Publish date: 2022-01-09 | Comments: 1

Tag: PHP & Mysql

MySQL - Lost connection to MySQL server during query - Required a solution.
Publish date: 2022-03-03 | Comments: 1

Tag: PHP & Mysql

change user root privelige and password
Publish date: 2022-02-23 | Comments: 1

Tag: PHP & Mysql

How the image file have .php extension?
Publish date: 2022-03-01 | Comments: 2

Tag: PHP & Mysql

Warning appears in Zend framework
Publish date: 2022-02-24 | Comments: 1

Tag: PHP & Mysql

mysql service start not exist
Publish date: 2022-02-23 | Comments: 4

Tag: PHP & Mysql

SQL full languages table
Publish date: 2022-02-24 | Comments: 2

Tag: PHP & Mysql