Support

hello,

I am trying to restore to a earlier version of my site from a backup, but I gett the error msg : 

"Akeeba Backup Site Restoration Script v.9.9.9
 Previous
 Skip Restoration
 Next
No idea what you are supposed to do? Don't panic!  Read the documentation page
Pre-installation  Database Restoration  Site Setup  Finished
 Show / hide help
Restoration of site's main database
Connection information
Database type

Database server host name

User name

Password

Database name

Database table name prefix

Uncommon Options
The following options are used in less common and exotic MySQL configurations.
 Use SSL/TLS
SSL Ciphers

SSL Certificate file

SSL Key file

SSL CA file

 Verify Server Certificate
Advanced options
With existing tables

 Suppress foreign key checks
 No auto value on zero
 Use REPLACE instead of INSERT
 Force UTF-8 collation on database
 Force UTF-8 collation on tables
 Allow UTF8MB4 auto-detection
 Stop on CREATE error
 Stop on other error
Fine tuning

Do not change these settings unless you are requested to do so by our support or you REALLY know what you are doing.
Maximum execution time

Throttle time (msec)

Copyright ©2006 – 2024 Akeeba Ltd. All rights reserved.
ANGIE is Free Software distributed under the GNU GPL version 3 or any later version published by the FSF.
Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Wrong database connection information

We were unable to connect to your database server using the server host name, username and password you provided.

The error received was:

Cannot connect to the database: one or more of the database host name, user name and password you have provided is incorrect.

Unable to connect to the Database: MySQL server has gone away

How to fix this error
Show / Hide

Debug information
Show / Hide

Please include this information in your support request if you need further assistance. Do tell us which troubleshooting steps you've already tried.

Cannot connect to the database: one or more of the database host name, user name and password you have provided is incorrect.

/Users/serge/Sites/belgard/installation/framework/database/restore/mysqli.php:84

#0 /Users/serge/Sites/belgard/installation/framework/database/restore/mysqli.php(46): ADatabaseRestoreMysqli->getDatabase()
#1 /Users/serge/Sites/belgard/installation/framework/database/restore.php(309): ADatabaseRestoreMysqli->__construct('site.sql', Array, Object(AContainer))
#2 /Users/serge/Sites/belgard/installation/angie/controllers/dbrestore.php(57): ADatabaseRestore::getInstance('site.sql', Array, Object(AContainer))
#3 /Users/serge/Sites/belgard/installation/framework/controller/controller.php(511): AngieControllerDbrestore->start()
#4 /Users/serge/Sites/belgard/installation/framework/dispatcher/dispatcher.php(264): AController->execute('start')
#5 /Users/serge/Sites/belgard/installation/framework/application/application.php(177): ADispatcher->dispatch()
#6 /Users/serge/Sites/belgard/installation/index.php(130): AApplication->dispatch()
#7 /Users/serge/Sites/belgard/installation/index.php(249): mainLoop()
#8 {main}
Unable to connect to the Database: MySQL server has gone away

/Users/serge/Sites/belgard/installation/framework/database/restore.php:865

#0 /Users/serge/Sites/belgard/installation/framework/database/restore/mysqli.php(75): ADatabaseRestore->getDatabase(false)
#1 /Users/serge/Sites/belgard/installation/framework/database/restore/mysqli.php(46): ADatabaseRestoreMysqli->getDatabase()
#2 /Users/serge/Sites/belgard/installation/framework/database/restore.php(309): ADatabaseRestoreMysqli->__construct('site.sql', Array, Object(AContainer))
#3 /Users/serge/Sites/belgard/installation/angie/controllers/dbrestore.php(57): ADatabaseRestore::getInstance('site.sql', Array, Object(AContainer))
#4 /Users/serge/Sites/belgard/installation/framework/controller/controller.php(511): AngieControllerDbrestore->start()
#5 /Users/serge/Sites/belgard/installation/framework/dispatcher/dispatcher.php(264): AController->execute('start')
#6 /Users/serge/Sites/belgard/installation/framework/application/application.php(177): ADispatcher->dispatch()
#7 /Users/serge/Sites/belgard/installation/index.php(130): AApplication->dispatch()
#8 /Users/serge/Sites/belgard/installation/index.php(249): mainLoop()
#9 {main}"

