You could try something like myAccess ($35, see
http://www.hiden.org/myaccess/ ) which is an addin for Access that allows
you to open and work, live, with online mySQL DBs from your local PC. There
are other programs/addins that work in a similar way. Some are free.
I have an automated backup system that I wrote for my mySQL databases which
are on a *nix host. It has a php front end for checking and editing the
backup schedule, and uses cron to control when they run. It uses the
mysqldump command that dumps a db to an sql script to produce a backup file,
then saves a copy locally and/or emails a copy to a specified email address.
You can then run that sql script at any time to recreate the database if
required. But this may be more complex than you need or can support, or
your db may be on a Windows host, or too big (these db's have no more than a
few hundred records, yours sounds large!)
----- Original Message -----
From: "Diane Schips" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, January 02, 2006 3:50 PM
Subject: Re: [wdvltalk] Problem disabling the submit button
I hope everyone's New Year is off to a good start!
I need to provide a backup solution for a customer for his website's SQL
database. He says his people can't handle using ftp to download the files
to the desktop. Not that FTP would help for an SQL database, but this
gives you an idea of the situation.
I wrote a VB application that uses inet to connect to the SQL database,
and copies the data one record at a time to Access databases on the
desktop (after first emptying them). This works fine except some records
seems to have funky data that causes errors, and the files take forever to
download. My customer wants to do a daily download, but it looks like it
will take most of a day to do the download! The tables are pretty big!
I s this the best way to do this? My customer would prefer a webpage that
does the download, but I've never tried to copy anything to a customer's
computer from the web, and wouldn't this still require copying the records
into an Access database, this time on the server?
Thanks,
Diane
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To:
mailto:[EMAIL PROTECTED] or
use the web interface
http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
