It is currently Sun Jul 20, 2008 10:01 pm

Big Ape Back Up

Discuss the development and implementation of Joomla! components here.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.

Big Ape Back Up

Postby kovox on Mon Oct 31, 2005 11:25 pm

Hello

Big Ape backs up my database nicely

However when I attempt to restore my database either with phpadmin or directadmin, I get this error:

Unable to restore database cougar_spjoomla : ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSTALL elect default language and much more. Note that additio gunzip: stdout: Broken pipe

I'm on hostpc

Any ideas?

Thanks
kovox
Joomla! Apprentice
Joomla! Apprentice
 
Posts: 37
Joined: Thu Oct 27, 2005 9:46 pm

Re: Big Ape Back Up

Postby brad on Mon Oct 31, 2005 11:48 pm

You will need to backup your database with the --quote-names option.

Newer versions of Mysql require backquotes around some fields. I am not sure if Big Ape suports backups using backquotes.
Brad Baker - Joomla! Core Team, Sites & Infrastructure.

http://www.rochen.com - Managed Dedicated, Reseller & Multiple Domain Hosting.
http://www.joomlatutorials.com <-- Joomla! 1.5 & 1.0.x
User avatar
brad
Joomla! Exemplar
Joomla! Exemplar
 
Posts: 9376
Joined: Fri Aug 12, 2005 12:38 am
Location: Sydney - Australia

Re: Big Ape Back Up

Postby Nic on Tue Nov 01, 2005 1:47 am

I think you are suffering from an old bug of BigApe Site Backup which has been reported ages ago but not yet fixed. Does your .sql file contain comments that start with "//" instead of "#"? Like this:

Code: Select all
#
// $$$ Open Source MySQL-Dump
// http://www.$$$.com
#
// Host: Somehost
// Generation Time: Apr 20, 2005 at 14:43
// Server version: 4.1.8a-Debian_5.dotdeb.0-log
// PHP Version: 5.0.3
// Database : `db1001-cms`
// --------------------------------------------------------
#
// Table structure for table `mos_banner`
#
DROP table IF EXISTS mos_banner;
CREATE TABLE `mos_banner` (
...


Fix of the bug:

Open the file "administrator/components/com_babackup/admin.babackup.php". The problem is starting at line 557 to 572 and 618.
Replace all double '//' with a '#'. But do not replace the // near the end of 561, that is date time formatting. Now the backups should be fine.

Fix of your backup:

If you need the current backup to work do a very careful search/replace of all "//" to "#" but be sure to check every single find of "//" because it could also be part of your content (f.ex. "http://www....")

Hope this helps.

Nic
Last edited by Nic on Tue Nov 01, 2005 1:49 am, edited 1 time in total.
[ Joomla! StatsCleaner - a free tool to reset ALL Joomla! stats - http://www.nab-design.de/devcorner/ ]
User avatar
Nic
Joomla! Guru
Joomla! Guru
 
Posts: 618
Joined: Fri Aug 19, 2005 3:36 pm

Re: Big Ape Back Up

Postby clipper on Thu Dec 29, 2005 1:45 pm

Dear all, I have this ERROR, please help me to find solution, I use a Linux server... What can I do ???

Warning: generatebackup(/home/pnud/www/includes/Archive/Tar.php): failed to open stream: No such file or directory in /home/pnud/www/administrator/components/com_babackup/admin.babackup.php on line 149

Fatal error: generatebackup(): Failed opening required '/home/pnuda/www/includes/Archive/Tar.php' (include_path='.:/usr/local/lib/php') in /home/pnuda/www/administrator/components/com_babackup/admin.babackup.php on line 149
clipper
Joomla! Fledgling
Joomla! Fledgling
 
Posts: 2
Joined: Thu Dec 29, 2005 1:07 pm

Re: Big Ape Back Up

Postby webcentred on Tue Jan 31, 2006 12:41 am

my suggestion would be simply modify the version of babackup as described above, and reinstall this modified version. Have you tried checking the location and permissions with FTP?

If you are unable to install automatically without receiving this response it may be because safe mode is on, - see this thread for manual installation:

http://forum.joomla.org/index.php/topic,25017.0.html
Last edited by webcentred on Mon Jun 05, 2006 10:13 pm, edited 1 time in total.
~ all's fair in open source ~
User avatar
webcentred
Joomla! Enthusiast
Joomla! Enthusiast
 
Posts: 177
Joined: Fri Nov 04, 2005 2:48 pm

Re: Big Ape Back Up

Postby clipper on Tue Jan 31, 2006 7:49 am

Thank you, your help was very important for me, now I can backup my website
clipper
Joomla! Fledgling
Joomla! Fledgling
 
Posts: 2
Joined: Thu Dec 29, 2005 1:07 pm

Re: Big Ape Back Up

Postby bobonthenet on Fri Feb 17, 2006 11:34 pm

Just a few quick and easy questions, I am using the latest Joomla is Big Ape going to work ok with that?  Also I downloaded com_babackup_1.0.zip will I need to perform these fixes on that?  I've now had to completely wipe everything clean and reinstall from scratch twice and I don't want to make it a third time.  Lastly what all does big ape backup?  Just the mysql database or all the files and component stuff?  I would really like something that backs up everything but anything that will prevent me from having to reinstall joomla and all the components from scratch and losing all my members and all the data is better than nothing.
Signature rules: http://forum.joomla.org/index.php/topic,65.0.html
Affiliate links not allowed.
bobonthenet
Joomla! Intern
Joomla! Intern
 
Posts: 67
Joined: Thu Feb 09, 2006 4:26 pm
Location: Michigan, USA

Re: Big Ape Back Up

Postby Nic on Sat Feb 18, 2006 12:35 am

bobonthenet wrote:Just a few quick and easy questions, I am using the latest Joomla is Big Ape going to work ok with that?  Also I downloaded com_babackup_1.0.zip will I need to perform these fixes on that?  I've now had to completely wipe everything clean and reinstall from scratch twice and I don't want to make it a third time.  Lastly what all does big ape backup?  Just the mysql database or all the files and component stuff?  I would really like something that backs up everything but anything that will prevent me from having to reinstall joomla and all the components from scratch and losing all my members and all the data is better than nothing.


First I'd recommend you get the v1.1 version of BigApe Backup. Strangly enough it is not available from the bigape website (they still have 1.0) but they only released it here: http://mamboforge.net/projects/bigapebackup/. As the old forge is down at the moment I took the liberty and attached that version to this post.

Yes, you will have to apply the above posted fixes to the v1.0 and 1.1 version. As I said it has not been fixed. To be precise, there has not been a new BigApe version for almost a year now. Nontheless I think it should work with Joomla 1.0.7.

It will backup your database AND all of your files and put both into two separate zip files on your server. There is also an option to email those files to you but it is still beta and I never could get it to work (never tried very hard though as getting the files via ftp is much much faster).

BigApe backup does NOT have a restore feature! So if you need to restore a db backup you'd have to do it with phpmyadmin and files of course via ftp.

Hope this helps.

Nic
You do not have the required permissions to view the files attached to this post.
[ Joomla! StatsCleaner - a free tool to reset ALL Joomla! stats - http://www.nab-design.de/devcorner/ ]
User avatar
Nic
Joomla! Guru
Joomla! Guru
 
Posts: 618
Joined: Fri Aug 19, 2005 3:36 pm

Re: Big Ape Back Up

Postby focalguy on Sat Feb 18, 2006 12:49 am

Big Ape will backup everything in your site. All files and the database. If you have cPanel, you may also want to look at the cron backup script for Joomla. It's on the forge.joomla.org site somewhere.

--Nic got to it before me-- 8)
New to Joomla? :) Make sure2 visit:
\_Anna's Joomla Tips - index.php/topic,5503.0.html
User avatar
focalguy
Joomla! Guru
Joomla! Guru
 
Posts: 905
Joined: Fri Aug 19, 2005 2:46 am
Location: Washington State, USA

Re: Big Ape Back Up

Postby jgarnier on Thu Feb 23, 2006 11:37 am

Thank you for the tips for the news MySQL,

I still have a problem when I'm trying to import datas, my MySQL needs the table fields, and the module didn't add it.

babackup produces that :
INSERT INTO mos_simple_quote VALUES (1,'BoostEdge','Mr. Francois',true,true);

And my base needs that :

INSERT INTO `mos_simple_quote` (`qid`, `quote`, `author`, `showInMambot`, `showInModule`) VALUES (1, 'BoostEdge', 'Mr. Francois', 'true', 'true');

Does somebody already add a line or a loop to add that ?

Thanks a lot
Jean
jgarnier
Joomla! Fledgling
Joomla! Fledgling
 
Posts: 1
Joined: Thu Feb 23, 2006 11:18 am

Re: Big Ape Back Up

Postby nucleus on Mon Mar 06, 2006 6:36 pm

Yeah ... how would you restore the entire site? Are there any step by step procedures?

Scenario:

Would you upload the backup onto the server. Unpack it.
Then upload the sql db using phpmyadmin


And then what? Would it totally restore EVERYTHING including all the users, permissions, installed modules & components, module positions etc ...
nucleus
Joomla! Enthusiast
Joomla! Enthusiast
 
Posts: 240
Joined: Wed Jan 18, 2006 8:28 am

Re: Big Ape Back Up

Postby focalguy on Mon Mar 06, 2006 10:49 pm

http://forum.joomla.org/index.php/topic,5703.0.html
This FAQ is about moving your site from one server to another. It outlines the same steps you would need to recover a site.
New to Joomla? :) Make sure2 visit:
\_Anna's Joomla Tips - index.php/topic,5503.0.html
User avatar
focalguy
Joomla! Guru
Joomla! Guru
 
