Re: RE : Dropping foreing key without losing data

On Fri, Jan 31, 2003 at 08:46:53AM +0100, Webmaster LLBfrance wrote: > Hello Zak, > > Thanks for your response. > I try the way you told me, but it seems there is > another problem : > The old foreign keys always exist. > In consequence, there are double references. > > How can i resolve that pro

RE : Dropping foreing key without losing data

reant [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 30 janvier 2003 23:16 À : Webmaster LLBfrance Cc : [EMAIL PROTECTED] Objet : Re: Dropping foreing key without losing data On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or

Re: Dropping foreing key without losing data

On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or desactivate a foreign key without > losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The Inn

Dropping foreing key without losing data

Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Thanks in advance. JeanClaude - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Losing data

Jacob, - Original Message - From: "Devore, Jacob" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 12:20 AM Subject: RE: Losing data > can one change a table from MyISAM tables into something

Losing data more info

create table EAP (eapID int auto_increment primary key, Name varchar(60), Addr1 varchar(50), Addr2 varchar(50), City varchar(30), State varchar(2), index state_ind(state),

Re: Losing data

al Message - From: ""Anna Carlsson"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, August 15, 2002 11:33 PM Subject: Losing data > Hej > > I have several databases with several tables in them and all works fine > except for one database

Losing data

Hej I have several databases with several tables in them and all works fine except for one database that loses data. I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. The problem is as follows: Table B references table A by a foreign key. I've filled table A with all the data I

Re: Losing data

(Sorry for the double email Simon, forgot to switch the email to text...) Simon Windsor wrote: > Hi > > The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, > the standard RedHat version. > > The machine is running two databases, one is a full archive while the other > on

Re: Losing data

Simon Windsor wrote: > Hi > > The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, > the standard RedHat version. > > The machine is running two databases, one is a full archive while the other > ones holds current data. The same five records are unavailable using SQL in >

Re: Losing data

Hi The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, the standard RedHat version. The machine is running two databases, one is a full archive while the other ones holds current data. The same five records are unavailable using SQL in the two databases, but using mys

Re: Losing data

Simon Windsor wrote: > Hi > > I appear to have lost several records, but on doing mysqldump the > records are there. > > I have tried optimize|repair and the data hasn't re-appeared. > > Any ideas ? Not with this level of information. (Try including some sql, what you are trying to match, etc.

Losing data

Hi I appear to have lost several records, but on doing mysqldump the records are there. I have tried optimize|repair and the data hasn't re-appeared. Any ideas ? Simon - Before posting, please check: http://www.mysql.com