Support

Akeeba Backup for Joomla!

#40421 Unable to restore backups, I'm not doing something correctly

Posted in โ€˜Akeeba Backup for Joomla! 4 & 5โ€™
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

Joomla! version
Joomla 5
PHP version
8.2
Akeeba Backup version
Pro 9.8.5

Latest post by tampe125 on Monday, 18 March 2024 03:32 CDT

phil.davies@davyjoneslocker.asia

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 10MiB, please upload it on your server and post a link to it.

 

I've managed to get Xammp to stop working somehow when trying to restore my Akeeba Backup file to my live hosting on Inmotion hosting.  I still have my Akeeba Backup site backup file, but I don't know how to restore that one to either localhost or put onto the live hosting.

I was having issues upgrading from Joomla 4 to 5 as all the sites I have tried to do that with have crashed and so I decided to rebuild a site in Joomla 5 on Xammp.  That was all good and working and so created a backup with Akeeba.  However I was unable to restore the site on my InMotion hosting as I was unable to connect to the database when I entered the details in Angie.

 

Trying to restore the site on the new version of Xammp I've installed I'm using these details;

 

Database type - MySQLi (preferred)

Database server host name- localhost

User name - root

Password - (left this blank as didn't set a password originally as I recall)

Database name - cooking

Database table name prefix - sfkis_

 

Now I'm not certain that those details are correct as those are the details from the database I created on localhost when I set that up and it was all working.  Something I have done has caused Xammp and the localhost version of the site I'd created to stop working on localhost.

I still have my jpa backup file I'd created from the site but don't seem able to restore it to the live site hosting on Inmotion or the localhost.  I tried entering the details for the new database I created on Inmotion and wasn't able to connect to the database and restore the localhost site to Inmotion either.  As I understand the instructions and videos the details I am supposed to be entering for the database are the ones from the database I created to work with Xammp on local host and not the ones for the new database on Inmotion right?  As at the moment I can't restore it to local host or Inmotion.  So clearly I'm doing something wrong.  I have successfully done this in the past but that was a number of years ago now.  Please can you help, happy to give you my hosting details for Inmorion so you can log in and have a look.

Thanks for any help you can offer.

Best regards

 

Phil

 

 

tampe125
Akeeba Staff

Hello,

can you please give me access to the new host where you want to restore the database?

I'll need FTP access to the new host as well as database connection details. So I can double check what's going on.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

phil.davies@davyjoneslocker.asia

Hi Davide,

 

 that's for getting back to me sure the access to my hosting is https://secure1.inmotionhosting.com/index/login username phil.davies56@gmail p/w U!f14AQAMJepp03O

 

Then the current live site is in the parawanthaicookingclass.com folder and then I've created a new folder I created is called newj5.parawanthaicookingclass.com which is where I'd tried moving the site to, when I did that I just renamed the live site folder to oldj4.parawanthaicookingclass.com just in case anything didn't work so I can just rename the folders to switch back if needed and changed the newj5.parawanthaicookingclass..com to parawanthaicookingclass..com when I was trying to do the restore.  The jpa file is still in the newj5.parawanthaicookingclass.com folder.

 

The FTP details are attached and the password is davyJ0nes

 

The database details I think for the original database on localhost are just username root with no password I'm pretty sure as I'm sure that those were recommended details from when I set that up with Xammp on my computer, I did also try and add another user of phil with the password of davyJ0nes01. 

I'm sure that it will be something I've managed to do incorrectly, as I've used Akeeba before and not had any problems.

 

If you need anything else then just let me know, I'm in Thailand and so depending on when you send me a message there may be a bit of a delay on me responding.

 

Thank you for your help with this :)

tampe125
Akeeba Staff

Hello,

I just tried to connect to http://newj5.parawanthaicookingclass.com/ but it gives me a DNS error. Are you sure everything is correctly set up?

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

phil.davies@davyjoneslocker.asia

Hi Davide,

 

 I'm not quite sure to be honest, I've not had a DNS error come up and I'm assuming that the DNS is all working find as the old site is loading up at https://parawanthaicookingclass.com and is in the folder parawanthaicookingclass.com.  That site is a Joomla 4 site which I was having issues upgrading to Joomla 5.  So I rebuilt the site on a fresh install of Joomla 5 on Xammp on local host and backed it up and that's the site I want to make live.  So what I was doing on my inmotion hosting was renaming the current site folder from parawanthaicookingclass.com to oldj4.parawanthaicookingclass.com.  Then I was renaming it the newj5.parawanthaicookingclass.com folder to parawanthaicookingclass.com and trying to restore the backed up site from Xammp to the site there as a livesite.  I didn't notice any DNS errors, where did you get one?  Should I be able to just restore my backup locally and start again on Xammp as the version I had working all fine on Xammp doesn't work for me either.

 

If you can let me know where in the process you were getting the DNS errors I can check to see if I am also getting those or not, but as I say my live site parawanthaicookingclass.com is working okay at the moment and so I don't think that there is a problem with the DNS .

tampe125
Akeeba Staff

Please take a look at the attachment.

As you can see, we can't find anything for that domain. I asked Nicholas to check for it and he didn't get anything, too. Can you please attach a screenshot of what you see when you try to connect to that domain? Can you please give me the link to the Kickstart file, where you tried to perform the restoration?

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

phil.davies@davyjoneslocker.asia

Hi Davide,

 

I think I've worked out what my issue was, as I was able to restore the backup to my localhost successfully I hadn't deleted the existing tables in the database, which I must have missed before. Once I did that it worked fine and so I think I should be fine to restore to my inmotion hosting now, I'm a bit more up to speed with everything again. 

 

tampe125
Akeeba Staff

Ok, let me know how it goes.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

phil.davies@davyjoneslocker.asia

Thanks Davide, all working fine, it was just me forgetting to drop the tables from the new database by the looks of it. https://parawanthaicookingclass.com all running on Joomla 5 now :)

tampe125
Akeeba Staff

Awesome!

Thank you for the update!

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

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!