Re: replication config without stopping master server

Hi Thomas, Here I have one more confusion that after the binary log value is `mysql-bin.003' and the offset is 73. Record the values. where should I put it in the slave? Suppose I have copied that snapshot on the slave server and start the MySQL and replication. Where I need to put the

Re: slow join

i solved the problem... for the ones, who wants to know: only creating an index on artikelnummer on both tables made the query beeing ready after 2 seconds again :-) Oliver On Wed, 15 Sep 2004 00:38:59 +0200, Oliver Schiessl [EMAIL PROTECTED] wrote: MySQL 3.23.58: ive got 2 tables with ca.

question of mysql start up

Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm MySQL-3.23.47-3.aix4.3.ppc.rpm MySQL-client-3.23.47-3.aix4.3.ppc.rpm All of them was installed by using the command : rpm -i *.* then Apache and php can work but

Re: question of mysql start up

On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote: Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm MySQL-3.23.47-3.aix4.3.ppc.rpm MySQL-client-3.23.47-3.aix4.3.ppc.rpm All of them was installed by using the command :

Force slave to connect from specified IP

Hello, I have two interfaces on my slave: ppp0 80.80.80.8 ( - Internet ) eth0 10.10.10.1 ( - LAN ) and remote master host 192.168.168.168 available by 80.80.80.8. How can I force mysql to start slave processes using 10.10.10.1 and not 80.80.80.8, which is he choosing by defualt. I need similiar

Re: Moving Data

Are there any variables here I can tune to try and increase the the query? mysql show variables like '%buff%'; +-+---+ | Variable_name | Value | +-+---+ | bdb_log_buffer_size | 262144| | bulk_insert_buffer_size |

question about mysql start up again

Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm MySQL-3.23.47-3.aix4.3.ppc.rpm MySQL-client-3.23.47-3.aix4.3.ppc.rpm All of them was installed by using the command : rpm -i *.* then Apache and php can work but

Re: SV: Mysql goes down when executing query

Thanks, but already have innodb_buffer_pool_size=160M and I've raised innodb_additional_mem_pool_size from 2M to 10M And the problem remains the same. Any sugestions? Thanks Mauricio On Tue, 2004-09-14 at 18:05, Nickolai Nielsen wrote: Hi Try setting these variables in you conf:

Re: Unable to download MySQL (fwd)

I have tried different URL's, including trying the ftp URL at Oakland, USA, and the Australian URL previously cited. I get the same problem - instead of getting a dialogue box giving me the option of saving the file to disk (and, in what path), the browser commences downloading the

Re: question about mysql start up again

On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote: Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm MySQL-3.23.47-3.aix4.3.ppc.rpm MySQL-client-3.23.47-3.aix4.3.ppc.rpm All of them was installed by using the command :

Re: what os to use for mysql on amd64?

Hello MC, any results yet by any chance ? What conclusion did you get out of your test ? There is another threat going on with the subject line Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE? Best regards Nils Valentin Tokyo/Japan On Tuesday 27 July 2004 12:39,

Windows specific characters

Hello: I have some data in a spreadsheet that I need to load into a database. The data in the excel spreadsheet apparently contains windows specific characters. Whenever I import the data into my database, those special characters remain and since my database runs on an unix platform, I am

Re: what os to use for mysql on amd64?

Sorry last e-mail didnt contain all text for whatever reason it should be like this: -- Hello MC, any results yet by any chance ? What conclusion did you get out of your test ? There is another threat going on with the subject line Re: best-performing CPU + platform for MySQL now?

Do Anyone Have Help Material in Pdf Format .. Dummies !

Hallo Everyone, Well can someone please get me some Mysql for Dummies sort of pdf files; Thanx in Advance Regards Shiva ps:- The problem is I'm not able to execute any of the commands after installing Mysql in Windows 2000 P, In short there is only this Red Sign which it is showing in the

Re: Do Anyone Have Help Material in Pdf Format .. Dummies !

If you simply Google on MySQL for Dummies, you will find what you want. You'll have to pay for it though. For example: http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0764516507,subcat-PROGRAMMING.html If you want the standard MySQL manual in PDF format, you can find it at

different max_connections based on users/host

Is it possible to configure MySQL to have different max_connections limit based on either user or host which is connecting to server? I mean, suppose we have max_connections=500, is it possible to say that from all external clients there could be at max 490 connections, while a single host or

mysql still can't start up

Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm MySQL-3.23.47-3.aix4.3.ppc.rpm MySQL-client-3.23.47-3.aix4.3.ppc.rpm All of them was installed by using the command : rpm -i *.* then Apache and php can work but

Re: Windows specific characters

- Original Message - From: Juan Alvarado [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 8:56 AM Subject: Windows specific characters Hello: I have some data in a spreadsheet that I need to load into a database. The data in the excel spreadsheet

Re: mysql still can't start up

- Original Message - From: [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:25 AM Subject: mysql still can't start up when I used the command safe_mysqld start the system told me Starting mysqld daemon with databases from /var/lib/mysql 040913

Mysql and PHP

People, This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as of last night) and it runs. My problem is that PHP does not see Mysql. Now I have done this installation 4 or 5 times but th elast time was over a year

Re: Mysql and PHP

OS is W2K. -Original Message- From: nestor(earth) [EMAIL PROTECTED] Sent: Sep 15, 2004 8:04 AM To: Cc: [EMAIL PROTECTED] Subject: Mysql and PHP People, This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as

RE: Copying rows based on query result to another table?

Does anyone know if I can construct my insert/select statement this way instead: INSERT INTO wow.resume_erp ( field1, field2, etc) INSERT INTO wow.candidate_erp ( field1, field2, etc) SELECT SQL_CALC_FOUND_ROWS * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH

Re: Mysql and PHP

On Wed, 15 Sep 2004, nestor(earth) wrote: People, This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as of last night) and it runs. My problem is that PHP does not see Mysql. Now I have done this installation

Re: Mysql and PHP

On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth) [EMAIL PROTECTED] wrote: This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as of last night) and it runs. My problem is that PHP does not see Mysql. Now I have

root-password important?

Hello, imagine the following setup: - a mysql-server - a client on a different host Privileges on the mysql-server are setup in a manner, that users can connect from every host, but not from localhost (and they don't even have access to localhost). root on the other hand is allowed to connect

Re: mysql still can't start up

http://www.catb.org/~esr/faqs/smart-questions.html Stop repeating the same question or you will never get an answer. Try again please. Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm

Re: mysql still can't start up

Mine is owned by root:root and has its sticky bit set. Does not allow a normal user to delete. - Original Message - From: Annie Xie [EMAIL PROTECTED] To: Jonathan Mangin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:57 AM Subject: Re:

Re: Mysql and PHP

On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED] wrote: Did you build both php and apache with MySQL support? I wasn't aware you could build Apache with MySQL support. How is that done? -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- MySQL General

Re: Mysql and PHP

People, This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as of last night) and it runs. My problem is that PHP does not see Mysql. Now I have done this installation 4 or 5 times but th elast time was over a

RE: Mysql and PHP

You will likely want to read this: http://us4.php.net/mysql In PHP 5, MySQL is no longer enabled by default, nor is the MySQL library bundled with PHP. Read this FAQ for details on why. Because of this, Windows users will need to enable php_mysql.dll inside of php.ini and either copy

Re: Mysql and PHP

On Wed, 15 Sep 2004, Greg Donald wrote: On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas [EMAIL PROTECTED] wrote: Did you build both php and apache with MySQL support? I wasn't aware you could build Apache with MySQL support. How is that done? Apologies - I should have said just php.

Re: root-password important?

On Wed, 15 Sep 2004 17:10:27 +0200, Marten Lehmann [EMAIL PROTECTED] wrote: imagine the following setup: - a mysql-server - a client on a different host Privileges on the mysql-server are setup in a manner, that users can connect from every host, but not from localhost (and they don't

Re: Mysql and PHP

You have to rebuild PHP against the new MySQL libraries. Curtis Greg Donald said: On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth) [EMAIL PROTECTED] wrote: This more of a php mysql question. I have installed PHP ( 5.01) with Apache(1.31) and it runs. I have install Mysql (the latest as

Re: root-password important?

Hi, I would never allow anyone except myself to connect to my MySQL server as the root MySQL user. I don't want to allow either. That's why I'm asking. From outside, noone can connect as root directly. And as noone has access to localhost through ssh or whatever, noone except me can login as

Insert feedback

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This one has to be easy, but it seems to be hidden in the documentation (translation: I'm too dense to find it g). When doing an insert, there is the feedback line 1 Row Inserted. When reloading a database from a backup, this can drastically slow

Re: 4.1.4a-gamma in production?

Hello, Is gamme the last step until the 4.1.4 will be released? Yes. Or will rc's follow before? No. that's nice to hear. So when will the final version be released? 2 days? 2 weeks? Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Mysql and PHP

slightly off topic, but you can sort of build apache with mysql support. mod_auth_mysql allows you to authenticate users and groups against a DB http://sourceforge.net/projects/modauthmysql/ chris -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: 15 September 2004

charset latin1_de removed in 4.1.4?

Hello, in 4.0.20 I was happy that German Umlauts are sorted correctly (ä - ae, ö - oe, ü - ue). With 4.1.4 the configuration stops: checking character sets... configure: error: Charset 'latin1_de' not available. (Available are: binary ascii armscii8 ascii big5 cp1250 cp1251 cp1256 cp1257 cp850

Re: root-password important?

On Wed, 15 Sep 2004 17:48:50 +0200, Marten Lehmann [EMAIL PROTECTED] wrote: I don't want to allow either. That's why I'm asking. From outside, noone can connect as root directly. And as noone has access to localhost through ssh or whatever, noone except me can login as root. My question was

RE: Mysql and PHP

On Wed, 15 Sep 2004, Chris Blackwell wrote: slightly off topic, but you can sort of build apache with mysql support. mod_auth_mysql allows you to authenticate users and groups against a DB http://sourceforge.net/projects/modauthmysql/ That's actually the reason I originally said I compiled

Re: charset latin1_de removed in 4.1.4?

At 18:13 +0200 9/15/04, Marten Lehmann wrote: Hello, in 4.0.20 I was happy that German Umlauts are sorted correctly (ä - ae, ö - oe, ü - ue). With 4.1.4 the configuration stops: checking character sets... configure: error: Charset 'latin1_de' not available. (Available are: binary ascii

Re: 4.1.4a-gamma in production?

In the last episode (Sep 15), Marten Lehmann said: Is gamme the last step until the 4.1.4 will be released? Yes. Or will rc's follow before? No. that's nice to hear. So when will the final version be released? 2 days? 2 weeks? Previous history (3.23 and 4.0 timelines) indicates

4.0.20: index being ignored in simple query

Afternoon all The problem: I am doing a simple query on a table, comparing 2 columns to constants. The table is indexed with a compound index on these 2 columns. The join optimizer only seems to notice that the first column is indexed, and ignored the second column. The table is large (16M rows),

RE: Mysql and PHP

This is also very useful: Getting PHP 5 to work with MySQL http://www.phpbuilder.com/board/showthread.php?s=threadid=10246585 - Eve -Original Message- From: Greg Donald [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 11:10 AM To: nestor(earth) Cc: [EMAIL PROTECTED]

Re: 4.1.4a-gamma in production?

Hello, Is gamme the last step until the 4.1.4 will be released? Yes. Or will rc's follow before? No. that's nice to hear. So when will the final version be released? 2 days? 2 weeks? Regards Marten Wishful thinking :-) As far as I'm aware there is no set time frame from

Re: mysql still can't start up OT

Another question related to server start: Can I configure mysql.sock to some other dir, since /tmp/mysql.sock might easiely being deleted by someone? Thanks! Annie Yes, you can - and I'd make that recommendation on shared systems. configure option:

Re: Mysql and PHP

Thanks to all for your replies! Installing myodbc fixed the problem. Thanks again! Eve Atley wrote: This is also very useful: Getting PHP 5 to work with MySQL http://www.phpbuilder.com/board/showthread.php?s=threadid=10246585 - Eve -Original Message- From: Greg Donald [mailto:[EMAIL

Installing DBIx::DWIW on CPAN

Hello All, I am trying to install DBIx::DWIW but giving me following error. No such file `DBIx-DWIW-0.41.tar.gz' I am trying to install from CPAN cpan install DBIx::DWIW Could not fetch authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz Giving up on

Re: mysql still can't start up OT

I compiled mysql w/o this option. Is there any file that I can modify and bounce the server to take this? I modified: my-path/share/mysql -rw-r--r-- 1 root other 4938 Jul 23 10:32 my-huge.cnf -rw-r--r-- 1 root other 4914 Jul 23 10:33 my-large.cnf -rw-r--r-- 1

drop database after lost of synchro in innodb

Hello I am trying to drop a database but I have the following: ERROR 1016: Can't open file: 'Alias.InnoDB' (errno: 1) In fact it looks like the synchro is lost between FRM and IBD. (I use a multiple tablespace configuration) according to http://www.innodb.com/ibman.php section 15.1.

Re: Installing DBIx::DWIW on CPAN

On Wed, 15 Sep 2004 11:27:55 -0700, Sanjeev Sagar [EMAIL PROTECTED] wrote: Hello All, I am trying to install DBIx::DWIW but giving me following error. No such file `DBIx-DWIW-0.41.tar.gz' I am trying to install from CPAN cpan install DBIx::DWIW Could not fetch

Re: Installing DBIx::DWIW on CPAN

On Wed, Sep 15, 2004 at 11:27:55AM -0700, Sanjeev Sagar wrote: Hello All, I am trying to install DBIx::DWIW but giving me following error. No such file `DBIx-DWIW-0.41.tar.gz' I am trying to install from CPAN cpan install DBIx::DWIW Could not fetch

RE: Installing DBIx::DWIW on CPAN

I am trying on cpan.yahoo.com and it's giving me following error The requested URL /authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz was not found on this server. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Wed 9/15/2004 1:05 PM To: Sanjeev Sagar Cc: [EMAIL

Re: Installing DBIx::DWIW on CPAN

On Wed, Sep 15, 2004 at 01:10:35PM -0700, Sanjeev Sagar wrote: I am trying on cpan.yahoo.com and it's giving me following error The requested URL /authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz was not found on this server. Hmm. wget

RE: Installing DBIx::DWIW on CPAN

Thanks ! I am trying to run make test but it's giving me following error [EMAIL PROTECTED] DBIx-DWIW-0.41]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/lib -Iblib/arch test.pl 1..1 # Running under perl version 5.008 for linux # Current time local: Wed Sep 15 13:42:27 2004 # Current time

Re: Installing DBIx::DWIW on CPAN

On Wed, Sep 15, 2004 at 01:44:21PM -0700, Sanjeev Sagar wrote: Thanks ! I am trying to run make test but it's giving me following error [EMAIL PROTECTED] DBIx-DWIW-0.41]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/lib -Iblib/arch test.pl 1..1 # Running under perl version 5.008 for

Group by and results

Are these 2 statements the same? tSql1 = select distinct foo, bar, baz from table tSql2 = select foo, bar, baz from table group by foo, bar, baz Why would I get different results? -- - Scott HanedaTel:

