OK! Thankz... It worked. I dudn't realized that issue when i read the mySQL manual.
----- Original Message ----- From: "Simon Green" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 1:45 PM Subject: FW: Newbie question... > 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 > > --------------------------------------------------------------------- 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