Re: InnoDb Problems

i see that you don't specify any path for innodb_data_home_dir, innodb_log_group_home_dir and innodb_data_file_path ... write down the correct path and retry. regards. --- Davy Obdam <[EMAIL PROTECTED]> ha scritto: > Hi People, > > I have been trying to get InnoDb to run on my > windows XP

Re: encrypted password

try to use the password() function. update user set password=password('your_psw') where user='your_user' bye --- Jianping Zhu <[EMAIL PROTECTED]> ha scritto: > > I have mysql in a redhat machine. I need to use > mysql do user > authentication to a website. > I have a table like following. >

4.1 binaries

any further news about 4.1 binaries release date? TIA (mysql, sql) __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html -

rebuilt index

hi all, which is the command to rebuilt innodb tables indexes? (if exists). many thanks. (mysql,sql) __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.m

Re: mysqldump questions

Hi, 1) try this: GRANT SELECT, RELOAD ON *.* to dump@”%” IDENTIFIED BY ; 2) in the backup file insert this line above all: SET FOREIGN_KEY_CHECKS = 0; ... and all will be ok! regards --- Glenn Ticket <[EMAIL PROTECTED]> ha scritto: > > I have 2 questions concerning mysqldump. > > 1) What gr

Re: relational tables query help

because there isn't any partners table in the FROM clause! --- Justin French <[EMAIL PROTECTED]> ha scritto: > Hi all, > > I have three tables: > > partners (id,name,url,desc) > services (id,desc,category) > partner_service_rel (pid,sid) > > Each partner offers a range of services, and each >

Re: innofb foreign keys problem

--- Okan CIMEN <[EMAIL PROTECTED]> ha scritto: > There are no other way > you have to create the index first > > - Original Message - > From: "Natale Babbo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, Janu

innofb foreign keys problem

# - 3rd post - # # - PLEASE HELP -- # hi to all, is it still true that mysql/innodb needs explicit index creation on foreign keys? why can't i use a standard syntax for foreign keys creations? i have a database schema (ddl) with over 50 tables and i was trying

mysql / innodb foreign keys

# - PLEASE HELP -- # hi to all, is it still true that mysql/innodb needs explicit index creation on foreign keys? why can't i use a standard syntax for foreign keys creations? i have a database schema (ddl) with over 50 tables and i was trying to create the database on mysql when

mysql / innodb foreign key

hi to all, is it still true that mysql/innodb needs explicit index creation on foreign keys? why can't i use a standard syntax for foreign keys creations? i have a database schema (ddl) with over 50 tables and i was trying to create the database on mysql when i receive a lot of errors like this:

Re: need solution

is mysql daemon started? --- brchang <[EMAIL PROTECTED]> ha scritto: > Dear Michael Widenius: > > After installation of mysql-3.23.52-win in Win2000 > platform, I have the > problem with the errors, as shown below, once I try > to start mysql. Could > you provide me the solution to this problem

question about query log

hi all, anyone knows if it is possible to create the query log in a mysql table instead of in a text file? Otherwise ... is there a way to import it into a table? Thanks to all. Natale Babbo sql, query __ Yahoo

user's updates trace

they seems not to trace the user that execute the query. is it true? thanks in advance. natale babbo P.S.: plase help me ... any tips are appreciated!! __ Yahoo! Cellulari: scarica i loghi e le suonerie per le tue feste! http

user updates trace

trace the user that execute the query. is it true? thanks in advance. natale babbo __ Yahoo! Cellulari: scarica i loghi e le suonerie per le tue feste! http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html

user's trace

that do the query. is it true? thanks in advance. natale babbo mysql, query __ Yahoo! Cellulari: scarica i loghi e le suonerie per le tue feste! http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html

Re: 4.1 Download

i wish to know too! thanks --- "Anthony W. Marino" <[EMAIL PROTECTED]> ha scritto: > Where/how can I get a copy of 4.1? > Thanks, > Anthony > > > > > > > > > > > > > > > > > > > > > > > sql,query,queries,smallint > > > -

Re: problem with replication

Now is ok ... thank you very much! --- Jeremy Zawodny <[EMAIL PROTECTED]> ha scritto: > On Wed, Dec 11, 2002 at 05:03:51PM +0100, Natale > Babbo wrote: > > Hi all, > > > > I have a problem with replication between two > servers. > > I created user repl on

RE: problem with replication

