: I am now thinking about using MySQL as my main office DB. Is
: it going to be
: easy te retrieve dta if there is crash or worse case senario
: my OS dies? I
: guess this is a back up question really?
Try to backup your DB as often. "mysqldump" utility is mostly for that.
I am now thinking about using MySQL as my main office DB. Is it going to be
easy te retrieve dta if there is crash or worse case senario my OS dies? I
guess this is a back up question really?
Thank you all.
Andrew
PS although this is slow it is brilliant. Is there a PHP equivalent.
Hello (sql,query)
I recently moved from mysql4.0.3 to mysql4.0.8gamma
I did a copy of my databases inside the *data* directory alone(i.e. *.frm*
files)
All the tables are InnoDb tables
Now I copied all those files to my new MYSQL_HOME\DATA directory
But when I try to
gt; From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 22, 2001 1:49 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Backup Data
>
>
> Thanks for your reply. What about replication ? I've looked at this, but
> everyone says read the
t; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, September 22, 2001 6:45 PM
Subject: RE: Backup Data
> There are two methods that I commonly use to move data from mySql into
> Access.
>
> The first is to use a myODBC connection and simply import the tables.
Given
&g
ople don't
know that Access supports DDL queries). After I have the table set up, I
import into that table.
> -Original Message-
> From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 22, 2001 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: Backup Data
>
Hello,
I currently have about 2500 records in a mySQL database that is hosted with
my ISP. I am very familar with MS Access. Is it possible that I can backup
my data into a MS Access database ? Any advice would be very grateful !
Thanks
Neil
www.advertising-online.net
---