scheduled database backups

[aspage]

I'd like to request a new feature, which makes it easier for us to sell:

Offline database backups.

We have a MySQL server on the internet and we (and our customers) would like to schedule a daily backup of the databases. It shouldn't matter how many databases there are on the server. Just a one click backup procedure.

Also it would be handy if you can choose between the possibilities to backup to .sql script-files or to mysql .frm files etc etc. I found out I cannot backup a database easy with an online MySQL server, using your MySQLYog. So that's why I'm asking this…………. Offline (on localhost) there is no problem to backup the database.

Thank you in advance.

Aspage

[CalEvans]

mysqldump won't do the trick?

=C=

[aspage]

CalEvans wrote on May 13 2004, 09:09 PM:

mysqldump won't do the trick?

=C=

No, because mysqldump has to be done on the server, which contains the source databases. The target server is unknown on the internet, because it is on the internal network of the company.

With MYSQLYOG I can synchronize on any PC on the internal network and still access the internet database-server.

I hope you all understand my above statements………..

[CalEvans]

Sorry, I'm now confused.

mysqldump can be run on any computer that SQLYog can be run on. If it's a windows machine, just write a batch file and stick it in the automated folder (or however that works, never had much use for it myself) This way you can do the dump and automate it.

HTH,

=C=

[aspage]

Yes, but the MySQL server is not on the same server as MYSQLYOG. MYSQLserver is online on the internet and MYSQLYOG is on the internal network.

I can access the MYSQL-server from the internal network (over the internet), but I cannot reach the internal network, from the MYSQL-server. Do you understand what I mean ?

[CalEvans]

mysqldump does not have to be run on the same machine as the server. (check out the –host=name option)

I routinely use it to backup all of my server from a central location. These servers are spread out throughout the Southeast US. Since none of them are available via the Interment directly, I use ssh to create tunnels into machines that can see them. Then mysqldump all of the databases into a file named for the date and server.

Once a week, a script runs that deletes anything that is more than X days old. (I think it's 2 weeks, not sure anymore)

Unless I am misunderstanding your needs, it is entirely possible to simply use mysqldump to do what you are needing to do.

=C=

[aspage]

CalEvans wrote on May 14 2004, 02:02 PM:

mysqldump does not have to be run on the same machine as the server. (check out the –host=name option)

I routinely use it to backup all of my server from a central location. These servers are spread out throughout the Southeast US. Since none of them are available via the Interment directly, I use ssh to create tunnels into machines that can see them. Then mysqldump all of the databases into a file named for the date and server.

Once a week, a script runs that deletes anything that is more than X days old. (I think it's 2 weeks, not sure anymore)

Unless I am misunderstanding your needs, it is entirely possible to simply use mysqldump to do what you are needing to do.

=C=

hahaha, thank you Cal!! It does work. I'm sorry about the misunderstanding. Thank you very much for you patience and explanation. It works perfectly here 😉

Aspage

[CalEvans]

Glad to have been of help.

[androidtech]

Cal,

I take it that if you can't open an SSH tunnel then you can't use MySQLDump?

I want to back up several phpBB forums I run, which are MySQL based. The forums are running on standard non-dedicated host servers that don't allow SSH sessions. I've been using the forum's database backup feature periodically, run manually, but it's tedious as you can imagine.

Thanks.

[CalEvans]

androidtech wrote on May 17 2004, 03:20 PM:

I take it that if you can't open an SSH tunnel then you can't use MySQLDump?

Incorrect.

If you can connect to it with SQLyog then mysqldump running on the same machine will connect.

I run my servers so that they only listen to 127.0.0.1. Therefore, to connect from a remote machine I have to tunnel through. If the server is listening to an external IP address then you should be able to use mysqldump.

=C=

[androidtech]

Cal,

Understood but I still think I'm in the cold. The ISP's that host the forums do not allow outside connections to the MySQL database, only through PHP scripts running locally on the server. Therefore, only processes connecting as 'localhost' or 127.0.0.1.

That's what I was alluding to but did not state properly.

Thanks.

[CalEvans]

Depends on how creative your ISP allows you to be. It's possible to write a php wrapper for mysqldump. Then call it from a webpage. it would take some experimenting but it would be possible.

=C=

[Author]

Posts