Re: Group by and results

- Original Message - From: Scott Haneda [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 8:12 PM Subject: Group by and results Are these 2 statements the same? tSql1 = select distinct foo, bar, baz from table tSql2 = select foo, bar, baz from table group

Query execution time?

Does the mysql server return to the client (DBI in this case) the query execution time? If so, how do I retrieve it? Thanks, Joe -- Joe McGuckin ViaNet Communications 994 San Antonio Road Palo Alto, CA 94303 Phone: 650-213-1302 Cell: 650-207-0372 Fax: 650-969-2124 -- MySQL General

Re: Group by and results

They should return the same values, but possibly in a different order. SELECT foo, bar, baz FROM table GROUP BY foo, bar, baz; returns the values of foo, bar, and baz, once for each unique combination, ordered by foo, bar, baz. That is, GROUP BY does a free ORDER BY. SELECT DISTINCT foo, bar,

Problem with tables;

Hi, I'm trying to create a table using the commands below, and everything seems to work and the table is there - I just can's access any of the fields. This happens on both my Windows and Linux versions of MySQL. Any help is appreciated. Note, I have 8 other databases that I created with no

AUTO_INCREMENT

Hi, Is there any way AUTO_INCREMENT column cann't me Primary key ? One table has one column auto_increment which I want to convert into non primary key but I also want to maintain the column.How to do that? thanks - Do you Yahoo!?

Problem with tables;

Just some updated info on this. It appears everything is there and working. I can update the table, do queries on the table, etc. - the only thing I can't do is a 'desc whatever' I still get the 1146 error. Thanks -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent:

About Mysql Security

Hi, Last week, the all tables in one database had been deleted, which is second times since I upgrade my operation system from NT 4.0 to Server 2003. Before that, they had been deleted many times. I just copied all table files to one database(one directory). They will work normally. I don't know

Re: Problem with tables;

Hi, I'm trying to create a table using the commands below, and everything seems to work and the table is there - I just can's access any of the fields. This happens on both my Windows and Linux versions of MySQL. Any help is appreciated. Note, I have 8 other databases that I created with no