Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Web Design & Development Web Design & Development
Search Search
Search for:
Tech Support Guy > > >

Solved: MySQL DB Backup


(!)

JiminSA's Avatar
JiminSA   (Jim) JiminSA is online now JiminSA has a Profile Picture
Computer Specs
Member with 1,552 posts.
THREAD STARTER
 
Join Date: Dec 2011
Location: Johannesburg South Africa
Experience: Intermediate
02-Aug-2012, 10:18 AM #1
Solved: MySQL DB Backup
I would like to write a routine which will backup specific tables from a MySQL database and download it to my hard drive. However, if anyone knows of a reliable script that is already in existence, why re-invent the wheel, I'd love to use it
dukevyner's Avatar
dukevyner   (Luke) dukevyner is offline
Computer Specs
Member with 787 posts.
 
Join Date: Nov 2011
Location: Pakenham, VIC, Australia
Experience: Advanced
03-Aug-2012, 01:53 AM #2
Quote:
Originally Posted by JiminSA View Post
I would like to write a routine which will backup specific tables from a MySQL database and download it to my hard drive. However, if anyone knows of a reliable script that is already in existence, why re-invent the wheel, I'd love to use it
I've been trying to find something like this for ever... I never seem to find one that's works, though there is a program that does(you have to pay for automatic) will keep an eye on this thread
colinsp's Avatar
colinsp   (Colin) colinsp is offline
Computer Specs
Member with 1,607 posts.
 
Join Date: Sep 2007
Location: Spain
03-Aug-2012, 02:02 AM #3
Have a look at mysqldumper It only does whole databases but you can cron job it to run automatically and email you the file. Almost what you want.
JiminSA's Avatar
JiminSA   (Jim) JiminSA is online now JiminSA has a Profile Picture
Computer Specs
Member with 1,552 posts.
THREAD STARTER
 
Join Date: Dec 2011
Location: Johannesburg South Africa
Experience: Intermediate
03-Aug-2012, 05:23 AM #4
Lovely suggestion Colin I had already found it via Google and SourceForge.net. It says it is web-based does this mean that if I upload it to my server, it could be executed from a link in my php? I would like to do exactly that, but I gather that the process is not that simple
Can anyone give me an insight as to how I might achieve this, please?
colinsp's Avatar
colinsp   (Colin) colinsp is offline
Computer Specs
Member with 1,607 posts.
 
Join Date: Sep 2007
Location: Spain
03-Aug-2012, 07:14 AM #5
Jim
I have it in it's own sub domain and call it via url. Once a week I have a cron job that runs backs up all my db's. I leave them on the server with just an email to confirm that it has been done. As long as you hosting allows cron jobs it can be set up relatively easily, I managed to do it and am no nix expert. I just used Google and the mysqldumper documentation and support forum.
JiminSA's Avatar
JiminSA   (Jim) JiminSA is online now JiminSA has a Profile Picture
Computer Specs
Member with 1,552 posts.
THREAD STARTER
 
Join Date: Dec 2011
Location: Johannesburg South Africa
Experience: Intermediate
03-Aug-2012, 07:19 AM #6
Terrific - thanks Colin I'll give it a go!
JiminSA's Avatar
JiminSA   (Jim) JiminSA is online now JiminSA has a Profile Picture
Computer Specs
Member with 1,552 posts.
THREAD STARTER
 
Join Date: Dec 2011
Location: Johannesburg South Africa
Experience: Intermediate
04-Aug-2012, 12:19 PM #7
Well now! My good friend Thruska (BarebonesCMS and a member here) has provided me with an excellent alternative which I shall follow up on...
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