Akeeba Backup for Joomla!

Monday, 12 September 2011 03:50 CDT

user19306

Nicholas,
Please could you refer me to any documentation or Video Tutorials on >

1) Transfer Wizard.
Do you have to extract on the new Host location like you do with a normal backup?

2)Database only Backup.
How do I set up a profile for a Database only Backup and restore.
Do you still have to extract the Transfer once sent to the new host?

Monday, 12 September 2011 03:54 CDT

nicholas

Hi Mike!

1. The Site Transfer Wizard is documented at https://www.akeebabackup.com/documentation/akeeba-backup-documentation/stw.html I have not made any videos about that feature yet.

2. In order to create a database only backup you need to carry out the following steps:
- Create a new profile using the Profile Manager
- Back in Akeeba Backup's Control Panel, select the newly created profile from the drop-down list. The page reloads and informs you that the profile has been changed.
- Click on the Configuration button.
- Find the "Backup Type". You can set it to "Main site database only" to produce a database-only SQL file instead of a site archive.
- Run a backup

From now on, whenever you need a database only backup you can simply select this profile from the drop-down list and go to Backup Now to take 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!

Monday, 12 September 2011 04:03 CDT

user19306

Nicholas,
Re the Database only Backup
Presumably you can then FTP it to the Copy Site and restore & extract it in the normal way?

Monday, 12 September 2011 04:29 CDT

nicholas

Hi Mike,

The database only backup does not come with an installer. You have to restore the resulting MySQL dump (the .sql file) with a suitable tool. I suggest either of the following two:
- Most (all?) hosts have phpMyAdmin integrated in their hosting control panel. It goes without saying, you can use it to restore the SQL file of one site to the other.
- If you want something fast and reliable, there's also Alexey Ozerov's bigdump.php. This is the code upon which the Joomla! installer's database installer code is based and large parts of it have been used in the Akeeba Backup Installer. It's a breeze to use and I recommend it without hesitation for restoring database-only backups when all you have is FTP and database access.

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, 12 September 2011 04:41 CDT

user19306

Nichaolas,
I have just opened up PHP Admin, Wow,! It is beyond my level of competence.
Is there a simple way to do this Database transfer to another host? May be the Transfer Wizard would do the same thing?

Monday, 12 September 2011 04:57 CDT

nicholas

Yeah, that's why I suggested BigDump. You just upload bigdump.php and the SQL database dump file in your site's root and run http://www.yoursite.com/bigdump.php on your browser. The rest is pretty much self-explanatory. You just select the SQL file, fill in your database connection information, sit back and enjoy ;)

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, 12 September 2011 06:07 CDT

user19306

Sorry to be dumb, But you knew that already !!
Where from and How do I upload bigdump.php and the SQL database file to to Root of the 2nd host root?
Where do I get bigdump.php from?

Monday, 12 September 2011 06:18 CDT

nicholas

LoL! No worries, here's what to do:
- Download BigDump from http://www.ozerov.de/bigdump.zip
- This is a ZIP file. Extract it. You should see bigdump.php.
- Upload bigdump.php using FTP to the second site's root
- Your SQL file is located in the first site, under administrator/components/com_akeeba/backup (unless you changed Akeeba Backup's Output Directory in the configuration). Download it. It's a file ending in .sql
- Now upload that file to the second site's root.
- And now you can run BigDump as http://www.yoursite.com/bigdump.php

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, 12 September 2011 07:27 CDT

user19306

I have made some progress, butget an error when loading http://www.sunglassescenter.com/bigdump.php
Does the site backup have to be in JPA or Zip format or some other format?

Monday, 12 September 2011 07:28 CDT

user19306

Sorry I should have say http://www.ray-ban-parts.com/bigdump.php

ie our test site

Monday, 12 September 2011 07:53 CDT

nicholas

BigDump only supports plain text .sql files, which are database dumps. The .zip or .jpa files you are talking about are full site backups, not database-only backups.

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, 12 September 2011 08:57 CDT

user19306

See screen shot attached.Look on right side root
I believe I have done what you suggested, but when I go to http://www.sunglassescenter.com/bigdump.php all I get is a 404 error

Monday, 12 September 2011 09:16 CDT

nicholas

Your site's root is the public_html directory. The one you're showing me on the screenshot is your account root. Site root = where you get the files that your web server serves when you try accessing http://www.sunglassescenter.com. That's the public_html 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!

Support