The table type HEAP is in MEMORY table so if you turn off or cash you loss your data. The up side is speed. Try table type = MyISAM Simon
-----Original Message----- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:43 To: Simon Green Subject: Re: Newbie question... Well i've created the tables using the MySQL control center. The program that is inserting the data, is a program develop by me in delphi. But it work fines. If i insert some data and go to mySQL Control Center the data is there. All fields with no problem. I installed mySQL server in 2 different pc's, with the same problem. Every time i stop the service, all data is gone. The tables type is HEAP. They're located at /mysql/data/ ----- Original Message ----- From: "Simon Green" <[EMAIL PROTECTED]> To: "'Fernando Morais'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 1:30 PM Subject: RE: Newbie question... > No this is not right. > How are you creating the tables? > How are you entering the data? > Where are you putting them? e.g. /mysql/var/your_table.frm > What type of table are you using? > Simon > > -----Original Message----- > From: Fernando Morais [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 13:29 > To: [EMAIL PROTECTED] > Subject: Newbie question... > > > > Hi ppl!. > > I'm running Mysql Server 4.0.10 in Win XP. > And every time i shutdown the service, i loose all data inside the tables? > Is this normal, i've i forget something? > > Thankz, > Nando > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
