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 machine. I have > MySQL 3.23.55 installed and i am running the > mysqld-max-nt server. I > have added the following lines to my my.ini file: > (note the # because i > didnt get it to work, i dissabled it) > [mysqld] > > . > #innodb_data_home_dir = > #innodb_log_group_home_dir = > #innodb_data_file_path = > /ibdata/ibdata1:10M:autoextend > > When i start my MySQL server with this config, i get > and error and the > server wont start. What am i doing wrong here?? Any > help is appreciated, > thanks for your time. > > Best regards, > > Davy Obdam > mailto:[EMAIL PROTECTED] > > -- > > Davy Obdam - Obdam webdesign© > mailto:[EMAIL PROTECTED] web: www.davyobdam.com > > > > > > - > 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 > __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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.
>
> +--+--+
> | username | passwd |
> +--+--+
> | jianping | jian1830 |
> | chichi | jian1830 |
> +--+--+
>
> I want the passwd field not to be plain text but
> encrypted. how can i do
> that?
>
> Thanks.
>
>
>
>
-
> 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
>
__
Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html
-
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
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 - 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
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.mobile.yahoo.com/index2002.html - 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
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 grants does the user need to have to perform > a dump: if I want to create a user which is only > used to perform database dumps (in scripts), which > priviliges does it need ? > > 2) I'm using innoDB tables to be able to use foreign > keys. Unfortunatly mysqldump seems to dump the > tables in alphabetical order, which results in error > when one tries to restore a database from this dump > (due to references to tables which don't exist yet). > This is easily fixed for a small database (with a > few cut and pastes), but is the database gets > complex, it causes some headache. Is there a manner > in which this can be avoided ? > > I'm using mySQL 3.23.53 on a Windows 2000 > environnement. > > thanks in advance, > > Glenn Ticket > > - > 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 > __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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 > services has an id, > description, and category. > > Now, it's EASY to search for partners that offer a > certain service, but I > can't figure out a smart way to list all services > for a specific partnerID, > grouped by category. > > I got this far (which I think is perhaps WAY off > track!!): > > SELECT services.*, partners.id > FROM services, partner_service_rel > WHERE partner_service_rel.pid='1' > AND partners.id=partner_service_rel.sid > > And I'm getting "Unknown table 'partners' in field > list". > > Any advice warmly received :) > > > Justin French > > > sql,query > > > - > 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 > __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
Re: innofb foreign keys problem
many thanks for your reply. then i ask me: why mysql needs explicit creation instead of create itself what it needs? manually creating the index seems to be a big complication (for big databases) and a waste of time. don't you think so? it's a bug or a wanted feature? why? Thanks. --- 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, January 14, 2003 5:41 PM > Subject: 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 to create the database on mysql when > i > > receive a lot of errors like this: > > > > ERROR 1005: Can't create table (errno 150) > > > > how can i create the database without creating > > explicitly an index on each foreign keys of my > > database? > > > > any suggestions are appreciated. > > thanks to all. > > > > > __ > > Yahoo! Cellulari: loghi, suonerie, picture message > per il tuo telefonino > > > http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html > > > > > - > > 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 > > > > > __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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 to create the database on mysql when i receive a lot of errors like this: ERROR 1005: Can't create table (errno 150) how can i create the database without creating explicitly an index on each foreign keys of my database? any suggestions are appreciated. thanks to all. __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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 i receive a lot of errors like this: ERROR 1005: Can't create table (errno 150) how can i create the database without creating explicitly an index on each foreign keys of my database? any suggestions are appreciated. thanks to all. __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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: ERROR 1005: Can't create table (errno 150) how can i create the database without creating explicitly an index on each foreign keys of my database? any suggestions are appreciated. thanks to all. __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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 as soon > as possible. Thanks! > > /*-Error Message > 1 -*/ > C:\mysql\bin>mysql > ERROR 2003: Can't connect to MySQL server on > 'localhost' (10061) > /*-- > --*/ > > /*-Error Message > 2 -*/ > C:\mysql\bin>mysqladmin -u root -p password > Enter password: > mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to MySQL server on 'localhost' > (10061)' > Check that mysqld is running on localhost and that > the port is 3306. > You can check this by doing 'telnet localhost 3306' > /*-- > --*/ > > > Best regards, > > Bao Rong Chang > EE Department at Cheng-Shiu Institute of Technology, > Taiwan. > > > > - > Please check > "http://www.mysql.com/Manual_chapter/manual_toc.html"; > before > posting. To request this thread, e-mail > [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown > in the > List-Unsubscribe header of this message. If you > cannot see it, > e-mail [EMAIL PROTECTED] instead. > __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
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! 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 - 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
user's updates trace
# S.O.S. # hi all, anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but 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://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
user updates trace
hi all, anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but they seems not to 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 - 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
user's trace
hi all, anyone knows how to get the history of a user? ... i mean ... in my database i have a lot of user with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but they seems not to trace the user 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 - 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
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 > > > - > 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 > __ Yahoo! Cartoline: invia i tuoi auguri di Natale agli amici http://it.yahoo.com/mail_it/foot/?http://it.greetings.yahoo.com - 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
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 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 Slave I/O thread: connected to > master > > 'repl@sviluppo01:3306', replication started in > log > > 'FIRST' at position 4 > > 021211 16:56:12 Error updating slave list: Query > > error > > 021211 16:56:12 Slave I/O thread exiting, read up > to > > log 'FIRST', position 4 > > If your master is MySQL 4.0.x, make sure that the > repl user has the > REPLICATION SLAVE privilege. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux > Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 1 days, processed 37,721,449 > queries (412/sec. avg) __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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
RE: problem with replication
Hi ... i have just tried by nothing's changed! ... i mean ... now in the "show slave status" i can see the right master_log_filename, log_position etc. but the error persists! What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE <[EMAIL PROTECTED]> ha scritto: > hi, > try this : > > mysql > SHOW MASTER STATUS; > +--++--+--+ > | File | Position | Binlog_do_db | > Binlog_ignore_db | > +--++--+- > + > | some-file| XX | | > | > +--++--+--+ > mysql> CHANGE MASTER TO MASTER_HOST='host', > MASTER_USER='repl', > MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', > MASTER_LOG_POS=XX; > > then restart the slave. > > -Message d'origine- > De : Natale Babbo [mailto:[EMAIL PROTECTED]] > Envoyé : jeudi 12 décembre 2002 16:27 > À : [EMAIL PROTECTED] > Objet : 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, > > > > 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 Slave I/O thread: connected to > > master > > 'repl@sviluppo01:3306', replication started in > log > > 'FIRST' at position 4 > > 021211 16:56:12 Error updating slave list: Query > > error > > 021211 16:56:12 Slave I/O thread exiting, read up > > to > > log 'FIRST', position 4 > > > > Master my.cnf: > > log-bin=/usr/local/mysql/log/MySQL-bin > > server-id=1 > > > > Slave My.ini: > > server-id=2 > > master-host=sviluppo01 > > master-user=repl > > master-password=repl > > > > What's wrong? > > > > Thanks in advance. > > > > > __ > > Yahoo! Foto: salva, ritocca, condividi e ordina > > stampe professionali > > > http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com > > > > __ > Yahoo! Foto: salva, ritocca, condividi e ordina > stampe professionali > http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com > > - > 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 > __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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
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, > > 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 Slave I/O thread: connected to > master > 'repl@sviluppo01:3306', replication started in log > 'FIRST' at position 4 > 021211 16:56:12 Error updating slave list: Query > error > 021211 16:56:12 Slave I/O thread exiting, read up > to > log 'FIRST', position 4 > > Master my.cnf: > log-bin=/usr/local/mysql/log/MySQL-bin > server-id=1 > > Slave My.ini: > server-id=2 > master-host=sviluppo01 > master-user=repl > master-password=repl > > What's wrong? > > Thanks in advance. > > __ > Yahoo! Foto: salva, ritocca, condividi e ordina > stampe professionali > http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com > __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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
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 Slave I/O thread: connected to master 'repl@sviluppo01:3306', replication started in log 'FIRST' at position 4 021211 16:56:12 Error updating slave list: Query error 021211 16:56:12 Slave I/O thread exiting, read up to log 'FIRST', position 4 Master my.cnf: log-bin=/usr/local/mysql/log/MySQL-bin server-id=1 Slave My.ini: server-id=2 master-host=sviluppo01 master-user=repl master-password=repl What's wrong? Thanks in advance. __ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com - 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
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. > > The problem is that all this field ever returns are > 0's. > > I tried using ODBC with the Convert BigInt to Int > option but then the > numbers get truncated. > > Is there a way around this? > > Thanks in advance, > > Andre M. Descombes > > > > - > 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 > __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo - 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
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 > - > Register.it S.p.A. - Gruppo DADA > tel +39 199 REGIST (+39 199 734478) > fax +39 035 3230312 > http://we.register.it > mailto:[EMAIL PROTECTED] > > - > 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 > __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo - 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
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.americanexpress.it/land_yahoo - 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
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.americanexpress.it/land_yahoo - 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
.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 Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo - 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
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 more question > Do I need to change the table type to > transaction-safe tables (InnoDB > and BDB) ? > AS I am going thru the manuals I read that tables > should be of InnoDB > or BDB inorder to work for manual commit. > > > once again thanks in advance, > Devi > > > -Original Message- > From: Peter Brawley > [mailto:peter.brawley@;artfulsoftware.com] > Sent: Wednesday, November 13, 2002 6:04 PM > To: Devi Annisetty > Subject: Re: turn off auto commit in MYSQL > > > SET @@autocommit=0 > or > BEGIN > > - > > Hi, > I am newbie to MYSQL and ODBC > > I have to update more than 2 tables simultanously > currently my application uses ADOBC connection > object. > > How can turn off the autocommit option and set > manaul commit. > > what places I need to change inorder to work manual > commit > > Thanks in Advance for your time > Devi > > - > 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 > __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo - 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
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/inittab file and look for a line > with "initdefault" keyword: > id:3:initdefault: > > If you start at runlevel 5, you should create a > symbolic > link in /etc/init.d/rc5.d > > Hope this helps, > -- > Joseph Bueno > > Natale Babbo wrote: > > > 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. > > > > Natale Babbo. > > > > > > > > > > --- Iikka_Meriläinen > > ha scritto: > On Tue, 29 Oct 2002, Natale Babbo > wrote: > > > > >>Hi all, > > >> > > >>I'm using Linux Suse 8.0. > > >>I copied the file mysql.server located in > > >>/usr/local/mysql/support-files to /etc/init.d > > >>directory. > > >>I made a simbolic link to mysql.server script in > > >>/etc/init.d/rc3.d but MySQL doesn't appear to > > > > > >start at > > > > > >>the boot time. > > >> > > >>Anyone can help me? > > > > > >Hi! > > > > > >Try starting mysqld with --console --standalone > > >parameters and see if it > > >starts at all. If yes, you've got a problem with > > >your startup scripts. Check > > >any paths in those and check that your symbolic > link > > >works. Also try running > > >the script in /etc/init.d/rc3.d (the symbolic > link > > >in this case) manually > > >after the system startup. > > > > > >Regards, > > >Iikka > > > > > >** > > >* Iikka Meriläinen * > > >* E-mail: [EMAIL PROTECTED] * > > >* Vaala, Finland * > > >** > > > > > __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
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. Natale Babbo. --- Iikka_Meriläinen <[EMAIL PROTECTED]> ha scritto: > On Tue, 29 Oct 2002, Natale Babbo wrote: > > > Hi all, > > > > I'm using Linux Suse 8.0. > > I copied the file mysql.server located in > > /usr/local/mysql/support-files to /etc/init.d > > directory. > > I made a simbolic link to mysql.server script in > > /etc/init.d/rc3.d but MySQL doesn't appear to > start at > > the boot time. > > > > Anyone can help me? > > Hi! > > Try starting mysqld with --console --standalone > parameters and see if it > starts at all. If yes, you've got a problem with > your startup scripts. Check > any paths in those and check that your symbolic link > works. Also try running > the script in /etc/init.d/rc3.d (the symbolic link > in this case) manually > after the system startup. > > Regards, > Iikka > > ** > * Iikka Meriläinen * > * E-mail: [EMAIL PROTECTED] * > * Vaala, Finland * > ** > __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
mysql service on linux
Hi all, I'm using Linux Suse 8.0. I copied the file mysql.server located in /usr/local/mysql/support-files to /etc/init.d directory. I made a simbolic link to mysql.server script in /etc/init.d/rc3.d but MySQL doesn't appear to start at the boot time. Anyone can help me? Thank 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 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
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 http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
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 scritto: > Natale, > Friday, October 25, 2002, 10:08:00 AM, you wrote: > > NB> ok ... that's right for data (insert into ...) > ... but > NB> i get the error before ... when mysql try to > create > NB> child table: > NB> CREATE TABLE ... idParent BIGINT, INDEX > idpar_ind > NB> (idParent), FOREIGN KEY (idParent) REFERENCES > NB> parent(id) > NB> .. when mysql parses the foreign key, parent > table > NB> doesn't exist yet! > > No, it's true not only for data. > Put > > SET FOREIGN_KEY_CHECKS=0; > > in the dump file and then restore tables. It works > fine for me. > > NB> --- Victoria Reznichenko > NB> <[EMAIL PROTECTED]> ha scritto: > > NB> 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> ... i mean ... to allow restoring correctly > >> NB> without foreign key constraint violation (if > in > >> the > >> NB> backup file ddl code for the child table is > >> before ddl > >> NB> code for the parent table i get an error). > >> > >> You can set up SET FOREIGN_KEY_CHECKS=0, in this > >> case foreign key > >> constraints will not be checked. It's supported > >> since 3.23.52 and > >> 4.0.3 > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > - > 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 > __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
re: innodb tables backup
ok ... that's right for data (insert into ...) ... but i get the error before ... when mysql try to create child table: CREATE TABLE ... idParent BIGINT, INDEX idpar_ind (idParent), FOREIGN KEY (idParent) REFERENCES parent(id) .. when mysql parses the foreign key, parent table doesn't 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> ... i mean ... to allow restoring correctly > NB> without foreign key constraint violation (if in > the > NB> backup file ddl code for the child table is > before ddl > NB> code for the parent table i get an error). > > You can set up SET FOREIGN_KEY_CHECKS=0, in this > case foreign key > constraints will not be checked. It's supported > since 3.23.52 and > 4.0.3 > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > - > 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 > __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
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 __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
RE: mysql replication error
No ... I'm just setting up the replication for the first time. I make a dump of the master and i replaced it on the slave. thanks and bye. --- Victor Pendleton <[EMAIL PROTECTED]> ha scritto: > Has the replication worked previously for you? > If so, have you reset the master 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: 10/23/02 8:22 AM > Subject: mysql replication error > > i get the following error in the connection > slave->master while setting up a replication between > two MySQLServer(slave and master both windows XP): > > .err file on slave: > MySql: ready for connections > 021023 14:08:34 InnoDB: Started > 021023 14:08:35 Slave I/O thread: connected to > master > '[EMAIL PROTECTED]:3306', replication started in log > 'FIRST' at position 4 > 021023 14:08:35 Error updating slave list: Query > error > 021023 14:08:35 Slave I/O thread exiting, read up > to > log 'FIRST', position 4 > > what does it mean? > > My.ini on Master: > log-bin=C:\Programmi\MySQL\Logs\MySQL-bin > server-id=1 > > My.ini on Slave: > master-host=192.168.0.4 > master-user=repl > master-password= > master-port=3306 > server-id=2 > set-variable = slave_net_timeout=3600 > set-variable = net_read_timeout=3600 > > Show master status: > File : MySQL-bin.001 > Position : 79 > Binlog_do_db : > Binlog_inogne_db : > > ERROR > No query specified > > Show Slave status: > Master_Host : 192.168.0.04 > Master_User : repl > Master_Port : 3306 > Connect_retry: 60 > Master_Log_File : > Read_Master_Log_Pos : 4 > Relay_Log_File : MySQL-relay-bin.002 > Relay_Log_Pos: 4 > Relay_Master_Log_File: > Slave_IO_Running : Yes > Slave_SQL_Running: Yes > Replicate_do_db : > Replicate_ignore_db : > Last_errno : 0 > Last_error : > Skip_counter : 0 > Exec_master_log_pos : 0 > Relay_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://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ > > - > 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 __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
mysql replication error
i get the following error in the connection slave->master while setting up a replication between two MySQLServer(slave and master both windows XP): .err file on slave: MySql: ready for connections 021023 14:08:34 InnoDB: Started 021023 14:08:35 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 021023 14:08:35 Error updating slave list: Query error 021023 14:08:35 Slave I/O thread exiting, read up to log 'FIRST', position 4 what does it mean? My.ini on Master: log-bin=C:\Programmi\MySQL\Logs\MySQL-bin server-id=1 My.ini on Slave: master-host=192.168.0.4 master-user=repl master-password= master-port=3306 server-id=2 set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 Show master status: File : MySQL-bin.001 Position : 79 Binlog_do_db : Binlog_inogne_db : ERROR No query specified Show Slave status: Master_Host : 192.168.0.04 Master_User : repl Master_Port : 3306 Connect_retry: 60 Master_Log_File : Read_Master_Log_Pos : 4 Relay_Log_File : MySQL-relay-bin.002 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running : Yes Slave_SQL_Running: Yes Replicate_do_db : Replicate_ignore_db : Last_errno : 0 Last_error : Skip_counter : 0 Exec_master_log_pos : 0 Relay_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://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.com/ - 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
