RE: how to move db

Hi The safest way to do this is to use "mysqldump" utility. mysqldump -u [username] -p dbname > /path/to/dumpfile and then mysql -u [username] -p dbname < /path/to/dumpfile Regards Daniel £aœ e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail:

RE: primary key based on unique value for two columns

Hi You are wrong. Just try for example: create table test( pk1 int not null, pk2 int not null, primary key(pk1,pk2) ); Regards Daniel £aœ e-direct Polska sp. z o.o. WW

ODP: MySQL privileges

Hi Just type: mysql -u root Regards > -Oryginalna wiadomoœæ- > Od: COLLINEAU Franck FTRD/DMI/TAM > [mailto:[EMAIL PROTECTED]] > Wys³ano: 29 paŸdziernika 2001 15:05 > Do: '[EMAIL PROTECTED]' > Temat: MySQL privileges > > > Hi! > > I'm working on a Linux Mandrake 8.1 station. > I have ins

ODP: Tree in SQL

Thank you. I was trying too long to do this in SQL. > -Oryginalna wiadomoœæ- > Od: Dan Nelson [mailto:[EMAIL PROTECTED]] > Wys³ano: 22 paŸdziernika 2001 23:38 > Do: Daniel _a_ > DW: Lista MySQL > Temat: Re: Tree in SQL > > > In the last episode (Oct 22), Daniel _a_ said: > > I have a tabl

ODP: Can only create 127 records in a table :o(

Hi WHat is your hardware configuration ? I had such problem with Alpha/Linux (RedHat 5.2) Regards Daniel £aœ e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail: [EMAIL PROTECTED] 45-072 Opole ul. Reymonta 45 tel. +48 77 44 26 073 fax. +48 77 44 26