I have integrated to Joomla! a simple script that allows you to IMPORT and EXPORT databases. Really easy to use. With two clicks you create backup, with another two you restore it.

It EXPORTS and IMPORTS sql files with ANY size.

All files are saved in administrator/backups/ folder and if you want to restore (import a file) your database, the file should also be there.

The component is secured and therefore you need to login when manipulating the data.
Take a look at it and tell me what you think:

Edit 06 June 2007:
New version 2.0 is available. It now works with any host and with any database charset. I also prepared a documentation, so please read it (one page only).

Documentation:
http://joomlacode.org/gf/download/frsre ... tation.pdf
Component download:
http://joomlacode.org/gf/download/frsre ... 2.0%5D.zip

Update from version 1.0: Uninstall the old component and install the new package based on the instructions in the Documentation.

Thanks for using it.

man, that is awesome, just uploaded and currently testing now.. Good job, mate.

Thanks

this seams like something that would be built in to Joomla. is it already there?
maybe just not obviously?

Are there other back up components online?

This Sql dump component ,
- does it or will it have an admin config to set up an automated 3 tier DB backup?
- could I define where to send the back up? local folder or distant server?
- could you define the compression type and level through admin?
- if saving on distant server could the file be encrypted befor sending?

These were my first thoughts when I read your post. Now I'll go install and finout,,

Hmz, don't know if there should be a builtin backup component

There are other backup components (database backup), try on the extension site.

The component
- Could you explain what exacly do you mean?
- No, the backup is saved in the administrator/backup folder. Anyway it can be downloaded directly with the component,, after it is created.
- The compression type is only Gzip currently, you can define compression level.
- Currently not supported.

Hope this helps. This component is not aiming to be THE BEST solution, but it's still one of the most easy and powerful so far.

Another note: I am not the original author of it - as you can see in the extension directory (http://extensions.joomla.org/component/ ... Itemid,35/).
It was written by Sypex, I just modify it a little and integrated it to Joomla! Anyway I can consider and work a bit in the direction of your questions

Ivo

My db are not on localserver, so I can't connect to and I have error message:

#2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Is there a way to connect to db is host server is something like db123.somesite.net?

Basicly yes. But you need to change the code in the dumper.php file - where the localhost is set.

I will try to make the next version with an option to select the host.

Btw. the dumper file is in the Joomla! root after install

tried on local testing server and works fine.
1 question: can we just backup those data that have been modified in the specific date?

No the option is for whole database.

storing of backups in /administrator/backup/ is a VERY bad idea.  All I have to do it guess the filename for the backup and then I can download your whole database including usernames and md5 passwords, along with all your content and any other goodies your database has in it

Secure your backups directory with htaccess or download and remove backups after they are made

I sure like to try your component, but after a succesfull installation, going to the component, a 404 page appears..... any clue? 

Yes, your main joomla directory is without rights

Yep! That did the trick! Thanks! 

I can no see it is an easy, fast, good component which simply does do the trick of backup and restore 

I now am wondering how I can keep my site safe. Can you explain this to a newbe? I'm not sure the rights settings are going to be a problem? Or keeping the backupfiles in the /backups directory?

Please advise...

I didn't write anywhere that this component is backing up the whole site or whatever. It has one goal, which is in its NAME - it dumps any databases, doesn't matter of the size, encoding etc.

when i installed the component and ran it. i get the error:

#2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

after i put in my username and password.

JimeSmythe

The component currently work only if the MySQL host is 'localhost'.

Is your MySQL host 'localhost' or something else?

it is hosted with http://www.omnis.com

Is your database host 'localhost' or not?

Hi all,

Made a simple change in dumper.php file to make it works with a remote DB.
Here is a patch for dumper.php file located in the root directory of Joomla! installation.

Code: Select all

define('DBHOST', 'localhost:3306');

by

Code: Select all

require_once( './configuration.php' );
define('DBHOST', $mosConfig_host);

And sudenly it starts working.

Cheers.

Gillesg

Thank you man, will update the package.

I've installed the component with no errors but when i try to access it i only get a page saying:

We're sorry but the page you requested could not be found.
Return to site

Error 404

I've read about rights on Joomla root dir. I've tryed chmodding 777 with no success.

Any idea? Thx a lot!

During install, the component tries to write in the root directory, if it doesn't success the error appears

I installed the component and as I try to log in, i get the following message:

#2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

What am I doing wrong?

Is your host localhost?

Hi Ivo.

I am successfully installed component and made no compression backup. But I can not find sql file. Where is it stored? 

PS Localhost

administrator/backups

In the process of creating a backup, this error occured. 

A2007.01.03 10:18:53
Возникла ошибка!
fopen(administrator/backups/dumper.cfg.php) [function.fopen]: failed to open stream: Permission denied (2)

it seems that there should be a "dumper.cfg.php" file in that directory, but it doesnt exists

any ideas????

Yes there should be. It seems, that your administrator/backups directory is without write permissions

Thank you
changing write permissions on /backup dir does the trick....

Why does it tell me Error found: 972


Database Backup `dbxxxxxxxxxx` created.
Database size:      xxxxxx Mb
File Size: xxxxxxxx Mb
Tables manipulated: xxxxxx
Error found:  972

Thanks!

Aside from that it was easy install and it seems to work! Good work for BG guy. Mnogo dobre!

Alex