MySQLDumper-Board Forum Index Follow me on Twitter

Portal  •   Forum  •  Downloads  •  Profile  •  Search   •  Register  •  Log in to check your private messages  •  Log in  •  


 How to do automatic backups ?

Post new topicReply to topic
Author Message
Alcius
first backups
first backups




Age: 44
Joined: 14 Mar 2011
Posts: 1


france.gif

PostPosted: 2011-03-14, 16:01    How to do automatic backups ? Reply with quoteBack to top

Hello everyone,

Already sorry for my English ...

I want to know how to do with MySQLDumper to automate a backup of my MySQL database??

Thank you for your answers,

OfflineView user's profileSend private message    
Anzeigen











Posted:    Anzeigen Back to top


    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16070
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2011-03-14, 20:06    (No subject) Reply with quoteBack to top

Hi Alcius,

here is a short description:

1. CHMOD all files in the folder msd_cron to 0755

2. Check the Perl tests in the gui -> backup / backup Perl / Test Perl
The output should be:
Quote:
If you see this perl works fine on your system !

Wenn Du das siehst, funktioniert Perl auf Deinem System !


3. Test if all needed Perl Modules are installed -> backup / backup Perl / Perl test
Output should be similar to this:
Quote:
Testing needed Perl-Moduls in order to run the Perl script crondump.pl
Necessary Modules for crondump.pl
testing DBI ... Found modul DBI. OK.
Found modul DBI::CSV
Found modul DBI::DBM
Found modul DBI::ExampleP
Found modul DBI::File
Found modul DBI::Gofer
Found modul DBI::ODBC
Found modul DBI::Oracle
Found modul DBI::Proxy
Found modul DBI::SQLite
Found modul DBI::Sponge
Found modul DBI::mysql
Found modul DBI::mysql. OK. crondump.pl can connect to MySQL-Database.

testing File::Find ... Found modul File::Find. OK.
testing File::Basename ... Found modul File::Basename. OK.
testing Getop... Found modul Getopt. OK. crondump.pl can read configfile-parameter from shell.

Configurable functions for crondump.pl (these moduls are only needed when explained option is turned on):
testing Compress::Zlib (needed for dumping data into a crompessed *.gz-file)...
Found modul Compress::Zlib ver 2.023. OK. crondump.pl can write compressed backups.

testing Net::FTP (needed if you want to transfer backups to another server)...
Found modul Net::FTP. OK - crondump.pl can send backups via FTP.

testing Net::FTPSSL (needed if you want to transfer backups to another server with ssl encryption)...
Error: modul Net::FTPSSL not found! crondump.pl can't transfer data via FTP with ssl encryption.

testing MIME::Lite (needed if you want to send backups via email)...
Found modul MIME::Lite. OK. crondump.pl can send emails.



Post your output of the 3rd step and we will continue this tour. Wink

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
ehsan640
first backups
first backups





Joined: 04 Jul 2011
Posts: 1


blank.gif

PostPosted: 2011-07-04, 01:04    (No subject) Reply with quoteBack to top

hi dear DSB
i want learn about creating a cronjob for automatic backup using MSD

here is the output of 3rd step on my host :

Testing needed Perl-Moduls in order to run the Perl script crondump.pl
Necessary Modules for crondump.pl
testing DBI ... Found modul DBI. OK.
Found modul DBI::AnyData
Found modul DBI::CSV
Found modul DBI::DBM
Found modul DBI::ExampleP
Found modul DBI::File
Found modul DBI::Gofer
Found modul DBI::Proxy
Found modul DBI::SQLite
Found modul DBI::SQLite2
Found modul DBI::Sponge
Found modul DBI::mysql
Found modul DBI::mysql. OK. crondump.pl can connect to MySQL-Database.

testing File::Find ... Found modul File::Find. OK.
testing File::Basename ... Found modul File::Basename. OK.
testing Getop... Found modul Getopt. OK. crondump.pl can read configfile-parameter from shell.
Configurable functions for crondump.pl (these moduls are only needed when explained option is turned on):
testing Compress::Zlib (needed for dumping data into a crompessed *.gz-file)...
Found modul Compress::Zlib ver 2.037. OK. crondump.pl can write compressed backups.

testing Net::FTP (needed if you want to transfer backups to another server)...
Found modul Net::FTP. OK - crondump.pl can send backups via FTP.

testing Net::FTPSSL (needed if you want to transfer backups to another server with ssl encryption)...
Found modul Net::FTPSSL. OK - crondump.pl can send backups via FTP with ssl encryption.

testing MIME::Lite (needed if you want to send backups via email)...
Found modul MIME::Lite. OK. crondump.pl can send emails.



please tell me next steps ....
thank you very much

OfflineView user's profileSend private message    
Jens_K
Moderator
Moderator




Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld


germany.gif

PostPosted: 2011-07-04, 08:40    (No subject) Reply with quoteBack to top

Look at the bottom of the MySQLDumper backup page when you click on "Perl Backup".
Everything you need to create a cronjob is listed there.

_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog

OfflineView user's profileSend private messageVisit poster's website    
Lepas
uses MSD regulary
uses MSD regulary





Joined: 27 Aug 2008
Posts: 12


blank.gif

PostPosted: 2011-09-23, 13:10    (No subject) Reply with quoteBack to top

What happens if I get an internal sever error when trying to check Perl? This is the error message:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@mysite.es and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