can youu please help as I am at my wits end.

my database link

hello,

I read the documemt. I was able to create the database in mamp/phpmyadmin

I ran the kickstart.php.

the backup was restored I closed tthe window and went back to the page "

I clicked on visit your site's frontend button, and then, I get this error message:

Could not connect to PDO: SQLSTATE[HY000] [2002] No such file or directory   Joomla\Database\Exception\ConnectionFailureException  in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Pdo/PdoDriver.php (line 334) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php -> connect (line 182) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/DatabaseDriver.php -> connect (line 1745) DatabaseDriver->setQuery(object(MysqlQuery))in /Users/serge/Sites/belvillejoom/libraries/src/Menu/SiteMenu.php (line 166)

1. )
2. ->bind(':currentDate2', $currentDate)
3. ->order($this->db->quoteName('m.lft'));
5. $items = [];
6. $iterator = $this->db->setQuery($query)->getIterator();
8. foreach ($iterator as $item) {
9. $items[$item->id] = new MenuItem((array) $item);
10. }

SiteMenu->Joomla\CMS\Menu\{closure}()in /Users/serge/Sites/belvillejoom/libraries/src/Cache/Controller/CallbackController.php (line 51) CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)in /Users/serge/Sites/belvillejoom/libraries/src/Menu/SiteMenu.php (line 179) SiteMenu->load()in /Users/serge/Sites/belvillejoom/libraries/src/Menu/AbstractMenu.php (line 333) AbstractMenu->getMenu()in /Users/serge/Sites/belvillejoom/libraries/src/Menu/AbstractMenu.php (line 164) AbstractMenu->getItem(null)in /Users/serge/Sites/belvillejoom/libraries/src/Application/SiteApplication.php (line 434) SiteApplication->getTemplate(true)in /Users/serge/Sites/belvillejoom/libraries/src/Error/Renderer/HtmlRenderer.php (line 50) HtmlRenderer->render(object(ConnectionFailureException))in /Users/serge/Sites/belvillejoom/libraries/src/Exception/ExceptionHandler.php (line 136) ExceptionHandler::render(object(ConnectionFailureException))in /Users/serge/Sites/belvillejoom/libraries/src/Exception/ExceptionHandler.php (line 73) ExceptionHandler::handleException(object(ConnectionFailureException))in /Users/serge/Sites/belvillejoom/libraries/src/Application/CMSApplication.php (line 336) CMSApplication->execute()in /Users/serge/Sites/belvillejoom/includes/app.php (line 58) require_once('/Users/serge/Sites/belvillejoom/includes/app.php')in /Users/serge/Sites/belvillejoom/index.php (line 32) PDOException 

SQLSTATE[HY000] [2002] No such file or directory

in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Pdo/PdoDriver.php (line 327) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Pdo/PdoDriver.php -> __construct (line 327) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php -> connect (line 182) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/DatabaseDriver.php -> connect (line 1745) DatabaseDriver->setQuery(object(MysqlQuery))in /Users/serge/Sites/belvillejoom/libraries/src/Menu/SiteMenu.php (line 166)

1. )
2. ->bind(':currentDate2', $currentDate)
3. ->order($this->db->quoteName('m.lft'));
5. $items = [];
6. $iterator = $this->db->setQuery($query)->getIterator();
8. foreach ($iterator as $item) {
9. $items[$item->id] = new MenuItem((array) $item);
10. }

