Support

Site Restoration

#41290 MAMP 7.0 database restoration failure

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
8.1.29
CMS Type
WordPress
CMS Version
6.6.2
Backup Tool Version
8.2.7
Kickstart version
8.0.6

Latest post by duanemitchell on Monday, 04 November 2024 07:56 CST

duanemitchell

I've used Akeeba Backup for a long time and I think I'm pretty good with it. I want to take a site from a server and move it to my MAMP 7.0 server.

 

Runtime error log:

RuntimeException — Unable to connect to the Database: Access denied for user 'tmdrdvpo_w0lz6ky'@'localhost' (using password: YES)

/Users/dm/Sites/massachusettsdriversunited/installation/framework/database/driver.php::L286

#0 /Users/dm/Sites/massachusettsdriversunited/installation/platform/models/wordpresssetup.php(81): ADatabaseDriver::getInstance(Array)
#1 /Users/dm/Sites/massachusettsdriversunited/installation/angie/models/base/setup.php(46): AngieModelWordpressSetup->getSiteParamsVars()
#2 /Users/dm/Sites/massachusettsdriversunited/installation/platform/models/wordpresssetup.php(20): AngieModelBaseSetup->getStateVariables()
#3 /Users/dm/Sites/massachusettsdriversunited/installation/platform/views/setup/view.html.php(34): AngieModelWordpressSetup->getStateVariables()
#4 /Users/dm/Sites/massachusettsdriversunited/installation/framework/view/view.php(531): AngieViewSetup->onBeforeMain()
#5 /Users/dm/Sites/massachusettsdriversunited/installation/framework/controller/controller.php(549): AView->display()
#6 /Users/dm/Sites/massachusettsdriversunited/installation/framework/controller/controller.php(554): AController->display()
#7 /Users/dm/Sites/massachusettsdriversunited/installation/framework/controller/controller.php(511): AController->main()
#8 /Users/dm/Sites/massachusettsdriversunited/installation/framework/dispatcher/dispatcher.php(264): AController->execute('default')
#9 /Users/dm/Sites/massachusettsdriversunited/installation/framework/application/application.php(177): ADispatcher->dispatch()
#10 /Users/dm/Sites/massachusettsdriversunited/installation/index.php(130): AApplication->dispatch()
#11 /Users/dm/Sites/massachusettsdriversunited/installation/index.php(249): mainLoop()
#12 {main}

nicholas
Akeeba Staff
Manager

This message comes from your database server and tells you that the username and password you are using is wrong, or this user does not have access to the database name you specified.

Have you created a database? You must create one before restoring a site.

Have you created a database user? You must create one before restoring a site.

Have you given that database user all privileges to the created database? This is mandatory. A database user by itself does nothing; you need to tell your database server which database(s) it gives which privileges to.

Are you using the correct hostname, username, password, and database name? Obviously, if you enter the wrong connection information it won't work.

Your problem is definitely one of the above. The MAMP version has nothing to do with 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!

duanemitchell

Yes you are exactly correct. It's been awhile since I used MAMP. It has different connection settings than the live server. Forgot about that. I appreciate the support.

Duane Mitchell

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!