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 run an auto backup

Post new topicReply to topic
Author Message
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 09:04    How to run an auto backup Reply with quoteBack to top

Please can you some one help me to understand how to make an auto backup.

Regards,
Umm

OfflineView user's profileSend private message    
Anzeigen











Posted:    Anzeigen Back to top


    
kahuna
uses MSD regulary
uses MSD regulary




Age: 22
Joined: 12 Dec 2006
Posts: 28
Location: Stäfa


switzerland.gif

PostPosted: 2006-12-13, 10:39    (No subject) Reply with quoteBack to top

can you precise "auto backup" a little bit? do you use mysqldump? or do you wanna make an scheduled backup?

greetings

_________________
**The best things in life are free**

Lend your ears to music, open your eyes to painting and...stop thinking! Just ask yourself whether the work has enabled you to 'walk about' into
a hitherto unkown world. If the answer is yes, what more do you want?


Last edited by kahuna on 2006-12-13, 11:55; edited 1 time in total

OfflineView user's profileSend private messageVisit poster's websiteMSN Messenger    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 11:31    (No subject) Reply with quoteBack to top

I us mysqldump and yes your correct I want to make an scheduled backup that runs every day.
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: 2006-12-13, 11:49    (No subject) Reply with quoteBack to top

Make sure you can use Perl by using the Perl-Test included in MySQLDUmper (Backup-Page).
Then install a cronjob to run crondump.pl.

ReadMe included in 1.21b6:

Quote:
Guidance for the Perl script:

When you can execute Perl anywhere:

1. In MySQLDumper switch to the page Backup.
2. Copy the path, that stands behind entry in crondump.pl for $absolute_path_of_configdir:
3. open the file "crondump.pl" in the editor
4. paste the copied path there to the $absolute_path_of_configdir-variable (no blanks,no new line)
5. Save crondump.pl
6. chmod the scripts to 0755.
7. If the ending .cgi is desired, change the ending of all 3 files from .pl to .cgi (rename)
8. If the Scripts are renamed to *.cgi , change Fileextension to cgi in the MySQLDumper Configuration (cronscript)

Done.

--------------------------------------
When perl is only allowed in cgi-bin:

Many user have a cgi-bin directory, in which Perl can be executed.
This is usually available via Browser http://www.domain.com/cgi-bin/ .

In this casse do the following steps:

1. in MySQLDumper call the page Backup and click "Backup Perl".
2. Copy the path, that stands behind entry in crondump.pl for $absolute_path_of_configdir:
3. open the file "crondump.pl" in the editor
4. paste the copied path there with absolute_path_of_configdir (no blanks, no new line)
5. Save crondump.pl
6. copy crondump.pl, as well as perltest.pl and simpletest.pl to the cgi-bin directory (ASCII mode in the ftp-client!)
7. chmod 755 the scripts to 0755.
7b. If the ending cgi is desired, change the ending of all 3 files .pl to .cgi (rename)
8. in MySQLDumper switch to the page Configuration
9. click on Cronscript
10. change the Perl execution path to /cgi-bin/ or ./../cgi-bin (depending on your file-structure. Path is relative from MSD-Dir)
10b. if the Scripts are renamed to *.cgi , change Fileextension to cgi
11 save the Configuration
-------------------------------------

Ready ! The scripts are now available from the Page "Backup".


Windowsuser must change the first line of all Perlscripts, to the path of Perl.

Example:

instead of: #!/usr/bin/perl w
now #!C:\perl\bin\perl.exe w

_________________
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    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 12:08    (No subject) Reply with quoteBack to top

I tested the Test Perl

MySQLDumper - Test Perl
Wenn Du das siehst, funktioniert Perl auf Deinem System !

If you see this, Perl works fine on your system !

---------------------------------

MySQLDumper - Test Perl Modules
Absolutely necessary functions for the Cronscript
test DBI ...
DBI is installed.
available DBI-Driver: DBM
available DBI-Driver: ExampleP
available DBI-Driver: File
available DBI-Driver: Proxy
available DBI-Driver: Sponge
available DBI-Driver: mysql

Database access by DBI is OK.
test File::Find ...
File::Find is installed.
test File::Basename ...
File::Basename is installed.
Configurable functions for the Cronscript
test Compress::Zlib ...
Compress::Zlib is installed.
test Net::FTP ...
Net::FTP is installed.
test MIME::Lite ...
MIME::Lite is installed.