SiteMenu->Joomla\CMS\Menu\{closure}()in /Users/serge/Sites/belvillejoom/libraries/src/Cache/Controller/CallbackController.php (line 51) CallbackController->get(object(Closure), array(), 'd17e8e13b99b4d9bf23a7d0b83a466c3', false)in /Users/serge/Sites/belvillejoom/libraries/src/Menu/SiteMenu.php (line 179) SiteMenu->load()in /Users/serge/Sites/belvillejoom/libraries/src/Menu/AbstractMenu.php (line 333) AbstractMenu->getMenu()in /Users/serge/Sites/belvillejoom/libraries/src/Menu/AbstractMenu.php (line 164) AbstractMenu->getItem(null)in /Users/serge/Sites/belvillejoom/libraries/src/Application/SiteApplication.php (line 434) SiteApplication->getTemplate(true)in /Users/serge/Sites/belvillejoom/libraries/src/Error/Renderer/HtmlRenderer.php (line 50) HtmlRenderer->render(object(ConnectionFailureException))in /Users/serge/Sites/belvillejoom/libraries/src/Exception/ExceptionHandler.php (line 136) ExceptionHandler::render(object(ConnectionFailureException))in /Users/serge/Sites/belvillejoom/libraries/src/Exception/ExceptionHandler.php (line 73) ExceptionHandler::handleException(object(ConnectionFailureException))in /Users/serge/Sites/belvillejoom/libraries/src/Application/CMSApplication.php (line 336) CMSApplication->execute()in /Users/serge/Sites/belvillejoom/includes/app.php (line 58) require_once('/Users/serge/Sites/belvillejoom/includes/app.php')in /Users/serge/Sites/belvillejoom/index.php (line 32) Joomla\Database\Exception\ConnectionFailureException 

Could not connect to PDO: SQLSTATE[HY000] [2002] No such file or directory

in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Pdo/PdoDriver.php (line 334) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php -> connect (line 196) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php -> connect (line 223) DatabaseHandler->open('/Applications/MAMP/tmp/php', 'e727f9fcc4b10f0053d7ed18bd832731') in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/session/src/Storage/NativeStorage.php session_start (line 459) NativeStorage->start()in /Users/serge/Sites/belvillejoom/libraries/src/Session/Storage/JoomlaStorage.php (line 313) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/session/src/Session.php -> start (line 396) in /Users/serge/Sites/belvillejoom/libraries/vendor/joomla/session/src/Session.php -> start (line 327) Session->has('user')in /Users/serge/Sites/belvillejoom/libraries/src/Session/Session.php (line 194) Session->get('user')in /Users/serge/Sites/belvillejoom/libraries/src/Factory.php (line 372) Factory::getUser()in /Users/serge/Sites/belvillejoom/libraries/src/Application/SiteApplication.php (line 570) SiteApplication->initialiseApp()in /Users/serge/Sites/belvillejoom/libraries/src/Application/SiteApplication.php (line 238) SiteApplication->doExecute()in /Users/serge/Sites/belvillejoom/libraries/src/Application/CMSApplication.php (line 306) CMSApplication->execute()in /Users/serge/Sites/belvillejoom/includes/app.php (line 58) require_once('/Users/serge/Sites/belvillejoom/includes/app.php')in /Users/serge/Sites/belvillejoom/index.php (line 32) PDOException 

SQLSTATE[HY000] [2002] No such file or directory

This is ridiculous, I followed all the instructions to the letter. I tried several times. but I still get that message page after clicking "visit your site's frontend" button.

Somebody help me please!!!!

Tthis is a video that shows  the process I followed from start to finish

Tthis is a video that shows  the process I followed from start to finish

I could no tupload the video so here is the link for it:

https://www.dropbox.com/scl/fi/2a6kushf6tqchke96adtv/backup_resttore_issue.mp4?rlkey=wt2w2qjgqt2amedpb6pk64uu2&dl=0

Welll I tried localhost, and even 127.0.0.1 and i get msg that it cannot connect to database. The only thing that works is what I put in the video.

ok, after extensive trial and error, I finally succeeded with the info shown in the screenshot

This is far from being straightforward  because you have to actually:

1. enter localhost,
2. then the username and password to access phpmyadmin instead of the actual password of the specific database,
3.  then the database name,
4. and choose "mysql pdo driver" because with "mysqli(prefered)" it does not work.

as shown in the screenshot.