Can't create database when importing site

DevKinsta Application Support
1

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.

2

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

Screenshot 2023-12-04 at 13.58.52
Screenshot 2023-12-04 at 13.58.521160×212 10.5 KB

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

[MySQL] » [devkinsta_db] » Database: YOURDATABASENAME

Screenshot 2023-12-04 at 14.03.22
Screenshot 2023-12-04 at 14.03.22938×70 5.35 KB

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

3

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:

4

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