Import MySQL database backup

Asked Dec 21 '20 at 19:19

Active Dec 21 '20 at 20:22

Viewed 132 times

I want to import a MySQL database backup, I have searched through SO and find these two questions, How to restore SQL file generated by MySQLDump using command prompt and How do I import an SQL file using the command line in MySQL? very relevant. They seems to have answer but when i try these solutions mysql -u username -p database_name < file.sql on windows 10 mysql 10.1.37 I get following error

Unknown database 'keepa<keepa.sql' Although i have given database present when i query show databases; enter image description here

I have created different databases names and sometime left it blank or put space between '<' symbol but does not succeed in this. Please help me in this regard. Thank you

Edit: as pointed out in comment i want to further clarify that. I'm running it from same directory where the keepa.sql does exist and i have keepa database name already in db. in case of space between keepa < keepa.sql i grt error '<' is reserved for future use.

edited Dec 21 '20 at 20:22

asked Dec 21 '20 at 19:19

Sher Khan Mari

You need a `CREATE DATABASE \`keepa\`` either in the Backup file, or you have to manually create that database so the restore can put data into table within that database – RiggsFolly Dec 21 '20 at 19:24
'keepa – Mohamed Mufeed Dec 21 '20 at 19:31
Also you should be running this command from the directory where keepa.sql is stored and must exit from mysql terminal. – Mohamed Mufeed Dec 21 '20 at 19:35

Import MySQL database backup

0 Answers0