help.....stored procedure

Hi All, Im using MySQL 5.0 and my problem is I am not able to call a procedure more than once..Its working fine during 1st call..From the 2nd call onwards it vil give some error like "ERROR 1172 (42000): Result consisted of more than one row "IA sinilar problem can be found in "http://bugs.my

Re: MySQL 4.1.9 - Requesting Optimization Tips

At 19:44 -0800 2/17/05, Matt Florido wrote: Paul DuBois wrote: At 19:21 -0800 2/17/05, Matt Florido wrote: I'm wondering if anyone can provide any tips as to how to conserve resources. Currently, I see 10 instances of mysqld running. Each instance is approximately 18MB. For my application of My

Re: MySQL 4.1.9 - Requesting Optimization Tips

Paul DuBois wrote: At 19:21 -0800 2/17/05, Matt Florido wrote: I'm wondering if anyone can provide any tips as to how to conserve resources. Currently, I see 10 instances of mysqld running. Each instance is approximately 18MB. For my application of MySQL, I don't require a large amount of reso

Re: MySQL 4.1.9 - Requesting Optimization Tips

At 19:21 -0800 2/17/05, Matt Florido wrote: I'm wondering if anyone can provide any tips as to how to conserve resources. Currently, I see 10 instances of mysqld running. Each instance is approximately 18MB. For my application of MySQL, I don't require a large amount of resources allocated to

MySQL 4.1.9 - Requesting Optimization Tips

I'm wondering if anyone can provide any tips as to how to conserve resources. Currently, I see 10 instances of mysqld running. Each instance is approximately 18MB. For my application of MySQL, I don't require a large amount of resources allocated to mysqld. 7085 mysql 16 0 90060 17m 2

Need older version of mysql (current version seeminly corrupts FTS tables)

I have replaced one server with another, and the new one has everything new (RHEL 3, newest updates) and MySQL 4.0.23 (old one was RH9 and MySQL 4.0.18). We now get table corruptions constantly (it only takes a minute before several tables get marked as crashed). I'd like to revert to the 4.0.18 v

Re: select only values >0

> Dear All, from a single row of a table, I have to select only the column, > which have a value larger '0' into an outfile. > How can I manage it with 'select'? Thanks, Jan SELECT CASE can do that sort of thing for you. Here's a simplistic example: CREATE TABLE `test` ( `i1` int,

Re: Data Types in Mysql

in the docs - column types: http://dev.mysql.com/doc/mysql/en/column-types.html Respectfully, Ligaya Turmelle Mohsen Pahlevanzadeh wrote: Dear,I need to MySQL data type or another. But i dont know name of their header file. Please guide me.. Yours,Mohsen -- MySQL General Mailing List For list

one long lived connection or many short lived?

Hi, I apologize in advance, I am sure this question has been asked dozens of times, but my searches came up empty. I am building an IRC based application "bot" (using libmysql) .. that will take commands from users (!mybugs, !mybugs KEY !newbugs, etc), do SQL queries and of course dump formatte

Re: Header files & data types

Depnding on how your mysql was installed, you should have mysql.h on your system somewhere; perhaps in /usr/include/mysql or elsewhere depending on installation parameters.. If not, you can download libraries and headers appropriate to your system version from http://dev.mysql.com/downloads/ On

Query problem

