Support

Site Restoration

#34774 Kickstart Trying to Create database that already exists

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Tuesday, 06 April 2021 20:17 CDT

jimbrooking

Trying to "refresh" my development site using a backup of my production site fearringtonfha.org (Akeeba Pro license) from this morning. Filled in restore fields I have used "forever" with no previous problems (screenshot.4). Get an immediate error message (screenshot.3) apparently saying kickstart is trying to create the database that's already there. Database name same as shown in PHPmyAdmin, username and password as shown in site tools (not changed since last restoration.). What has changed is SiteGround migrating my site from cPanel to Site Tools, which I hate but was given no choice acter several years with cPanel.

Any ideas?

Thanks,
Jim

nicholas
Akeeba Staff
Manager

It's ANGIE, not Kickstart. Kickstart only extracts the backup archive. The backup archive includes a restoration script called ANGIE, placed there at backup time. This is the script which restores your site's database and reconfigures the site. This information is printed when you run Kickstart.

ANGIE will first attempt to connect to your database server using the username, password you have provided. If this fails, it shows an error.

Then, it tries to select the database name you provided, i.e. it tells the database server it would like to operate on the database with that specific name. If the server reports with an error (the exact error message IS NOT conveyed by the low-level MySQL connector PHP provides) ANGIE will try to instead create the database. If that fails, too, it returns an error. This has always been the case.

Normally, trying to create a database without adequate privileges results in an error we can capture and instead show you the message about the database not existing or the connection information being wrong.

In any case, the problem is that either the database name does not exist or the database user does not have adequate permissions to access it. Using Site Tools or cPanel or anything else is irrelevant. This is a MySQL server we're talking about. The hosting control panel configures not but has no say on how PHP scripts connect to it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!