data disappeared in mysql on XP

2004-05-28 Thread Centaur zeus 
Hi all,
   I have just installed mysql 4.0 on my XP. I inserted data into the db by 
java. Then I used
1) command prompt to select from the table
2) MysqlCC
3) JDBC to retrieved the inserted data.
It's ok. However, after a while (like rebooting my notebook, or hibernate my 
notebook... but not repeatable), the data is just all gone. I tried to 
insert data by MysqlCC, it's like that also. This case always happen.

Has anyone experienced this before and advise the solution ?
   THanks.
Perseus
_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

table design of multi-lingual content

2003-11-19 Thread Centaur zeus 
Hi all ,

  I want to design a table, say
T_PRODUCT { PRD_ID, NAME, DESCRIPTION, PRICE }
where I want NAME and DESCRIPTION to have multi language inputed.
I searched before where found two solutions :

1)
T_PRODUCT {PRD_ID, PRD_DETAIL_ID, PRICE}
T_PRODUCT_DETAIL { PRD_DEATIL_ID, LANG, NAME, DESCRIPTION }
2)
T_PRODUCT {PRD_ID, NAME_LANG_ID, DESCRIPTION_LANG_ID, PRICE}
T_LANG { LANG_ID, LANG, CONTENT }
But 1) seems to be a very trivial process where I have to have one 
additional table for each table for language. But I am afraid 2 will have 
too much join if multi-lingual attributes increase.
Is there a better design ? Please advise

Thanks.

Perseus

_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

safe_mysqld bind-address

2002-10-28 Thread Centaur zeus 
Hi all ,

  I am trying to do the following :

[root@xxx bin]# ./safe_mysqld --bind-address=192.168.1.222
Starting mysqld daemon with databases from /usr/local/mysql/var

but when I telnet xxx 3306, the mysqld have the following response:

./safe_mysqld: line 1: 12325 Segmentation fault  nice --5 nohup
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/hkpfaServer.pid --skip-locking
--bind-address\=192.168.1.222 /usr/local/mysql/var/hkpfaServer.err 21

Number of processes running now: 2
mysqld process hanging, pid 12328 - killed
./safe_mysqld: kill: (12328) - No such pid
021029 00:37:34  mysqld restarted

So how can I bind the address successfully ?
Thanks.

Perseus



_
Get a speedy connection with MSN Broadband.  Join now! 
http://resourcecenter.msn.com/access/plans/freeactivation.asp


-
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