Support

Akeeba Backup for Joomla!

#9281 Extract database from backup

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
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by nicholas on Monday, 09 January 2012 12:23 CST

Monday, 09 January 2012 11:14 CST

user40751
Is it possible to extract the mySql database from a full backup .JPA-file

My full backup cant be restored due to writing permissions of a webalizer folder on my site. I just need to restore the database, nothing else really.

Thanks

Jan

Monday, 09 January 2012 11:19 CST

nicholas
Hello Jan,

What you ask for is the scenic route. It's steps 2-4 of the emergency manual restoration.

Instead, do something simple:
- Download your backup archive
- Extract it locally with Akeeba eXtract Wizard (it's a free download!)
- Remove the webalizer folder and any other folder you don't want to restore.
- ZIP it up (if you're using 7-ZIP, WinZIP, PKZIP, WinRAR or anything in the like please use "normal" compression)
- Upload the ZIP file to your site and use kickstart.php to restore it

Moreover, in order to avoid having the same problem, once you restore your site please use the "Files and directories exclusion" feature in Akeeba Backup to exclude Webalizer's directory and any other files/directories which might be set read-only by your host.

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!

Monday, 09 January 2012 12:17 CST

user40751
Well, I ended up doing something like that.

I installed the backup on my localhost on my Mac, then exported the mySQL tables that I changed after the backup and updated the database on my public site. So problem is solved.

I did change the settings in the Exclusion for the Webalizer too, so now everything is settled.


Thanks


Jan

Monday, 09 January 2012 12:23 CST

nicholas
You're welcome!

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!

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!