Joomla! Discussion Forums

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

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.

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:



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

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

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

Thank you, your help was very important for me, now I can backup my website

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

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--

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

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

Scenario:



And then what? Would it totally restore EVERYTHING including all the users, permissions, installed modules & components, module positions etc ...

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.

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?

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.

And ya'll rule.

Thanks a million!