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

2501

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

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

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