469,106 Members | 2,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

VB app for MySQL backup files

Hi All

Has anybody got any pointers or examples on how I can create a VB app to
connect to a remote MySQL server at a set time and backup a remote db to
local file?

Although a lot of the tools I have seen backup to a text script file, a more
compressed binary version would be better.

Thanks

Laphan


Jul 20 '05 #1
2 2355
Laphan wrote:
Hi All

Has anybody got any pointers or examples on how I can create a VB app to
connect to a remote MySQL server at a set time and backup a remote db to
local file?

Although a lot of the tools I have seen backup to a text script file, a more
compressed binary version would be better.

Thanks

Laphan

I simply use the mysql ODBC driver to create a dump file then compress it.

Read the mysql manual on DUMP.
Jul 20 '05 #2
Hi Peter

The dump file seems to be OK for local dbs, but not remote ones that I want
to dump locally. Do you have an example of how to do this?

Many thanks.

Rgds Laphan
Peter King <pk***@sitedesign.net> wrote in message
news:41**********************@news-text.dial.pipex.com...
Laphan wrote:
Hi All

Has anybody got any pointers or examples on how I can create a VB app to
connect to a remote MySQL server at a set time and backup a remote db to
local file?

Although a lot of the tools I have seen backup to a text script file, a more compressed binary version would be better.

Thanks

Laphan

I simply use the mysql ODBC driver to create a dump file then compress it.

Read the mysql manual on DUMP.
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Neil | last post: by
1 post views Thread by Elaine | last post: by
4 posts views Thread by news | last post: by
6 posts views Thread by frank78 | last post: by
1 post views Thread by PowerLifter1450 | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.