Setting up user acounts in 4.0.16

Hi Mysql fans ;-), today I had a funny experience and I wanted to double check that. When I am trying to create a user account in the 4.0.16 -max version (tar.gz format from www.mysql.com) then it would create the user account put not set the privileges. The privileges would still stay at N.

Have one server be a master and a slave at the same time

Hi list! I have been reading the documentation about Replication. If I have a cluster composed by 2 node and I want replicate the data across the 2 nodes.Have one server be a master and a slave at the same time ? Really I have already configured this, but I want to know if there is

best practices for running 3.23 and 4.016 on the same box?

Hi all I am planning an upgrade for a very busy 3.23 server to 4.016. As we dont have a text box, I have to install both releases on the same machine, and test 4.016 for some time. For 4.016 I will unpack a tar.gz, as I dont trust rpm not to clobber at least some of the 3.23 installation. I will

Re: Setting up user acounts in 4.0.16

Hi Nils, your instruction of account creation don't agree with the syntax . To create an account do this : GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by ''; The percent character '%' is enclosed by double-quote. Regards Thierno6C - MySQL 4.0.15. - Original Message -

Re: Windows to Linux

I do this all the time at my work for really large tables. Just scp, ftp the entire data directory over to the linux box and restart the MySQL service. The only addition thing you might want to do is compress the file before sending them just so you have some way to check them and tables usually

Re: trouble replicating

Brian Keck [EMAIL PROTECTED] wrote: I'm having trouble with replication. The binary logs arrive in the slave directory, but don't get inserted into the database. I'm just a beginner at SQL mysql, in case it isn't obvious from the following. The replication is limited to a database

Re: best practices for running 3.23 and 4.016 on the same box?

Hi Mark, there is no problem to run both MySQL servers 3.23 / 4.0.16. Just pay attention to (particulary options file) : - configure two my.cnf files, each version must have it server specific options file. remarks that you cannot put the same file in the same place /etc/. Place each of them

RE: MySQL process increasing problem..

Thank you Matt, Jeremy and Gerald for helping me. It seems that the code is opening many connections. I have decreased wait_timeout and it should be better for the time being. Thanks and Regards, Shailesh Agrawal -- For sale, parachute, used once, never opened, small stain. -Original

Re: LOAD DATA hangs

But myisam_sort_buffer is, AFAIK, only used during Repair by sort (in PROCESSLIST), not Repair with keycache. What did yours say during the 21 hours? It may change from sort to keycache after awhile -- something to do with the size of the indexes or something. Not exactly sure about the

starting another server

Hello, I have two (production) databases running under the same server process. I would like to give each database its own server process. Several reasons for this, one of them I need to be able to stop/start the databases separately. What would be the easiest approach? Recompilation is not an

RE: starting another server

Would I need to create different datadirectories? Yes. See http://www.mysql.com/doc/en/Multiple_servers.html Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday 06 November 2003 11:38 To: [EMAIL PROTECTED] Subject: starting another server

keep leading 000 ?

Hi all, only small problem here (me hopes). I update a field with a value that is stored in a bash-variable. The value in the variable ($dsvar2) is like 12.. So what i want is to keep the leading and trailing 0 in the value. in the bash-scipt: /mysql -e UPDATE table SET field=$dsvar2

How to get two columns from different tables

Hello, I`m a newer reader. I have problem with query. There are two tables: tab1: id | test1 0 | string1 1 | string2 2 | string3 and tab2: id | test1 0 | string1 1 | string2 2 | string3 I want to get columns test1 (from tab1) and test2 where id.tab1 = id.tab2 but i

UPDATE with WHERE+ORDER+LIMIT error(?) - test shell script (fwd)

Description: The same test script I've submitted today to [EMAIL PROTECTED], which demonstrates improper(?) behaviour of UPDATE statement on 4.0.12 server under FreeBSD, on 4.0.15 server under Alt Linux causes segmentation fault. Below is messages from /var/log/mysql/info:

Re: How to get two columns from different tables

You're almost there in how you worded your quesiton. You'll need a join. select tab1.test1, tab2.test1 from tab1 inner join tab2 on tab1.id = tab2.id. -- this will get all columns where hte ids match. to get all ids that are 40, add a where clause. select tab1.test1, tab2.test1 from tab1 inner

Fwd: Re: Setting up user acounts in 4.0.16

Hi Thierno, you are right that the synatx I gave you is not correct. Thank you for pointing this out. I made the mistake when typing the e-mail ;-) However the original problem stays. It doesnt write the privileges (on my machine). Best regards Nils Valentin Tokyo/Japan On Thursday 06

Re: keep leading 000 -solved

Am Donnerstag, 6. November 2003 13:14 schrieb Bernd Tannenbaum: Hi all, only small problem here (me hopes). I update a field with a value that is stored in a bash-variable. The value in the variable ($dsvar2) is like 12.. So what i want is to keep the leading and trailing 0 in the

Last 75 entries from a table

Hello, Using MySQL 3.23.58, what I want is to select the last 75 entries from a table. Like so: SELECT article_num FROM $table LIMIT 75 Except, of course, that this gives me the first 75, whereas I need the last 75. It sounds trivial; and it probably is, but I could not find it. article_num, by

Re: Storing utf8 text

Hello ALL (B (B (BHow can a dataset return the default value from the database(MySQL, (BMSSQL, Interbase). (BI have try in ADO, dbx, BDE, and the result is not, (BHow Can I do? (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo

Re: Last 75 entries from a table

SELECT article_num FROM $table order by article_num DESC LIMIT 75 hth Jeff Mark

RE: Last 75 entries from a table

you could do select article_num from $table order by article_num desc LIMIT 75 -Original Message- From: Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:40 AM To: [EMAIL PROTECTED] Subject: Last 75 entries from a table Hello, Using MySQL 3.23.58, what I

Re: Removing MySQL from OS X Jaguar

The standard install of MySQL, whether from Apple or the package, puts MySQL in its own directory under /user/local. The directory MySQL is in, is named after the version of MySQL installed. For instance, mine is: mysql-standard-4.0.14-apple-darwin6.4-powerpc There is also a link to that

How can a dataset return the default value from the database(MySQL,MSSQL, Interbase).

Hello ALL (B (B (BHow can a dataset return the default value from the (Bdatabase(MySQL,MSSQL, Interbase). (BI have try in ADO, dbx, BDE, and the result is not, (BHow Can I do? (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo

Re: Last 75 entries from a table

- Original Message - From: [EMAIL PROTECTED] To: Mark [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 2:45 PM Subject: Re: Last 75 entries from a table SELECT article_num FROM $table order by \ article_num DESC LIMIT 75 Whaat? So, all I had to do is use

RE: Last 75 entries from a table

-Original Message- From: Mark [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 13:40 To: [EMAIL PROTECTED] Using MySQL 3.23.58, what I want is to select the last 75 entries from a table. Like so: SELECT article_num FROM $table LIMIT 75 Except, of course, that this gives me the

Re:Setting up user acounts in 4.0.16

Hi Nils, what want you to say by : It doesnt write the privileges (on my machine). It is because you succeed reaching all the database objects or what ? Give some more details. Regards. Thierno6C. - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: Setting up user acounts in 4.0.16

Hi Thierno, Please see below what I get. I would expect the privileges to be set to Y. GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by ''; Query OK, 0 rows affected (0.00 sec) mysql select * from user where User=xoops\G

RE: Problem with LIKE/REGEXP

What are you actually trying to match with \017? As far as I know, it's treating the \0 part as a NUL byte and trying to match that. Are you trying to match a NUL byte? Or are you trying to match ASCII 17 or something? Hello matt, i am trying to match a binary string (with binary data)

Connection speed

Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to the MySQL from the local network. It takes long time

RE: Upgrading help please

Yup that worked - I rebooted my machine - and I was allowed in - Thank you very much Andrew -Original Message- From: Brian Snyder [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 3:30 PM Cc: MySQL Subject: Re: Upgrading help please Andrew, I had the same problem and had

Re: Setting up user acounts in 4.0.16

You set db privileges, and then looked at the user table. Check the db table. If you want to set global privileges you need to specify *.* not xoops.*. Nils Valentin wrote: Hi Thierno, Please see below what I get. I would expect the privileges to be set to Y.

Re: Connection speed

Sounds like a DNS problem to me. Daniel Kiss wrote: Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to

Re: Connection speed

It is definitely not a DNS problem. I use IP addresses. Any other idea? Thanks Sounds like a DNS problem to me. Daniel Kiss wrote: Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the

Re: Setting up user acounts in 4.0.16

Hi Nils, as said Clark, looks at db table. In fact the account xoops will have full access to database 'xoops' only. Regards - Original Message - From: gerald_clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 2:23 PM Subject: Re:

Re: How to get two columns from different tables

Thanks for replay ! It works ! Other problem is to take two columns where each column is filled when it match (i.e. 40) and NULL when it doesn`t match: tab1: id | test1 0 | string1 1 | string2 2 | string3 and tab2: id | test1 5 | string1 6 | string2 7 | string3 I

RE: keep leading 000 -solved

From an old-timer: When defining a field, the basic principle is that if you don't intend to add, subtract, multiply or divide it don't make it any type of numeric field. Make it a character field. An excellent example of the problem is in an Excel spreadsheet. If you have a column that

Re: Connection speed

Try traceroute to make sure it's not a routing problem. Try netstat, or your platform's equivalent, to see if you are getting errors. You should do that on both the client and the server. Check how busy your server is, maybe there is something going on there. On Thursday, November 6, 2003, at

Re: Mysql on panther

I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031106 7:19:56

Re: Mysql on panther

My OS X does not have my.cnf anywhere on the machine. :-) Nestor A. Florez Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM Are you using Panther client or server? my.cnf is usually in /etc. Have you run mysql_install_db yet? - Gabriel On Wednesday, November 5, 2003, at 05:57 PM,

Fwd: Re: Setting up user acounts in 4.0.16

Of course. That was it ;-) I completely forgot about that for a moment. I looked in the wrong place, oooh no... Thanks a lot, (such a shame I didnt realize first)... Best regards Nils Valentin Tokyo/Japan On Thursday 06 November 2003 23:23, gerald_clark wrote: You set db privileges, and

Re: Connection speed

On Thu, Nov 06, 2003 at 02:37:05PM +, Daniel Kiss wrote: It is definitely not a DNS problem. I use IP addresses. Any other idea? Reverse DNS. The server is lookup up the client's name unless you've used skip-name-resolve. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,

Re: Mysql on panther

Nestor Florez [EMAIL PROTECTED] wrote: I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table

Re: Benchmark differences: Mac OS X - Linux

On Wed, Nov 05, 2003 at 07:57:00PM +0100, Jan Pieter Kunst wrote: Hi everyone, I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. Both installations used the same my.cnf file. The results are

RE: Mysql on panther

-Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 15:28 My OS X does not have my.cnf anywhere on the machine. :-) Copy/edit on of the my-*.cnf files from the support-files directory in the mysql distribution directory to /etc/my.cnf I

Re: Mysql on panther

Egor, Where is the datadir locate? :-) Nestor A. Florez Egor Egorov [EMAIL PROTECTED] 11/6/2003 7:40:28 AM Nestor Florez [EMAIL PROTECTED] wrote: I tried running mysql_install_db and I get: *--- # /usr/bin/mysql_install_db --force Preparing db table Preparing host

UPDATE TABLE with 32 MB string corrupts ISAM

Description: When inserting large strings into ISAM table in an UPDATE TABLE command, my perl script generates an Out of memory error. I tracked this down using an SQL script (below). It seems that a 32777225 character string is tolerated, but a string one character larger is not.

Re: Mysql Connection Problems

On Wed, Nov 05, 2003 at 03:39:03PM +1030, John wrote: HI All I was wondering if anyone could tell me how to get around this problems Error: could not connect to the database. It's possible the database itself is just not working at the moment. The admin should also check that the

Re: Mysql on panther

At 8:04 -0800 11/6/03, Nestor Florez wrote: Egor, Where is the datadir locate? :-) The message below says: Starting mysqld daemon with databases from /var/mysql Which indicates that /var/mysql is the datadir. Change location into the directory and have a look around. Try ls -la . to see

strange OS X (Panther) MySql 4.0.16 behaviour!!! HELP!!!

Hi list, I'm still trying to ascertain if this is in fact an MySql problem, here goes. I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The site is an e-commerce site (PHP 4.3). When I try and access a

RE: Connection speed

I think my mysql is resolving host names, and I would prefer it to not, where do I set skip-name-resolve to prevent it? Thanks. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:43 AM To: Daniel Kiss Cc: [EMAIL PROTECTED] Subject: Re:

RE: strange OS X (Panther) MySql 4.0.16 behaviour!!! HELP!!!

Jason, The possiblity exists that the issue is Apache. I only use 1.3 so I cannot give specific feedback. Is the PHP.ini file the same in production and as in development? Regards, Adam -Original Message- From: g4 [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 11:20 AM To:

Re: Mysql on panther

There is no my.cnf by default on OS X. Unless you want to override default compiled settings, it's not really needed. But you usually do, so you need to create your own. MySQL comes with some samples you can use. As for your problems. Your directories where everything is located look like

need a quick answer about myisamchk!!!

Very simple question: Can I use myisamchk version 2.6 (from mysql 4.0.15) to fix/repair a table from mysql version 3.23.41 (which includes myisamchk version 1.49)?? The reason is that I have more disk space and processing power on a machine with 4.0.15 installed, but I'd like to rebuild some

Re: Benchmark differences: Mac OS X - Linux

I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in

Re: Mysql on panther

[MySQL won't start] Maybe this knowledge base article is useful: http://docs.info.apple.com/article.html?artnum=107537 JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: INNODB flush holdup

Is there anything that can be done to increase the speed of a flush? Can it be run while other queries are running? The problem I'm having is that every time a flush is waiting to happen no new connections can be initiated and all my queries are on hold. If there is something long running before

Newbie - How to determine hardware requirements?

Greetings. Does anyone have any suggestions besides trial and error for determining how resource intensive my database is going to be? Is this just something the a developer just gets a feel for after developing a number of databases or are there some guidelines I can use? Thanks for any help!

Re: strange OS X (Panther) MySql 4.0.16 behaviour!!! HELP!!!

Is the live site also running Apache 2? Are they both using the same version of PHP? Panther upgrades the version of php installed as well as overwriting your httpd.conf file. I'm pretty sure Apple renames the existing copy to httpd.conf.applesaved. If you are using PEAR to handle your

Re: Benchmark differences: Mac OS X - Linux

I can't imagine a G4 would be disk bound relative to an Intel machine, unless there is something very wrong with the disk or controller. Also, you might want to defrag your disk on the Mac. G4s have much more disk bandwidth than any Intel I've ever seen. Almost as much as my DEC Alpha. :)

Re: Mysql on panther

Thanks to all the help...I got it working!!! Basically, as recommended, I created a my.cnf I also chown my /var/mysql directory to user 'mysql' and I am cooking now Thanks again!! Nestor :-) Nestor A. Florez -- MySQL General Mailing List For list archives:

Re: need a quick answer about myisamchk!!!

On Thu, Nov 06, 2003 at 08:33:55AM -0800, Henry Hank wrote: Very simple question: Can I use myisamchk version 2.6 (from mysql 4.0.15) to fix/repair a table from mysql version 3.23.41 (which includes myisamchk version 1.49)?? It should be safe, yes. -- Jeremy D. Zawodny | Perl, Web,

Re: Newbie - How to determine hardware requirements?

On Thu, Nov 06, 2003 at 10:44:04AM -0600, Paul Fine wrote: Greetings. Does anyone have any suggestions besides trial and error for determining how resource intensive my database is going to be? Is this just something the a developer just gets a feel for after developing a number of

Re: Connection speed

On Thu, Nov 06, 2003 at 09:23:50AM -0700, Nihal wrote: I think my mysql is resolving host names, and I would prefer it to not, where do I set skip-name-resolve to prevent it? In the [mysqld] section of my.cnf. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL

Re: INNODB flush holdup

On Thu, Nov 06, 2003 at 09:40:41AM -0700, Nihal wrote: Is there anything that can be done to increase the speed of a flush? Can it be run while other queries are running? Are you actually running the FLUSH TABLES command? If so, why? The problem I'm having is that every time a flush is

Re: Benchmark differences: Mac OS X - Linux

On Thu, Nov 06, 2003 at 09:56:22AM -0700, Van wrote: I can't imagine a G4 would be disk bound relative to an Intel machine, unless there is something very wrong with the disk or controller. Also, you might want to defrag your disk on the Mac. G4s have much more disk bandwidth than any

RE: INNODB flush holdup

I am running FLUSH TABLES manually. I am doing it each hour to generate a bin file, for incremental backups. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 10:05 AM To: Nihal Cc: [EMAIL PROTECTED] Subject: Re: INNODB flush holdup On

Re: Benchmark differences: Mac OS X - Linux

Jeremy: I believe that's what I was attempting to convey. My suggestion was that the G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC Alpha is a meagerly 300, but the disk can stream faster than my PIII true Intel 733MHz. That's why I suggested he look at the disk /

mysql network security

Does anyone know of a method for encrypting the network traffic to and from a mysql database running on Redhat ES 2.1? At the moment, only perl automation and php web pages are accessing the database. Many Thanks, ./Andrew

Table Creation

What is wrong with this table creation CREATE TABLE `spid_1__0` ( `recordname` varchar(255) NOT NULL default '', `data` enum NOT NULL, PRIMARY KEY (`recordname`,`data`) ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Table Creation

What is wrong with this table creation CREATE TABLE `spid_1__0` ( `recordname` varchar(255) NOT NULL default '', `data` enum NOT NULL, PRIMARY KEY (`recordname`,`data`) ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; What is the specific error you are getting? W/o knowing that information, I

Re: Table Creation

In the last episode (Nov 06), Arnoldus Th.J. Koeleman said: What is wrong with this table creation CREATE TABLE `spid_1__0` ( `recordname` varchar(255) NOT NULL default '', `data` enum NOT NULL, You didn't specify the values for your enum type. When you post questions like this, it's

Re: mysql network security

On Thu, Nov 06, 2003 at 11:41:54AM -0600, Andrew Falgout wrote: Does anyone know of a method for encrypting the network traffic to and from a mysql database running on Redhat ES 2.1? At the moment, only perl automation and php web pages are accessing the database. You could tunnel your

Re: Benchmark differences: Mac OS X - Linux

On Thu, Nov 06, 2003 at 10:19:59AM -0700, Van wrote: Jeremy: I believe that's what I was attempting to convey. My suggestion was that the G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC Alpha is a meagerly 300, but the disk can stream faster than my PIII true

Re: mysql network security

Thanks for the quick response. I've never setup an ipsec before. I have been toying with the idea of using cipe to create a PPTP virtual network for the server to talk on. But the time to work on this project has not presented itself as of yet. I was wondering if there was an interface within

Re: mysql network security

On Thu, Nov 06, 2003 at 11:41:54AM -0600, Andrew Falgout wrote: Does anyone know of a method for encrypting the network traffic to and from a mysql database running on Redhat ES 2.1? At the moment, only perl automation and php web pages are accessing the database. MySQL 4.0 and up have

Re: mysql network security

Well, you would only need to setup a single ssh tunnel. All your different apps could then use the single tunnel. You could even setup RSA authentication so that it could start manually with no password entering required. Have it automatically come up on boot, etc. MySQL has no encryption

Simple question about updating a table field

I have a numeric table field, named CREDIT. How can I add a number (+50) to that field for all the table record ? is this correct? UPDATE ThisTable SET CREDIT=CREDIT+50 Please help, Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

select statement with multiple databases

Hello all, I am fairly new to MySQL. I have a problem, that I have not been able to figure out. I've tried searching the net and reading the manual, but all to no avail. I have two databases (A and B) which have the same structure but different field names. The code from mysqldump follows

Re: Benchmark differences: Mac OS X - Linux

On Thursday, November 6, 2003, at 11:38 AM, Jan Pieter Kunst wrote: I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl

Re: Benchmark differences: Mac OS X - Linux

Jeremy D. Zawodny: I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to be disk or CPU bound? Sorry, newbie here. I don't know how I can tell. The

Re: Benchmark differences: Mac OS X - Linux

I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in Jaguar) so I can't run the benchmark suite for now. JP I had similar issues, but I was also using a custom build of MySQL,

ROWID

Hi there, Both Oracle and Informix use ROWID to uniquely represent the location of each row of data in a table. ROWID is basically a hidden column or pseudocolumn for each table, and it is the fastest way to retrive a row from a table. Does MySql have similar field? If is, what's the name and

[jp] connection from MSSQL

Hi everybody.! can i use openrowset from MS-SQL SERVER to connect to mysql server ??? how can i doing it? pls. thank you. pta: my english is poor... sorry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Processes Closed, but max_connections exceeded...

Ladies and Gents; I've got a question for you. I've got a MySQL db running in FreeBSD 4.8, and have encountered the following problem. When I try to connect to a database by a specific user, I get the following response : #mysql -p -u comet Enter password: ERROR 1226: User 'comet' has

MySQL List Digest ???

Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get it to happen. I have cancelled my sub and re-sub'd choosing the

This is confusing..?

Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10) NOT NULL default '', raws int(11) unsigned NOT NULL default '0',

Re: select statement with multiple databases

On Thu, Nov 06, 2003 at 10:36:08AM -0800, Jay Frumkin wrote: Hello all, I am fairly new to MySQL. I have a problem, that I have not been able to figure out. I've tried searching the net and reading the manual, but all to no avail. I have two databases (A and B) which have the same

Compiling MySQL 4

I am trying to compile MySQL 4.x on a Red Hat 8.0 but I'm getting the following error /usr/bin/ld: cannot find -lreadline collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/usr/src/mysql/mysql-4.0.16/client' make[1]: *** [all-recursive] Error 1 make[1]:

Re: [jp] connection from MSSQL

Hi Jorge, Hum! you should use MySQL Control Center (AKA mysqlcc)? You will not have to worry about configuring (I do not think it is feasible) openrowset fo connect to MySQL. Regards, Bernard On Thursday 06 November 2003 13:43, Jorge Paiva (f2) wrote: Hi everybody.! can i use openrowset

RE: This is confusing..?

I seem to remember someone saying that if a query would end up returning more than x% of a table (I think it was either 30% or 50%), then mysql just ends up doing a full scan regardless... -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06,

RE: This is confusing..?

Can you send show keys from campaign_t. I bet you can solve your problem by running analyze table. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: Eric Anderson [mailto:[EMAIL PROTECTED]

relationships

Hi, is there a way of showing relationships in mysql? such as. mysql SHOW relationships Bob

Re: This is confusing..?

At 11:08 -0800 11/6/03, Eric Anderson wrote: Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10) NOT NULL default '', raws

RE: This is confusing..?

Can you send show keys from campaign_t. I bet you can solve your problem by running analyze table. What's the syntax for 'show keys'? -- -- Eric Anderson - ICQ: 3849549 - San Diego, CA [EMAIL PROTECTED] | Mac and Bumble

Re: Benchmark differences: Mac OS X - Linux

On Thu, Nov 06, 2003 at 07:36:55PM +0100, Jan Pieter Kunst wrote: Jeremy D. Zawodny: I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to

Re: This is confusing..?

mysql explain SELECT * FROM campaign_t WHERE datestamp 20041105\g Try surrounding the value with quotes, i.e.: explain SELECT * FROM campaign_t WHERE datestamp '20041105' -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL List Digest ???

On Thu, Nov 06, 2003 at 12:52:21PM -0600, Paul Fine wrote: Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get

Re: This is confusing..?

Possibly because datestamp and 20041105 have different datatypes. There's an implicit data conversion required for the comparison, which in some cases prevents use of an index. Try writing '20041105' rather than 20041105 and see if that makes a difference. Nope.. :-/ mysql explain SELECT *

Re: This is confusing..?

On Thu, Nov 06, 2003 at 11:08:03AM -0800, Eric Anderson wrote: Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10)

Re: Compiling MySQL 4

On Thu, Nov 06, 2003 at 01:01:47PM -0600, Luis Lebron wrote: I am trying to compile MySQL 4.x on a Red Hat 8.0 but I'm getting the following error /usr/bin/ld: cannot find -lreadline collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory

  1   2   >