Posts: 905
Joined: Fri Aug 19, 2005 2:46 am
Location: Washington State, USA

Re: Big Ape Back Up

Postby delrica on Mon Jun 05, 2006 7:43 pm

Nic wrote:I think you are suffering from an old bug of BigApe Site Backup which has been reported ages ago but not yet fixed. Does your .sql file contain comments that start with "//" instead of "#"? Like this:

Code: Select all
#
// $$$ Open Source MySQL-Dump
// http://www.$$$.com
#
// Host: Somehost
// Generation Time: Apr 20, 2005 at 14:43
// Server version: 4.1.8a-Debian_5.dotdeb.0-log
// PHP Version: 5.0.3
// Database : `db1001-cms`
// --------------------------------------------------------
#
// Table structure for table `mos_banner`
#
DROP table IF EXISTS mos_banner;
CREATE TABLE `mos_banner` (
...


Fix of the bug:

Open the file "administrator/components/com_babackup/admin.babackup.php". The problem is starting at line 557 to 572 and 618.
Replace all double '//' with a '#'. But do not replace the // near the end of 561, that is date time formatting. Now the backups should be fine.

Fix of your backup:

If you need the current backup to work do a very careful search/replace of all "//" to "#" but be sure to check every single find of "//" because it could also be part of your content (f.ex. "http://www....")

Hope this helps.

Nic


Under fix of your backup, where you say to "be sure to check every single find of "//", do you mean throughout the whole document or just lines 557-572?
delrica
Joomla! Apprentice
Joomla! Apprentice
 
Posts: 47
Joined: Mon Oct 10, 2005 1:46 pm

Re: Big Ape Back Up

Postby webcentred on Mon Jun 05, 2006 10:17 pm

the find/replace "//"  for "#", (then subsequent find replace for "http:#" to "http://" for example) is for your MySQL Dump, not for your BigApe code.

The code fix is for those lines mentioned in BABackup and when you look for this you will see this is straightforward. This fix works flawlessly from my experience.
Last edited by webcentred on Mon Jun 05, 2006 10:23 pm, edited 1 time in total.
~ all's fair in open source ~
User avatar
webcentred
Joomla! Enthusiast
Joomla! Enthusiast
 
Posts: 177
Joined: Fri Nov 04, 2005 2:48 pm

Re: Big Ape Back Up

Postby delrica on Mon Jun 05, 2006 11:01 pm

And ya'll rule.

Thanks a million! :-*
delrica
Joomla! Apprentice
Joomla! Apprentice
 
Posts: 47
Joined: Mon Oct 10, 2005 1:46 pm


Return to Components

Who is online

Users browsing this forum: No registered users and 4 guests