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

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

Re: restore question

2013-07-05 Thread spameden
Hi 2013/7/5 Jim Sheffer j...@higherpowered.com 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

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: 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 import

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

Re: Stupid backup/restore question

2002-07-01 Thread Mikhail Entaltsev
] 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's on my working server. So I take one of my regular backups, that I get by doing

RE: Stupid backup/restore question

2002-07-01 Thread Cal Evans
* -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 content of my development

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 the

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 have to drop

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

Re: newbie backup restore question

2002-06-11 Thread Bhavin Vyas
] 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 create the database in the new version