Hi I have a problem with a query that has many joined tables. The query brings back 80 records instead of just one. Any suggestions on how I can overcome this? Many thanks Richard Query below:- SELECT * FROM (main_data INNER JOIN main_data_facilities ON main_data_facilities.RecNo = m

Re: UNIX_TIMESTAMP function

SELECT unix_timestamp(mydatetime), ... from mytable where DAYNAME(mydatetime) is not in('Saturday','Sunday'); On Thu, 2005-02-17 at 16:34, Jerry Swanson wrote: > How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday? -- - michael dykman - [EMAIL PROTECTED] -- MySQL Gener

UNIX_TIMESTAMP function

How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql running as root

Hi Russ! Am Do, den 17.02.2005 schrieb Russ um 18:05: > [[...]] > > I am using SuSE 9.1 Pro. I started mysql in the runlevel editor of YaST. It > start when I boot the system. > > below are the results of the two items you asked me to look at: > > ps aux > mysql 5471 0.0 0.4 21584 2400

Weird "@" in column name

I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the strangest error: mysql> use devmail Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select type_name from faq_type; +--

Re: MySQL and DNS problem

On Thursday 17 February 2005 12:29 pm, Ian Meyer wrote: > > You have a server thats on DHCP? Well, your problem is dhcp I am sure.. > > But good luck with that horror flick. > > Our servers IPs are static, as is the DNS in /etc/resolv.conf Then you need to make sure its compiled to the right glib

Re: MySQL and DNS problem

John Trammell wrote: You can specify a wildcard in the host IP, eg. grant select on mydb.* to 'someuser'@'192.168.2.%' ... which you can use to get around your DHCP issue until host lookups are fixed. Host lookups aren't broken using the `host` command.. only when MySQL goes to look them up, whi

Re: MySQL and DNS problem

Jeff Smelser wrote: On Thursday 17 February 2005 11:46 am, Ian Meyer wrote: I wish we could do that, however, it's not an option as we use DHCP.. so the IP's change, yet the hostname does not. Besides, that's just a cheap way to avoid fixing the problem when it should work to begin with. Our acces

Header files & data types

Dears,I must use data type in C++,same MySQL type. But i don't name of their header files. Please guide me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and DNS problem

On Thursday 17 February 2005 11:46 am, Ian Meyer wrote: > I wish we could do that, however, it's not an option as we use DHCP.. so > the IP's change, yet the hostname does not. Besides, that's just a cheap > way to avoid fixing the problem when it should work to begin with. Our > access tables are

RE: MySQL and DNS problem

You can specify a wildcard in the host IP, eg. grant select on mydb.* to 'someuser'@'192.168.2.%' ... which you can use to get around your DHCP issue until host lookups are fixed. > -Original Message- > From: Ian Meyer [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 17, 2005 11:4

Data Types in Mysql

Dear,I need to MySQL data type or another. But i dont know name of their header file. Please guide me.. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: JOIN Problem

On Feb 17, 2005, at 10:34 AM, [EMAIL PROTECTED] wrote: Albert Padley <[EMAIL PROTECTED]> wrote on 02/17/2005 12:08:31 PM: > I have the following 2 tables: > > CREATE TABLE `division_info` ( >    `id` int(11) NOT NULL auto_increment, >    `division` varchar(50) NOT NULL default '', >    `spot

Re: What is the max length of IN() function?

Donny Simonton wrote: In our case we were using words, and phrases, so we would have something like: IN ('a', 'apple', 'apple car', 'car', 'c') etc... We found that once it hits about 200 or so entries the query went from 0.00 seconds to about 2-3 seconds. Sometimes much more. I would guess that

Re: JOIN Problem

Michael Dykman <[EMAIL PROTECTED]> wrote on 02/17/2005 12:20:44 PM: > On Thu, 2005-02-17 at 12:08, Albert Padley wrote: > > I have the following 2 tables: > > > > CREATE TABLE `division_info` ( > >`id` int(11) NOT NULL auto_increment, > >`division` varchar(50) NOT NULL default '', > >

Re: MySQL and DNS problem

Jeff Smelser wrote: On Thursday 17 February 2005 09:41 am, Ian Meyer wrote: When trying to connect, it fails with the message: 'MySQL Error Number 1045 Access denied for user 'user'@'192.168.2.103' (using password: YES' The 192.168.2.103 is your tip that its not using a host. grant [EMAIL PROTEC

Re: JOIN Problem

The idea of the OUTER JOIN is that it find at least one row for the joined table, even if the conddtion for that tables fails.. the resulting row will have all nulls except for the connecting fields. it guarantees that every row of division_info which is returned by the first part of the query is

Re: MySQL and DNS problem

Michael Dykman wrote: On Thu, 2005-02-17 at 12:21, Ian Meyer wrote: Michael Dykman wrote: On Thu, 2005-02-17 at 10:41, Ian Meyer wrote: Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command. Example: cre

Re: JOIN Problem

Albert Padley <[EMAIL PROTECTED]> wrote on 02/17/2005 12:08:31 PM: > I have the following 2 tables: > > CREATE TABLE `division_info` ( >`id` int(11) NOT NULL auto_increment, >`division` varchar(50) NOT NULL default '', >`spots` int(11) NOT NULL default '0', >PRIMARY KEY (`id`), >

Re: MySQL and DNS problem

On Thursday 17 February 2005 09:41 am, Ian Meyer wrote: > When trying to connect, it fails with the message: > 'MySQL Error Number 1045 > Access denied for user 'user'@'192.168.2.103' (using password: YES' The 192.168.2.103 is your tip that its not using a host. grant [EMAIL PROTECTED] and thing

Re: MySQL and DNS problem

On Thu, 2005-02-17 at 12:21, Ian Meyer wrote: > Michael Dykman wrote: > > On Thu, 2005-02-17 at 10:41, Ian Meyer wrote: > > > >>Hello everyone, > >> > >>We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having > >>problems when trying to use hostnames in the grant command. > >> > >

Problem with SUM and DECIMAL field

Hi everyone, I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9. Now I have a problem when using the SUM operator on DECIMAL field. The value returned by the SUM operator when used with DECIMAL field has a coma (,) as decimal separator while it used to be have a dot (.) . If I

Re: JOIN Problem

Would you mind giving me some additional explanation about outer join? In the mysql reference book I just found one line saying "left outer join syntax exists only for compatibility with odbc". thanks! From: Michael Dykman <[EMAIL PROTECTED]> To: Albert Padley <[EMAIL PROTECTED]> CC: "\"MySQL Lis

Re: Mysql running as root

The line: MySQL 4.0.18 running on localhost as [EMAIL PROTECTED] refers to the hostname and user you log into *mysql* with. It does not tell you what user mysql is running under on the OS. The user and hostname that phpMyAdmin logs in under are changed in the phpMyAdmin config.inc.php file. Kri

Re: MySQL and DNS problem

Michael Dykman wrote: On Thu, 2005-02-17 at 10:41, Ian Meyer wrote: Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command. Example: create database blah; grant all on blah.* to 'user'@'host' identified by

Re: JOIN Problem

On Thu, 2005-02-17 at 12:08, Albert Padley wrote: > I have the following 2 tables: > > CREATE TABLE `division_info` ( >`id` int(11) NOT NULL auto_increment, >`division` varchar(50) NOT NULL default '', >`spots` int(11) NOT NULL default '0', >PRIMARY KEY (`id`), >KEY `division`

Re: MySQL and DNS problem

On Thu, 2005-02-17 at 10:41, Ian Meyer wrote: > Hello everyone, > > We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having > problems when trying to use hostnames in the grant command. > > Example: > create database blah; > grant all on blah.* to 'user'@'host' identified by 'xxx

Re: select only values >0

You can't conditionally select columns with a mere select statement.. In whatever langauge you are using to process (perl, Java, whatever) you are going to have to select the entire row and use locig to pick out the columns that you want - michael dykman On Thu, 2005-02-17 at 11:44, Jan Bartho

Re: Using Different Database Groups On the Same Computer

On Thursday 17 February 2005 11:48 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > mysqld --port=3307 --datadir=/dbtest/mysql > > mysqld --port=3306 --datadir=/var/lib/mysql > > mysql --port=3307 > > mysql --port=3306 > > > > When I do this, then do a "show databases;" in either new instance o

JOIN Problem

I have the following 2 tables: CREATE TABLE `division_info` ( `id` int(11) NOT NULL auto_increment, `division` varchar(50) NOT NULL default '', `spots` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `division` (`division`), KEY `spots` (`spots`) ) TYPE=MyISAM CREATE TABLE `team_

Re: Mysql running as root

On Wednesday 16 February 2005 08:48 pm, Gleb Paharenko wrote: > Hello. > > Please tell us, in what way do you launch your MySQL server. > Send your configuration file. > > > sql running as root. When I log on as root and look at the users, I do > > not see a mysql user. Do I need to create this use

Re: MySQL and DNS problem

Tom Crimmins wrote: On Thursday, February 17, 2005 10:26, Ian Meyer wrote: Tom Crimmins wrote: On Thursday, February 17, 2005 09:41, Ian Meyer wrote: Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command.

RE: MySQL and DNS problem

On Thursday, February 17, 2005 10:26, Ian Meyer wrote: > Tom Crimmins wrote: >> On Thursday, February 17, 2005 09:41, Ian Meyer wrote: >> >>> Hello everyone, >>> >>> We have a few MySQL servers (4.1.8) running on RedHat ES3. We're >>> having problems when trying to use hostnames in the grant com

Re: Using Different Database Groups On the Same Computer

Hal Vaughan wrote: mysqld --port=3307 --datadir=/dbtest/mysql mysqld --port=3306 --datadir=/var/lib/mysql mysql --port=3307 mysql --port=3306 When I do this, then do a "show databases;" in either new instance of mysql (both are open at the same time, in separate consoles), I get the databases in

select only values >0

Dear All, from a single row of a table, I have to select only the column, which have a value larger '0' into an outfile. How can I manage it with 'select'? Thanks, Jan Virus checked by G DATA AntiVirusKit Version: AVK 15.0.2975 from 09.02.2005 -- MySQL General Mailing List For lis

Re: Using Different Database Groups On the Same Computer

On Thursday 17 February 2005 10:56 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > I see that, but even when I bypass them, I can run 2 instances of mysqld, > > it shows up in the task list as 2 separate tasks, but they both use the > > data directory specified in the last instance I run. > >

Re: MySQL and DNS problem

Tom Crimmins wrote: On Thursday, February 17, 2005 09:41, Ian Meyer wrote: Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command. Example: create database blah; grant all on blah.* to 'user'@'host' identif

RE: MySQL and DNS problem

On Thursday, February 17, 2005 09:41, Ian Meyer wrote: > Hello everyone, > > We have a few MySQL servers (4.1.8) running on RedHat ES3. We're > having problems when trying to use hostnames in the grant command. > > Example: > create database blah; > grant all on blah.* to 'user'@'host' identifie

Re: Mysql running as root

On Wednesday 16 February 2005 08:48 pm, Gleb Paharenko wrote: > Hello. > > Please tell us, in what way do you launch your MySQL server. > Send your configuration file. > > > sql running as root. When I log on as root and look at the users, I do > > not see a mysql user. Do I need to create this use

Re: Using Different Database Groups On the Same Computer

http://dev.mysql.com/doc/mysql/en/multiple-unix-servers.html There may be some helpful notes there. How are you determining which datadir mysqld is using when it's actually running? Are you logging in with mysql or mysqladmin? Make sure that if you are doing so, that you're actually logging i

Re: Using Different Database Groups On the Same Computer

Hal Vaughan wrote: I see that, but even when I bypass them, I can run 2 instances of mysqld, it shows up in the task list as 2 separate tasks, but they both use the data directory specified in the last instance I run. Uh, that doesn't really make sense -- a *running* instance isn't going to switc

Re: is DELETE QUICK supported in 3.22.32?

I've determined it is not supported. Thx. -- Jim --- Jim Hoadley <[EMAIL PROTECTED]> wrote: > Is DELETE QUICK supported in MySQL version 3.22.32? > > -- Jim > > > > > > > > __ > Do you Yahoo!? > Yahoo! Mail - You care about security.

MySQL and DNS problem

Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command. Example: create database blah; grant all on blah.* to 'user'@'host' identified by ''; (also have used the FQDN instead of just host) When trying

Re: LOAD INDEX INTO CACHE problem

Hello there. OK I'll paste the results of commands you asked right after my reply, because we found out where the problem comes from. The myisamchk command showed that the index on the VarChar has a block size of 2048 instead of 1024. However, when I turn this index to a FULLTEXT one, the block si

Re: Using Different Database Groups On the Same Computer

On Thursday 17 February 2005 10:18 am, Hassan Schroeder wrote: > Hal Vaughan wrote: > > I've tried this by running 2 instances of mysqld, the first with no > > arguments, and the second like this: > > > > mysqld --port=3307 --datadir=/dbtest/mysql > > > > I have to run mysqld directly -- not throug

Re: Using Different Database Groups On the Same Computer

Hal Vaughan wrote: I've tried this by running 2 instances of mysqld, the first with no arguments, and the second like this: mysqld --port=3307 --datadir=/dbtest/mysql I have to run mysqld directly -- not through safe_mysqld (which /etc/init.d/mysql calls). If I run it through safe_mysqld, I can

Re: Subquery problems

Roger Baklund wrote: Try something like this: SELECT ID,NAME,COUNT(*) FROM tableA LEFT JOIN tableB ON tableA.ID = tableB.ID GROUP BY ID,NAME Nope, sorry, that won't work, ID exists in both tables thus it must be prefixed with table name or alias: SELECT tableA.ID,... GROUP BY tableA.ID,

Re: Subquery problems

Joppe A wrote: hello all, I am a newbe working with MySQL. I have a problem that I can't figure out how to do. I have 2 tables that I want to take out data from, the tables looks like below. tableA == ID VARCHAR(12) NAMEVARCHAR(255) CREATED TIMESTAMP tableB ==

Re: Subquery problems

"Joppe A" <[EMAIL PROTECTED]> wrote on 02/17/2005 09:45:31 AM: > hello all, > I am a newbe working with MySQL. > I have a problem that I can't figure out how to do. > > I have 2 tables that I want to take out data from, the tables looks > like below. > > tableA > == > ID VARCHA

Re: select where multiple joined records match

I am guessing the long duration is caused by having to do complete table scans. How big is your dataset? What about creating another index in resource_goals that includes GoalNumber and ResourceID? Perhaps even Subject, Grade, and NumericGrade As I learned just a couple days ago, making sur

Subquery problems

hello all, I am a newbe working with MySQL. I have a problem that I can't figure out how to do. I have 2 tables that I want to take out data from, the tables looks like below. tableA == ID VARCHAR(12) NAMEVARCHAR(255) CREATED TIMESTAMP tableB == USER_ID

Re: mysql heartbeat

Hi Pete, Zabbix looks pretty nice... does it allow you to get insight into currently running apps, such as checking on the health of individual tables within a db? ~mathew Pete Moran wrote: A monitoring solution which can monitor mysql as well as pretty much any service on nix and win platforms

Re: Left join results - can we make it produce at most 1 row?

Joshua Beall wrote: "Wolfram Kraus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Use GROUP BY with GROUP_CONCAT: http://dev.mysql.com/doc/mysql/en/group-by-functions.html Thanks, I'll take a look and see if I can figure that out. I wasn't aware of the GROUP_CONCAT function; it

Re: Left join results - can we make it produce at most 1 row?

"Wolfram Kraus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Use GROUP BY with GROUP_CONCAT: > http://dev.mysql.com/doc/mysql/en/group-by-functions.html Thanks, I'll take a look and see if I can figure that out. I wasn't aware of the GROUP_CONCAT function; it looks like that

Re: Left join results - can we make it produce at most 1 row?

Joshua Beall wrote: Hi All, I have two tables in a children's program registration system, parent and child. 1 row in the parent table corresponds to 1 or more rows in the child table. Right now, when I do SELECT * FROM parent LEFT JOIN child ON parent.ID = child.parentID I get multiple rows fo

Left join results - can we make it produce at most 1 row?

Hi All, I have two tables in a children's program registration system, parent and child. 1 row in the parent table corresponds to 1 or more rows in the child table. Right now, when I do SELECT * FROM parent LEFT JOIN child ON parent.ID = child.parentID I get multiple rows for each parent if

Re: Filtering a date/time out of timestamp

Thanks to both of you, here is my string: select * from test where date(now())=substring(date,1,10); :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: EXPLAIN: Select tables optimized away

O I see... I read this in MySQL Manual... I believe it's something like SHOW TABLE STATUS LIKE 'table_name' And then extract the number of rows... I never saw "Select tables optimized away" and it confused me ! Gabriel PREDA - Original Message - From: "O'K Web Design" <[EMAIL PROTECT

RE: Filtering a date/time out of timestamp

[snip] I have been trying to figure out a way to filter a date out of timestamp to no success. How do I filter out specific critieria that I need using now()? [/snip] http://www.mysql.com/substring WHERE now() = substring(dateTimeColumnName, 1, 8) should get it -- MySQL General Mailing List F

Filtering a date/time out of timestamp

I have been trying to figure out a way to filter a date out of timestamp to no success. How do I filter out specific critieria that I need using now()? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: EXPLAIN: Select tables optimized away

Hi Counts are extremely fast and since you have no WHERE statement, it takes the count value straight from the internals and does not look at the tables or an index if I remember correctly. Mike - Original Message - From: "Gabriel PREDA" <[EMAIL PROTECTED]> To: Sent: February 17,

RE: EXPLAIN: Select tables optimized away

Gabriel, I think it means that this count can be done from an index, so there's no need to access the actual table at all. Andy > -Original Message- > From: Gabriel PREDA [mailto:[EMAIL PROTECTED] > Sent: 17 February 2005 11:16 > To: mysql@lists.mysql.com > Subject: EXPLAIN: Select table

EXPLAIN: Select tables optimized away

MySQL 4.1.10 What does "Select tables optimized away" mean ? mysql> explain SELECT COUNT(*) AS total FROM members_twining_main; | 1 | SIMPLE | NULL | NULL | NULL | NULL |NULL | NULL | NULL | Select tables optimized away | Gabriel PREDA -- MySQL General Mailing List For li

Re: query performance

If you do I suggest you also include relevant table definitions and possibly a little sample data (plus an indication of total table sizes) and expected output, this will greatly assist anyone who my be able to help. Oh yes, and don't forget to state the version of MySQL you are running. Coz On

Re: "collate latin1_general_ci" Error

Hello. > I just installed a new software package that included > a MySQL upgrade. What exact version of MySQL do you use? > Also, I noticed that when I create tables, I no longer > have a choice for InnoDB, so I've been choosing > MyISAM. If I leave it at default, what kind of table >

Re: 4.1.7 Character set problem ( Ithink?)

Hello. The value of the character_set_system in this case doesn't have affect in this case. You table has latin2 as default character set, and all your character_set_xxx variables have a latin1 value. "Ian Gibbons" <[EMAIL PROTECTED]> wrote: > On 12 Feb 2005 at 14:09, Gleb Paharenk

Re: select last row

Hello. This is a frequently asked question in the list. See for example: http://lists.mysql.com/mysql/176753 "Mulley, Nikhil" <[EMAIL PROTECTED]> wrote: > Hi All, > I have a table which is being continuosly updated, I just wanted to know = > how to output only the last row with the

Re: Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

Hello. Have you done a FLUSH PRIVILEGES after granting the rights to the slave user (not needed if you used GRANT clause). I didn't see this statement in your previous message? Do you execute a 'RESET SLAVE' on your slave host, when you make another attempt to setup the replication? Doe

Re: LOAD DATA INFILE Opposite

Hello. Use 'SELECT INTO OUTFILE ...' See: http://dev.mysql.com/doc/mysql/en/select.html "shaun thornburgh" <[EMAIL PROTECTED]> wrote: > Hi, > > The following function loads data from a file: > > http://dev.mysql.com/doc/mysql/en/load-data.html > > Is there a function like th

Re: Mysql running as root

Hello. Please tell us, in what way do you launch your MySQL server. Send your configuration file. > sql running as root. When I log on as root and look at the users, I do not > see a mysql user. Do I need to create this user and what permissions does it Log on into the server and use 'ps

Re: Dual Xeon EM64T fedora3 x86_64

Hello. Try -m command line option to see all threads. >Paul Chinen - NB <[EMAIL PROTECTED]> wrote: > Hello, > I just installed MySQL-server-4.0.23-0.x86_64.rpm on Dual Xeon 3.2 64 > bit 8G of RAM with Fedora3 x86_64. I noticed (doing a ps ax|grep mysql) > that there is only one mysqld

Re: is DELETE QUICK supported in 3.22.32?

Hello. Look likes no, because the grammar of DELETE statement doesn't provide this option. See sql/sql_yacc.yy source file. Jim Hoadley <[EMAIL PROTECTED]> wrote: > Is DELETE QUICK supported in MySQL version 3.22.32? > > -- Jim > > > > > > > >

Re: LOAD INDEX INTO CACHE problem

Hello. Please send us output of the following statements: SHOW CREATE TABLE your_table; SHOW VARIABLES; SHOW STATUS; What output does the following command produce: myisamchk -d -v your_table HMax <[EMAIL PROTECTED]> wrote: > Hello there, > > We have a problem with th

Re: auto_increment=0

Hello. Use the NO_AUTO_VALUE_ON_ZERO sql mode. See: http://dev.mysql.com/doc/mysql/en/server-sql-mode.html Philippe Rousselot <[EMAIL PROTECTED]> wrote: > hi, > > I am migrating a DB having a table with a UID not_null autoincrement > > the original table starts at UID=0 >

Re: Mysql running as root

Hi Russ! Am Mi, den 16.02.2005 schrieb Russ um 18:58: > I have two questions: > 1) I'm still having trouble getting mysql to run as user mysql. All the file > and folders have been changed to be owned by user mysql but phpadmin shows my > sql running as root. When I log on as root and look at t