/    Sign up×
Community /Pin to ProfileBookmark

Backing up my database… automatically

Copy linkTweet thisAlerts:
Jul 19.2006

Dear all…

Ok so I’ve just about got the PHP thing under control and the JavaScript (so I can learn Ajax next) is coming along… so the next thing I need to sort out is a bit of backing up of MySQL.

Short of manually backing up my database each evening (hard to do as I am away a lot and the wife does like to see me occasionally) with a dump file via my host’s poor PHPMyAdmin, – or trusting them to do it correctly…

Question:
Is there a script / program / magic bit of hocus-pocus that will automatically back up my database and perhaps mail it to me every 24 hours or so?

Answer: … over to you!

Many thanks

Mouse

to post a comment
PHP

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@cridleyJul 19.2006 — Hi, I use MySQL and it's own database administrator, which can be downloaded (just google it). The program allows you to create and schedule backups. Most other databases also have such programs which allow for this. Hope it helps.
Copy linkTweet thisAlerts:
@Mouse77eauthorJul 19.2006 — Hi, I use MySQL and it's own database administrator, which can be downloaded (just google it). The program allows you to create and schedule backups. Most other databases also have such programs which allow for this. Hope it helps.[/QUOTE]
is this a part of PHPMyAdmin that i've missed?? or somthing else???

Mouse ?
Copy linkTweet thisAlerts:
@steinmagJul 19.2006 — Hi!

Try this:

[URL]http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-administrator-1.1.9-win.msi/from/pick#mirrors[/URL]
×

Success!

Help @Mouse77e spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...