error while restoring database from mysql: ERROR 1006 (HY000)

by user103591   Last Updated June 12, 2019 22:06 PM

i made a mysqldump from all my databases prior to fully deinstall and reinstall mariadb. while restoring the databases with the following command, logged in as root:

mysql -u root -p < /mnt/backups/190612alldb.sql

i'm getting the following error:

ERROR 1006 (HY000) at line 22: Can't create database 'mydatabase' (errno: 2 "No such file or directory")

'mydatabase' is just one of several databases i previously dumped. when this error occurs none of the databases is restored.

what's going on here?



Related Questions


Updated June 02, 2015 10:02 AM

Updated May 14, 2016 08:02 AM

Updated February 25, 2017 03:06 AM

Updated April 13, 2017 10:06 AM

Updated August 08, 2017 10:06 AM