VB app for MySQL backup files

Laphan

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

Subscribe Post Reply

2502

Peter King

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

Laphan

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

Similar topics

mysql backup help please

by: Neil | last post by:

Hi, I hope this question isn't too far off topic....I'm almost at my wits end trying to figure this out. I have a Mysql database and I wish to automate the backup of the database because I...

PHP

how to change the default charset with GBK or other language of mysql ??

by: Ka | last post by:

I install a mysql server in default installation with latin charset, but I want to use GBK(a chinese charset), so that I can store and search chinese words directly. so, I download, unpack and...

MySQL Database

I need a easy graphical backup utility for mysql

by: John Smith | last post by:

Hi I am currently reviewing our backup procedures. Part of the issue has been finding the right fit. There are obviously backup products that provide mysql agents but unfortunately can not for...

MySQL Database

How to create my own VB backup program for a remote MySQL DB

by: Astra | last post by:

Hi All I understand that the basic principles to create a TCP/IP backup program for a remote MySQL DB are: a) Query/retrieve the schema. b) Query/retrieve each table and create inserts...

MySQL Database

mysql backup query

by: Elaine | last post by:

hi Hopefully this is simple enough. I'm running 3.23 and 4.1.7 mysql databases. I run a /usr/bin/mysqlhotcopy backup on a specific database name , and copy my.cnf and ib* files to the backup...

MySQL Database

mySQL import text file too big?

by: news | last post by:

Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as...

MySQL Database

MYSQL table backups

by: frank78 | last post by:

Hi everyone, I am having a little bit of trouble backing up some mySQL tables. I've been trying to adapt a script I found on the internet at...

PHP

mysql Install Problems

by: PowerLifter1450 | last post by:

I've been having a very rough time installinig mySQL on Linux. I have been following the instructions form here: http://www.hostlibrary.com/installing_apache_mysql_php_on_linux Everytime I get to...

MySQL Database

110

MyISAM engine: worst case scenario in case of crash (mysql, O/S,hardware, whatever)

by: alf | last post by:

Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...

MySQL Database

BackUp Tables from MySql in ASP

by: Michael | last post by:

Happy new year. I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files. Thanks

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA