Description of my issue: Extract 3.3 - Backup Akeeba Backup Core3.3.11 (2012-01-02)
I got multiple .s0 files - databases.ini and Joomla.sql
Using phpmyadmin to restore?
#11548 Using Extract Wizard - How to restore manually the database?
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 nicholas on Thursday, 15 March 2012 09:38 CDT
Tuesday, 13 March 2012 22:50 CDT
Chacapamac
Description of my issue: Extract 3.3 - Backup Akeeba Backup Core3.3.11 (2012-01-02)
I got multiple .s0 files - databases.ini and Joomla.sql
Using phpmyadmin to restore?
Wednesday, 14 March 2012 04:17 CDT
nicholas
Akeeba Staff
Manager
The User's Guide has everything you need. Take a look at the "Unorthodox: the emergency restoration procedure" chapter.
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!
Wednesday, 14 March 2012 09:57 CDT
Chacapamac
The only thing at didn’t look at....
It will be great if the package include a complete zip or compress database without the fuss.
That will permit an easy manual restore...
thanks.
It will be great if the package include a complete zip or compress database without the fuss.
That will permit an easy manual restore...
thanks.
Wednesday, 14 March 2012 10:01 CDT
nicholas
Akeeba Staff
Manager
And it would make the automatic restoration impossible. If you want to manually restore your databases, you can always create a database only backup.
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!
Thursday, 15 March 2012 06:34 CDT
Chacapamac
I was thinking more at keep the same files for the automatic backup and an extra complete zip database backup in the install/sql (or other) folder just in case.
Like that you have both an easy automatic and manual way in the same JPA file.
Like that you have both an easy automatic and manual way in the same JPA file.
Thursday, 15 March 2012 07:17 CDT
nicholas
Akeeba Staff
Manager
I've seen sites (like mine) where the database can be around 80Mb and the rest of the files 30Mb. The total backup archive size is about 80Mb. If I dump the database twice, not only the backup will take forever to complete, it will almost double in size. All of that for what? The off-chance that someone wants to do a manual restoration? Akeeba Backup IS NOT designed for manual restoration. It would beat the purpose. If you want to do a manual restoration, you have three choices:
- Follow the emergency restoration instructions
- Use a database backup only profile
- Use phpMyAdmin or other tools to manually dump your database
I will not screw up the major benefit of Akeeba Backup just because someone, sometime might need to do something which is against the way Akeeba Backup is supposed to work. It would be more than absurd, it would be extremely stupid to ruin my software in that way.
- Follow the emergency restoration instructions
- Use a database backup only profile
- Use phpMyAdmin or other tools to manually dump your database
I will not screw up the major benefit of Akeeba Backup just because someone, sometime might need to do something which is against the way Akeeba Backup is supposed to work. It would be more than absurd, it would be extremely stupid to ruin my software in that way.
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!
Thursday, 15 March 2012 09:34 CDT
Chacapamac
You are absolutly right — I have a site with a 90mb database and it will probably double the chance of failing by php timeout.
“Use a database” only profil, I need to try !!!.
Can I attached cron job to both a jpa backup and a database profile?
“Use a database” only profil, I need to try !!!.
Can I attached cron job to both a jpa backup and a database profile?
Thursday, 15 March 2012 09:38 CDT
nicholas
Akeeba Staff
Manager
You can create two CRON jobs, one for a full site backup and one for a database only backup. Make sure you schedule them adequately apart so that one doesn't start while the other is still running (that would cause a big problem!)
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!