-------------------------------
and it is working, but how to get my auto backup? and if it is working where can I find the files?

OfflineView user's profileSend private message    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 12:39    (No subject) Reply with quoteBack to top

How to install a cronjob?
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: 2006-12-13, 12:58    (No subject) Reply with quoteBack to top

Ask Google. Wink

This belongs to the basics of a webmasters life.
I don't know what kind of webspace you have and what your host offers you.
So look into the FAQ of your hoster.
Your host should describe how a cronjob is made on their server in his faq.

_________________
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    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 20:49    (No subject) Reply with quoteBack to top

Ok I have contacted my hoster and I have crated a cron but I keep getting a small file containing only this character

-- EOB

file name is XXX_2006_12_13_01_53_crondump_perl.sql.gz

XXX stand for my server.

Even though my database is about 8 MB I am attaching a screen shot of my cpanel and I have set it to run every 15 minutes just for testing. any comment or nay help please.



cron.jpg
 Description:
 Filesize:  64.23 KB
 Viewed:  10143 Time(s)

cron.jpg



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: 2006-12-13, 20:52    (No subject) Reply with quoteBack to top

Your settings are OK.

It looks like you are having trouble with the installed version of compress::zlib.
Try to deactivate compressing.
If it then works (I am pretty sure it will) you need to update yor compress::zlib-Module.

_________________
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    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 20:58    (No subject) Reply with quoteBack to top

OK I'm going to give it a try, and then I will give you my feedback as soon as I can. Very Happy

Last edited by umm607 on 2006-12-13, 21:19; edited 1 time in total

OfflineView user's profileSend private message    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-13, 21:08    (No subject) Reply with quoteBack to top

okay this is what I got for setting can you please verify the them for me
because I'm still getting zero data. think in advance for your help.



Image3.jpg
 Description:
 Filesize:  26.66 KB
 Viewed:  10130 Time(s)

Image3.jpg



Image2.jpg
 Description:
 Filesize:  13.67 KB
 Viewed:  10130 Time(s)

Image2.jpg



Image1.jpg
 Description:
 Filesize:  28.22 KB
 Viewed:  10130 Time(s)

Image1.jpg



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: 2006-12-13, 21:51    (No subject) Reply with quoteBack to top

Hm, the settings are ok.

Please post your perl-complete-log.

_________________
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    
DSB
Developer
Developer




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


germany.gif

PostPosted: 2006-12-13, 21:54    (No subject) Reply with quoteBack to top

Ah, wait a moment.
Did you enter the FTP-Data of the same server MySQLDumper is running on?

This option is meant for sending the data to a different server.
When you enter the same server and path of the actual server the backupfile will of course be overwritten!

Of course MySQLDumper first stores the backup on the server it is running on and after that it tries to send the data to another ftp server.

_________________
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    
umm607
uses MSD regulary
uses MSD regulary





Joined: 13 Dec 2006
Posts: 26


blank.gif

PostPosted: 2006-12-14, 05:14    (No subject) Reply with quoteBack to top

Your correct, It worked after i have deactivate compressing under Crondump Settings for Perl script / HelpGZip compression, so how to I update yor compress::zlib-Module?
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: 2006-12-14, 08:58    (No subject) Reply with quoteBack to top

« umm607 » wrote:
so how to I update yor compress::zlib-Module?

Come on.
How should I know that?
I don't know what os you are running and what distribution.
Please ask google.
I cannot configure your whole server.

If you are on suse you can easily install it by searching for compress::zlib.

_________________
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    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Ältere Beiträge und User aus früherem... abelius-kiel Allgemeine Fragen zu MySQLDumper 3 2012-04-22, 10:16 View latest post
No new posts Backup bricht ab Timm85 Fehler / Probleme 2 2012-04-21, 00:20 View latest post
No new posts Backup mit FTP ist leer pelikan1999 Gelöst/Erledigt 9 2012-04-07, 18:05 View latest post
No new posts Backup Error Vengeance66 Errors and questions 4 2012-04-02, 16:52 View latest post
No new posts Scheduling Daily Backup Under Windows vincentwansink Errors and questions 1 2012-03-24, 17:54 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