Joomla! Discussion Forums



It is currently Sat Nov 07, 2009 4:21 pm (All times are UTC )

 


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.



Post new topic Reply to topic  [ 15 posts ] 
Author Message
 Post subject: Big Ape Back Up
Posted: Mon Oct 31, 2005 11:25 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Thu Oct 27, 2005 9:46 pm
Posts: 36
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


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Mon Oct 31, 2005 11:48 pm 
User avatar
Joomla! Master
Joomla! Master
Offline

Joined: Fri Aug 12, 2005 12:38 am
Posts: 11158
Location: Sydney - Australia
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 - Follow me on Twitter @xyzulu @rochenhost
http://www.rochen.com - Joomla! Hosting, the correct way.
http://www.joomlatutorials.com <-- Joomla Help
..somewhere in this hospital the anguished oink of a pig man cries out for help..


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Tue Nov 01, 2005 1:47 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 3:36 pm
Posts: 618
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:
#
// $$$ 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

_________________
[ Joomla! StatsCleaner - a free tool to reset ALL Joomla! stats - http://www.nab-design.de/devcorner/ ]


Last edited by Nic on Tue Nov 01, 2005 1:49 am, edited 1 time in total.

Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Thu Dec 29, 2005 1:45 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Thu Dec 29, 2005 1:07 pm
Posts: 2
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


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Tue Jan 31, 2006 12:41 am 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Fri Nov 04, 2005 2:48 pm
Posts: 181
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.

Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Tue Jan 31, 2006 7:49 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

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


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Fri Feb 17, 2006 11:34 pm 
Joomla! Intern
Joomla! Intern
Offline

Joined: Thu Feb 09, 2006 4:26 pm
Posts: 74
Location: Michigan, USA
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.

_________________
I didn't break it I swear!


Top
   
 
 Post subject: Re: Big Ape Back Up
Posted: Sat Feb 18, 2006 12:35 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 3:36 pm
Posts: 618
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/ ]


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Sat Feb 18, 2006 12:49 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 2:46 am
Posts: 777
Location: Washington State, USA
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


Top
   
 
 Post subject: Re: Big Ape Back Up
Posted: Thu Feb 23, 2006 11:37 am 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Thu Feb 23, 2006 11:18 am
Posts: 1
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


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Mon Mar 06, 2006 6:36 pm 
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Wed Jan 18, 2006 8:28 am
Posts: 239
Yeah ... how would you restore the entire site? Are there any step by step procedures?

Scenario:

Quote:
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 ...


Top
   
 
 Post subject: Re: Big Ape Back Up
Posted: Mon Mar 06, 2006 10:49 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Fri Aug 19, 2005 2:46 am
Posts: 777
Location: Washington State, USA
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


Top
   
 
 Post subject: Re: Big Ape Back Up
Posted: Mon Jun 05, 2006 7:43 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 10, 2005 1:46 pm
Posts: 46
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:
#
// $$$ 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?


Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Mon Jun 05, 2006 10:17 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast
Offline

Joined: Fri Nov 04, 2005 2:48 pm
Posts: 181
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.

Top
  E-mail  
 
 Post subject: Re: Big Ape Back Up
Posted: Mon Jun 05, 2006 11:01 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Mon Oct 10, 2005 1:46 pm
Posts: 46
And ya'll rule.

Thanks a million! :-*


Top
  E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 15 posts ] 

Quick reply

 



Who is online

Users browsing this forum: italo and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group