-+- > + > | some-file| XX | | > | > +--++--+--+ > mysql> CHANGE MASTER TO MASTER_HOST='host', > MASTER_USER='repl', > MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file&

Fwd: problem with replication

Any suggestion about this error? Thanks to all. --- Natale Babbo <[EMAIL PROTECTED]> ha scritto: > Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) > Da: Natale Babbo <[EMAIL PROTECTED]> > Oggetto: problem with replication > A: [EMAIL PROTECTED] > > Hi all, > &g

problem with replication

Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql: ready for connections 021211 16:56:12 InnoDB: Started 021211 16:56:12 Sla

Re: Problem with ADO, MyOLEDB and BigInt columns

i had the same problem too ... also with blob fields ... never solved! please keep me informed. thanks. bye --- Andre Michel Descombes <[EMAIL PROTECTED]> ha scritto: > Hi, > > I am trying to access a third party MySQL table > containing a BigInt field, > using ADO with a MyOLEDB driver. >

Re: Graphical client

check mysql site at http://www.mysql.com/downloads/index.html Bye --- Massimo Bandinelli <[EMAIL PROTECTED]> ha scritto: > Does anyone know a good graphical mysql client for > windows and linux? > > Massimo Bandinelli > System Administrator > mob +39 335 7324615 > --

mysql proxy

hi, anyone has informations about any program that implementing load balancing and hotswapping in a mysql cluster system? Thanks __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexp

mysql proxy

hi all, anyone knows if exist a program load balancing and hotswap in a mysql cluster system (a sort of proxy for mysql)? Thanks in advance. __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.

.NET and mysql

Hello All, Is it possible to connect to a MySQL database using .NET without ODBC? ... and if yes then please give me a sample connection string and tell me what provider/driver to use! Thanks a lot! __ Per te Blu American Expres

RE: turn off auto commit in MYSQL

is there any configuration that turn on auto commit persistently ... i mean for each client connections? (in my.cnf [client] or something else) Thanks in advance. Natale Babbo --- Devi Annisetty <[EMAIL PROTECTED]> ha scritto: > Hi Peter, > > Thank you very much > I got one

Re: mysql service on linux

Many Thanks ... now works fine! Natale Babbo --- Joseph Bueno <[EMAIL PROTECTED]> ha scritto: > Hi, > > Make sure that your system starts at runlevel 3 on > boot. If you start your machine with X11, chances > are > that its runlevel is 5. > > Check your /etc/in

Re: mysql service on linux

Many Thanks No problems with mysql.server script ... it works fine if i start it manual like this: shell> mysql.server start or shell> mysql.server stop ... also symbolic link in /etc/init.d/rc3.d is ok. The only problem is that MySQL service doesn't start at boot. N

mysql service on linux

in advance. Natale Babbo __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - Before posting, please chec

innodb tablespace size

innodb_data_file_path=ibdata1:100M:autoextended:max:200M anyone knows what happen if the above innodb tablespace reach the limit of 200M? Thanks in advance. Natale Babbo sql __ Mio Yahoo!: personalizza Yahoo! come piace a te

re: re: innodb tables backup

i tried it ... but nothing to do! when mysql parse the foreign key in the create table i get the error. perhaps i'm wronging in restoring tables/db! i use this method: shell> mysql -u -p < is it wrong? thanks. Natale Babbo --- Victoria Reznichenko <[EMAIL PROTECTED]> ha

re: innodb tables backup

exist yet! bye and thanks. Natale Babbo --- Victoria Reznichenko <[EMAIL PROTECTED]> ha scritto: > Natale, > Thursday, October 24, 2002, 10:57:00 AM, you wrote: > > NB> Anyone knows how to backup innodb tables in the > right > NB> sql order? > NB> ..

innodb tables backup

Anyone knows how to backup innodb tables in the right sql order? ... i mean ... to allow restoring correctly without foreign key constraint violation (if in the backup file ddl code for the child table is before ddl code for the parent table i get an error). Thanks in advance. Natale Babbo

RE: mysql replication error

ter and the slave? > Was a snapshot of the master placed on the slave > before beginning > replication? > I hate to ask such simple questions but I am just > checking. > > Victor > > -----Original Message- > From: Natale Babbo > To: [EMAIL PROTECTED] > Sent

mysql replication error

log_space : 0 ERROR: No query specified What is wrong? Why do I get the error ? Which type of query should I specify? Thanks in advance. Natale Babbo __ Mio Yahoo!: personalizza Yahoo! come piace a te http: