| Author |
Message |
Alcius
first backups

Age: 44
Joined: 14 Mar 2011
Posts: 1

|
Posted:
2011-03-14, 16:01 How to do automatic backups ? |
  |
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,
|
|
  |
 |
Anzeigen
|
Posted:
Anzeigen |
 |
|
| |
 |
DSB
Developer


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

|
Posted:
2011-03-14, 20:06 (No subject) |
  |
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.
_________________ 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.
|
|
    |
 |
ehsan640
first backups

Joined: 04 Jul 2011
Posts: 1

|
Posted:
2011-07-04, 01:04 (No subject) |
  |
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
|
|
  |
 |
Jens_K
Moderator

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

|
Posted:
2011-07-04, 08:40 (No subject) |
  |
|
   |
 |
Lepas
uses MSD regulary

Joined: 27 Aug 2008
Posts: 12

|
Posted:
2011-09-23, 13:10 (No subject) |
  |
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.
|
|
  |
 |
DSB
Developer


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

|
Posted:
2011-09-23, 13:22 (No subject) |
  |
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.
|
|
    |
 |
Lepas
uses MSD regulary

Joined: 27 Aug 2008
Posts: 12

|
Posted:
2011-09-23, 13:32 (No subject) |
  |
Of course it is. You mean the files in /msd_cron/ folder, right?
|
|
  |
 |
DSB
Developer


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

|
Posted:
2011-09-23, 14:52 (No subject) |
  |
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.
|
|
    |
 |
Lepas
uses MSD regulary

Joined: 27 Aug 2008
Posts: 12

|
Posted:
2011-09-23, 16:25 (No subject) |
  |
|
  |
 |
Jens_K
Moderator

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

|
Posted:
2011-09-23, 16:55 (No subject) |
  |
|
   |
 |
Lepas
uses MSD regulary

Joined: 27 Aug 2008
Posts: 12

|
Posted:
2011-09-23, 20:42 (No subject) |
  |
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?
|
|
  |
 |
DSB
Developer


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

|
Posted:
2011-09-23, 20:46 (No subject) |
  |
« 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.
|
|
    |
 |
Lepas
uses MSD regulary

Joined: 27 Aug 2008
Posts: 12

|
Posted:
2011-09-24, 19:35 (No subject) |
  |
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?
|
|
  |
 |
DSB
Developer


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

|
Posted:
2011-09-25, 10:55 (No subject) |
  |
« 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.
|
|
    |
 |
Lepas
uses MSD regulary

Joined: 27 Aug 2008
Posts: 12

|
Posted:
2011-09-27, 11:24 (No subject) |
  |
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?
|
|
  |
 |
|
|