RE: backup data

2003-02-02 Thread Sherzod Ruzmetov
: 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.

backup data

2003-02-02 Thread Andrew
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.

getting backup data from .frm files in InnoDB

2003-01-13 Thread kk
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

RE: Backup Data

2001-09-22 Thread Will French
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

Re: Backup Data

2001-09-22 Thread Neil Tompkins
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

RE: Backup Data

2001-09-22 Thread Will French
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 >

Backup Data

2001-09-22 Thread Neil Tompkins
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 ---