Can't create database when importing site


I am trying to import a site. I get this error in the log:

Error in operation SITE_CREATION, step database: Error: Error (1): RERROR 1007 (HY000) at line 1: Can’t create database ‘EQ2_Light’; database exists

How can I resolve this issue? I am not sure how/where to delete a partial database.

Thanks in advance for your help.

Hey @Noelle_Steegs :wave:,
This might be due to a previously failed import.
Open DevKinsta and select any site. At the top, you should see a Database manager button

Once there, at the top of your screen you should be able to see a path like the following:

[MySQL] » [devkinsta_db] » Database: YOURDATABASENAME

Click on devkinsta_db, then check the box at the side of EQ2_Light and then click the button.
This will delete the database called EQ2_Light and its contents, so be sure you don’t need that and that is currently not in use by another local site.


Thank you Alessandro. Because of time constraints I went for a workaround, where I renamed the site in My Kinsta. After that the site imported without problems. Have a nice day. :slight_smile:

I’m glad you were able to resolve the issue on your side @Noelle_Steegs :+1:
Feel free to reach out in case you need further help.