Re: restore question

2013-07-05 Thread spameden
Hi 2013/7/5 Jim Sheffer > Hi everyone- > > This is probably a no brainer (I'm new to Navicat) but I have a backup of > a database from Navicat. > > I want to be able to see if a certain field has changed since this morning > in the backup (We are having problems with an order that somehow > "du

Re: restore question

2013-07-05 Thread shawn green
Hello Jim, On 7/5/2013 3:11 PM, Jim Sheffer wrote: Hi everyone- This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat. I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order th

restore question

2013-07-05 Thread Jim Sheffer
Hi everyone- This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat. I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order that somehow "duplicated" the items. I need to see if

Re: Restore Question

2007-02-23 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], [EMAIL PROTECTED] <[EMAIL PROTECTED]> typed: > After creating a new mysql db from the script, should I have first > restored the old mysql database, then the user databases? You should first restore mysql database just to be on the safe side, but I don't think the imp

Restore Question

2007-02-23 Thread ddevaudreuil
We're in the process of changing our InnoDB databases to file-per-table. I started last night with our test server. It went pretty smoothly, except for one stupid mistake on my part. I backed up all databases, deleted he data and log files, re-created the MySQL database from the script, then

Re: Stupid backup/restore question

2002-07-01 Thread Jesse Sheidlower
On Mon, Jul 01, 2002 at 01:23:38PM -0400, Keith C. Ivey wrote: > On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote: > > > What should I be doing instead? The docs don't seem to specify this, > > and there doesn't seem to be an "ignore" or "replace" option for the > > mysql command. Do I actually ha

Re: Stupid backup/restore question

2002-07-01 Thread Thomas Spahni
On Mon, 1 Jul 2002, Jesse Sheidlower wrote: > I have a working server and a development server. From time to time > I'd like to "refresh" the content of my development server with what's > on my working server. So I take one of my regular backups, that I get > by doing "mysqldump database > dbbac

Re: Stupid backup/restore question

2002-07-01 Thread Keith C. Ivey
On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote: > What should I be doing instead? The docs don't seem to specify this, > and there doesn't seem to be an "ignore" or "replace" option for the > mysql command. Do I actually have to drop all the tables on my > development box before loading in from

RE: Stupid backup/restore question

2002-07-01 Thread Cal Evans
s.com * -Original Message- From: Jesse Sheidlower [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 11:30 AM To: [EMAIL PROTECTED] Subject: Stupid backup/restore question I have a working server and a development server. From time to time I'd like to "refresh" the conte

Re: Stupid backup/restore question

2002-07-01 Thread Mikhail Entaltsev
lt;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 6:30 PM Subject: Stupid backup/restore question > > I have a working server and a development server. From time to time > I'd like to "refresh" the content of my development server with what

Stupid backup/restore question

2002-07-01 Thread Jesse Sheidlower
I have a working server and a development server. From time to time I'd like to "refresh" the content of my development server with what's on my working server. So I take one of my regular backups, that I get by doing "mysqldump database > dbbackupJuly1-02". Then I gzip this, ftp it over to my de

Re: newbie backup restore question

2002-06-11 Thread Bhavin Vyas
> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 5:06 PM Subject: newbie backup restore question > I have a mysql database that I backed up by copying my /var directory to a cd > before I installed a new release of linux. How do I restore it on the new > system? Do I need to

newbie backup restore question

2002-06-11 Thread Scott
I have a mysql database that I backed up by copying my /var directory to a cd before I installed a new release of linux. How do I restore it on the new system? Do I need to create the database in the new version of mysql first, or just copy some files from the old data directory into the new