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

php difference between two times in hours
Publish date: 2022-02-25 | Comments: 2

Tag: PHP & Mysql

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql

ERROR 1410 (42000): You are not allowed to create a user with GRANT
Publish date: 2022-04-01 | Comments: 2

Tag: PHP & Mysql

phpmyadmin manual installation gives following error
Publish date: 2022-07-11 | Comments: 6

Tag: PHP & Mysql

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql

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

Tag: PHP & Mysql