| Author |
 Topic  |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
 Posted - 12 December 2006 : 03:56:38
|
I have access to everything since I run my own server, what I do now is this:
Access via phpmyadmin over the internet, export all data and table structure to a zip-file on my local computer.
What I want to do:
Have some automatic backup system that make a backup of the whole db and then some say put the backup on my computer at home.
I suppose I can do a scheduled mysql-command like "mysqldump --user admin --password=password mydatabase > sql.dump" and then have a scheduled ftp upload to my home computer but there must be a better way? =)
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 12 December 2006 : 03:58:31
|
no, there isn't a better way  |
 |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 12 December 2006 : 04:26:53
|
not the kind of answer I was looking for =)
How do I setup an automatic ftp transfer then and how can I be sure the backup/transfer is completed successfully?
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 12 December 2006 : 04:54:23
|
I do something similar to what you want using MSSQL but it should be possible in MySql also.
Could you set up a shared folder on your local computer, create a windows user & password and grant the user full permissions to the folder (or at least Write permissions).
Setup a backup job in MySql Administrator on your server and specify \\your_ip_address\shared_folder as the backup directory. Supply the windows username & password you created earlier. Does your host supply any hosted backup storage ? It would be better to use it especially if your database is large. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
Edited by - Podge on 12 December 2006 04:55:00 |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 12 December 2006 : 06:37:36
|
Could I have a folder shared/mapped on my server over the internet?
I could put another drive in the server and store the backup there but would rather have it at home where I can store it on CD or something.
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 12 December 2006 : 18:56:43
|
I just have MySQL Administrator on my home workstation do an automatic scheduled backup of my hosted mysql db, the backup file is placed on my local disk. This runs nightly about 3AM, the job is done by the windows task scheduler. The only feature I'd like to see is some way to keep "rollover" backup files, something like linux's logrotate. This assumes the local computer is on and can establish a connection to the remote dbms server.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 12 December 2006 : 18:59:37
|
| it is not a good idea to have file and printer sharing enabled on a machine that is open to the internet, there are some pretty serious security issues involved with using shares/mapped drives |
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 13 December 2006 : 03:20:08
|
quote:
Originally posted by Doug G
I just have MySQL Administrator on my home workstation do an automatic scheduled backup of my hosted mysql db, the backup file is placed on my local disk. This runs nightly about 3AM, the job is done by the windows task scheduler. The only feature I'd like to see is some way to keep "rollover" backup files, something like linux's logrotate. This assumes the local computer is on and can establish a connection to the remote dbms server.
This is more what I'm looking for. Is MySQL Administrator a free software? =)
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
| |
Topic |
|
Topic Locked
