user

Jo Micheal

9 Jan 2022

[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

No Comments to show

© 2024 Copyrights reserved for web-brackets.com