Akeeba Backup for Joomla!

Wednesday, 04 April 2012 18:57 CDT

michael.hermary

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: (1.5)
PHP version: (5.3)
MySQL version: (5.1.61)
Host: (www.the-essence.ca)
Akeeba Backup version: (Akeeba Backup Professional 3.4.3 (2012-03-21))

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 2Mb, please upload it on your server and post a link to it.

Description of my issue:
I have a backup file from www.gaiacollege.ca that contanins the joomla database backup and the moodle database backup. I want to restore it on www.the-essence.ca I can find sql files and ini file but there is no installation/index.php file or installation directory or php files. I can edit the ini file and I can piece together the sql files but that looks like a pain. I assume the restore routine loops through all the sql pieces. Do you have some code that just restores to a database?

Cheers,
Michael

Thursday, 05 April 2012 01:27 CDT

nicholas

If you took a database only backup, then this is exactly what you get: a bunch of SQL files. If you don't want to restore them manually, you'll have to improvise a little.

Start by taking a full site backup of any site. Extract the archive locally and delete everything except the installation directory. Copy the SQL files and the INI form the backup you want to restore into the installation/sql directory. Upload the installation directory to the site you want to restore to and access the script, e.g. http://www.example.com/installation/index.php. After you go past the database restoration step, do not continue. Close the page and delete the installation directory.

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, 05 April 2012 12:09 CDT

michael.hermary

Does the site transfer wizard work for moving a site to a different server with a different domain?

Thursday, 05 April 2012 15:19 CDT

nicholas

Yes, of course. That's what it was designed to do. Furthermore, if you take a backup and restore it on another server, on another domain name it will work. Akeeba Backup is a site backup, restoration and migration tool. As a matter of fact, Akeeba Backup was created as a means to facilitate moving sites between production and testing servers. The backup part, well, it was just a happy accident :)

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, 05 April 2012 22:56 CDT

michael.hermary

Can I point akeeba on one site to restore from S3 backups that were created on another site. I am looking for something that happened in the last three weeks and having to restore database backups to find it.

Friday, 06 April 2012 03:57 CDT

nicholas

Yes and no. Using the Discover and Import Archives feature of Akeeba Backup you can import backup archives from S3 into your current site and default profile. If the default profile (#1) is set up to upload files to remote FTP, back in the Administer Backup Files page you can click on "Transfer archive" to move the backup archive to the remote FTP server. All you need is upload Kickstart to that site and start the restoration. This way you can use any random site with Akeeba Backup Professional as the "intermediary" between S3 and the site you are restoring to.

BTW, if you attend Joomla! Day Netherlands, I am going to talk about this in more detail :)

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!

Friday, 06 April 2012 11:36 CDT

michael.hermary

I won't be attending Joomla Day Netherlands, I live on the west coast of Canada.

I am using kickstart and backup installer to restore past databases on a development site. Akeeba installer has taken over the frontend of the site. I will email you the site name if you want to look.

Friday, 06 April 2012 11:39 CDT

nicholas

If you see the Akeeba Backup Installer, then you have to remove the installation directory. If you don't see the installation directory, you're looking at the wrong directory. installation directory = Akeeba Backup Installer :)

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!

Friday, 06 April 2012 18:18 CDT

michael.hermary

I have a problem restoring the database only backups. I did a fullsite restore of the production site to the dev site and then I was trying to use the kickstart method to install db only backups. this did not work. It looks to me that it kept restoring the db from the fullsite backup. Can the copy of Akeeba on the dev site be causing problems? The db only backups are stored on S3.

Saturday, 07 April 2012 03:50 CDT

nicholas

I think you are trying to do your life harder than it is supposed to be :)

If you have a database only backup archive, just extract it locally with Akeeba eXtract Wizard. It will result in a number of joomla.sql, joomla.s01 and so on files. All of them are standard SQL dump files which you can restore with any database tool, such as phpMyAdmin.

If you see Akeeba Backup Installer when you try to access your site, this can only mean one thing: you have an installation directory. This is the one and only way to get Akeeba Backup Installer running on your site. You have to delete that directory.

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!

Saturday, 07 April 2012 07:21 CDT

michael.hermary

I have been looking for an event that occurred in our moodle in the last three weeks. This has meant restoring something like 25 instances of our moodle db. In the akeeba restore there are around 340 pieces for that db, manual restore through phpmyadmin is too painful. I wrote a script to re-number the pieces and then concatenate them. Then I used cpanel database import to upload that file.

The issue I was addressing previously is that /installation/index.php was restoring the backup that came with the full-restore that I had done. Even though I had extracted the moodle db in installation/sql it restoring the db from the full back up.

I have found something that is working for me.
Thanks,
Michael

Saturday, 07 April 2012 11:48 CDT

nicholas

Yes, you are right about that, it's difficult restoring many SQL files. I think I should write a db only restoration script at some point. Well, another item in the never ending to do list :)

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, 07 May 2012 18:00 CDT

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2012-05-07 18:00 CDT

Support