The point is all went fine until trying PERL. Can anyone throw a wire here? In the meantime, I'll write the hosting support. Thanks in advance for your time and attention.

OfflineView user's profileSend private message    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16070
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2011-09-23, 13:22    (No subject) Reply with quoteBack to top

CHMOD 0755 for the perl files is given?
_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Lepas
uses MSD regulary
uses MSD regulary





Joined: 27 Aug 2008
Posts: 12


blank.gif

PostPosted: 2011-09-23, 13:32    (No subject) Reply with quoteBack to top

Of course it is. You mean the files in /msd_cron/ folder, right?
OfflineView user's profileSend private message    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16070
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2011-09-23, 14:52    (No subject) Reply with quoteBack to top

Yes. Does the msd_cron folder tself also have 0755?
_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Lepas
uses MSD regulary
uses MSD regulary





Joined: 27 Aug 2008
Posts: 12


blank.gif

PostPosted: 2011-09-23, 16:25    (No subject) Reply with quoteBack to top

Yes, it has.
OfflineView user's profileSend private message    
Jens_K
Moderator
Moderator




Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld


germany.gif

PostPosted: 2011-09-23, 16:55    (No subject) Reply with quoteBack to top

Are you allowed to execute CGI scripts from directories other than /cgi-bin?
_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog

OfflineView user's profileSend private messageVisit poster's website    
Lepas
uses MSD regulary
uses MSD regulary





Joined: 27 Aug 2008
Posts: 12


blank.gif

PostPosted: 2011-09-23, 20:42    (No subject) Reply with quoteBack to top

Exactly, that's the reason the support have given to me. So, should I move all the folder to "/cgi-bin" and that's it? Or should I do a new install?
OfflineView user's profileSend private message    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16070
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2011-09-23, 20:46    (No subject) Reply with quoteBack to top

« Lepas » wrote:
should I move all the folder to "/cgi-bin" and that's it?

Yes. Move all the *.pl files from the msd_cron folder to cgi-bin and adjust the "Path of Perl scripts" in the configuration of MySQLDumper.
This way you can start the scripts in this folder from within the gui.

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Lepas
uses MSD regulary
uses MSD regulary





Joined: 27 Aug 2008
Posts: 12


blank.gif

PostPosted: 2011-09-24, 19:35    (No subject) Reply with quoteBack to top

Well, maybe there's something I didn't understood. I moved all files in /msd_cron to /cgi-bin, and then set the permissions of these files to 0755. And finally I entered Cronscript tab of config and changed /msd_cron to ./../cgi-bin <- Did you meant this?

I'm still getting the same 404 error and I don't know if MSD PERL test should be running properly once files are in cgi-bin. As you see, I'm messed up here, so detailed instructions would be so appreciated.

Thanks in advance for your time and attention.

P.D. -> I've also seen a line in crondump:
my $cgibin_path=""; # this is needed for MIME::Lite if it is in cgi-bin

Should I do something with it?

OfflineView user's profileSend private message    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16070
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2011-09-25, 10:55    (No subject) Reply with quoteBack to top

« Lepas » wrote:
Well, maybe there's something I didn't understood. I moved all files in /msd_cron to /cgi-bin, and then set the permissions of these files to 0755. And finally I entered Cronscript tab of config and changed /msd_cron to ./../cgi-bin <- Did you meant this?

Yes, that should do the trick. If it doesn't, maybe you do have another cgi-bin folder and moved the files to the wrong one?
Sometimes you need to rename the extension of the perl files from *.pl to *.cgi. It depends on the configuration of your web server.

Quote:
I'm still getting the same 404 error and I don't know if MSD PERL test should be running properly once files are in cgi-bin.

Of course. That's why I wanted you to adjust the path to the perl scripts.

Quote:
I've also seen a line in crondump:
my $cgibin_path=""; # this is needed for MIME::Lite if it is in cgi-bin

Should I do something with it?

No.

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Lepas
uses MSD regulary
uses MSD regulary





Joined: 27 Aug 2008
Posts: 12


blank.gif

PostPosted: 2011-09-27, 11:24    (No subject) Reply with quoteBack to top

I tried choosing *.cgi in config and renaming the files, and it still shows 404 error. The funny thing is that if I remove the files from /cgi-bin then it says they cannot find test.cgi and when the files are deployed it doesn't show that message but the internal server error instead.

Now, the server support ask me the URL I'm trying in my browser. Should I ask them for something specific? Maybe to point the command that MSD uses to try to run test.cgi?

OfflineView user's profileSend private message    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Löschungs alter Backups auf FTP Hangasilly Feature Requests 0 2012-05-17, 19:33 View latest post
No new posts Endlosschleife beim Wiederherstellen ... DSB Allgemeine Fragen zu MySQLDumper 2 2012-03-30, 11:12 View latest post
No new posts Automatische Backups? Wie geht das? menzel-webmarketing Allgemeine Fragen zu MySQLDumper 5 2011-11-15, 15:23 View latest post
No new posts Umleitung auf Startseite nach start d... michaeljell Gelöst/Erledigt 1 2011-07-25, 17:52 View latest post
No new posts Backups now reading 0 (zero) JNMann Errors and questions 5 2011-06-15, 22:22 View latest post

 
CrackerTracker © 2004 - 2012 CBACK.de

Powered by Orion based on phpBB © 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours

phpBB SEO