4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Backup
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Kdawg
Senior WebHelper
Senior WebHelper


Joined: 21 Apr 2003
Posts: 153

PostPosted: Fri Apr 25, 2003 9:11 pm (14 years, 6 months ago) Reply with QuoteBack to Top

Does anyone have a good MySQL backup program?
OfflineView User's ProfileFind all posts by KdawgSend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Sat Apr 26, 2003 7:31 am (14 years, 6 months ago) Reply with QuoteBack to Top

This is what we use at 4WebHelp, in our cron file:

Code:
0 0 * * 1 /usr/local/psa/mysql/bin/mysqldump -uUSERNAME -pPASSWORD DATABASE_NAME |gzip |uuencode database_backup.sql.gz |mail EMAIL_ADDRESS -f"4WebHelp Database Backup"


But that will email it to you... I'll see if I can dig up the code to save it somewhere on the server, if you need it? Question

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
norm
Junior WebHelper
Junior WebHelper


Joined: 17 Feb 2003
Posts: 20
Location: Oxford, U.K.

PostPosted: Sat Apr 26, 2003 10:43 am (14 years, 6 months ago) Reply with QuoteBack to Top

Hi,

Either that or you can use phpMyBackup. Goto http://www.phpmybackup.com/.

phpMyBackup can be used from the web or for cron jobs and scheduled backups of complete db's, tables etc. It can gzip up the backup. It can also ftp a backup of database to a specific ftp server.

Hope that helps...

Cheers, Norm Very Happy
OfflineView User's ProfileFind all posts by normSend Personal MessageVisit Poster's WebsiteMSN MessengerICQ Number
Kdawg
Senior WebHelper
Senior WebHelper


Joined: 21 Apr 2003
Posts: 153

PostPosted: Wed May 07, 2003 4:44 pm (14 years, 5 months ago) Reply with QuoteBack to Top

How would I put that code in here to email me a backup once a week?
Image
OfflineView User's ProfileFind all posts by KdawgSend Personal Message
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Wed May 07, 2003 4:49 pm (14 years, 5 months ago) Reply with QuoteBack to Top

0 in the first box, 0 in the second, * in the next two, 1 in the fifth. Put the rest in the command box. This will email you in the night, between Sunday and Monday.

Code:
0 0 * * 1 /usr/local/psa/mysql/bin/mysqldump -uUSERNAME -pPASSWORD DATABASE_NAME |gzip |uuencode database_backup.sql.gz |mail EMAIL_ADDRESS -f"Database Backup"

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
adam
Forum Moderator & Developer



Joined: 26 Jul 2002
Posts: 704
Location: UK

PostPosted: Wed May 07, 2003 4:51 pm (14 years, 5 months ago) Reply with QuoteBack to Top

assuming the server uses plesk...

________________________________
It's turtles all the way down...
OfflineView User's ProfileFind all posts by adamSend Personal MessageVisit Poster's Website
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Wed May 07, 2003 4:55 pm (14 years, 5 months ago) Reply with QuoteBack to Top

Oops... Of course it won't, since that was a CPanel screenshot. You'll have to replace "/usr/local/psa/mysql/bin/mysqldump" with the appropriate command for your OS.

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Kdawg
Senior WebHelper
Senior WebHelper


Joined: 21 Apr 2003
Posts: 153

PostPosted: Wed May 07, 2003 8:19 pm (14 years, 5 months ago) Reply with QuoteBack to Top

how do I know the command? I know the servers running on RedHat Linux 8.0.
OfflineView User's ProfileFind all posts by KdawgSend Personal Message
adam
Forum Moderator & Developer



Joined: 26 Jul 2002
Posts: 704
Location: UK

PostPosted: Thu May 08, 2003 3:50 pm (14 years, 5 months ago) Reply with QuoteBack to Top

I can't seem to find anything in cpanel that would tell you, try running the following script:
Code:
<?php
header('Content-type: text/plain');
print system('locate mysqldump');
?>

it should be in there somewhere Wink

________________________________
It's turtles all the way down...
OfflineView User's ProfileFind all posts by adamSend Personal MessageVisit Poster's Website
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.056173 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme