user2666249
user2666249

Reputation: 117

Exported all MySQL databases to a single file

Accidentally I exported all my mySQL databases to a single .sql file. I want to create those databases again in my development environment. When I try to import the file via PHPMyAdmin I get the following error message: enter image description here

What should I do? Could you please help me?

Upvotes: 1

Views: 154

Answers (1)

Wolfsmash
Wolfsmash

Reputation: 119

If you look at the error, it says no Database selected. You need to create an identical Database and import it from their.

You cannot just import a whole database, as it does not work.

Let me know if this solves,

Bryce

*also, make sure the files are speared by database, as this could make the error also, as the import can only import one in one file

Upvotes: 2

Related Questions