Can't create database when importing site

Hi,

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.

Regards,
Alessandro

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.

Regards,
Alessandro