Hi,
Did you run the bin/mysql_fix_privilege_tables script? This is
documented in the upgrade procedures on the website under the
installation chapter.
Regards
---
** _/ ** David Logan
*** _/ ***
Hi listers
1.
i did the upgrad as i usually did so far:
/etc/init.d/mysql stop
rpm -U MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
rpm -U MySQL-client-standard-5.0.18-0.rhel3.i386.rpm
rpm -U MySQL-shared-standard-5.0.18-0.rhel3.i386.rpm
from then on: no chance to enter the database via whateve
If say something like the following from the mysql command line tool:
SELECT * FROM dognames INTO OUTFILE 'C:/outfiles/dognames.tab';
How do I get mysql to include the column names in the file's output?
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Grant Giddens wrote:
> Hi,
>
> I'm using mysql 4.1.14 and and getting this error:
>
> Column 'asin' in field list is ambiguous
>
> This is the query that is giving me the error:
>
> SELECT pn_pricecompare_searchdata.prod_id,
> MATCH (asin,upc,...) AGAINST ('warcraft' IN BOOLEAN MODE) AS
je killen wrote:
Is there a version of MySQL for FreeBSD v6.0 AMD64 compatible? I
haven't seen one explicitly on the MySQL site
and I don't know if it is a good idea to try and compile and install
from source code for this machine.
Install mysql from FreeBSD ports collection. I'm running MySQL 5
Hi,
I'm using mysql 4.1.14 and and getting this error:
Column 'asin' in field list is ambiguous
This is the query that is giving me the error:
SELECT pn_pricecompare_searchdata.prod_id, MATCH
(asin,upc,isbn,ean,title,brand,manufacturer,mpn,model,artist,author,platform,format,label,studio,pu
Is there a version of MySQL for FreeBSD v6.0 AMD64 compatible? I
haven't seen one explicitly on the MySQL site
and I don't know if it is a good idea to try and compile and install
from source code for this machine.
Thanks
JK
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
Sheeri,
The table I'm searching on has a composite primary key since it's mapping an
N:M relationship between Cases and Sizes.
Here's the create statement for the table I'm searching on:
DROP TABLE IF EXISTS `CaseType_has_Sizes`;
CREATE TABLE `CaseType_has_Sizes` (
`CaseType_idCaseType` int(10
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kishore Jalleda wrote:
| do you have a bind-address = option set in your my.cnf file,
You're a genius! Thanks much.
It was, indeed, a bind problem. I'm now back. You have no idea how much
I appreciate the help. Thanks again.
-BEGIN PGP SIGN
Hi,
I have two different servers each running mysql. One is a SuSE and the other
a FreeBSD system.
mysql --version returns:
mysql Ver 12.22 Distrib 4.0.26, for portbld-freebsd5.4 (i386)
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)
On the SuSE system the following command returns this:
why do you want to limit the sockets to a dozen, the sockets are
created/closed dynamically depending on the current connections from
clients, so if your server is not servicing many clients they will
automatically be reduced , also in your case is this a slave??? , as the src
and dest ip's look to
do you have a bind-address = option set in your my.cnf file,
also do you have a properly configures loopback address/addresses,
what OS are you running ,
if possible do a system call trace for mysqld_safe with #strace or
#truss, that might give some hint,
also just double-check
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kishore Jalleda wrote:
We're at least thinking in the same terms.
| see if there is a /tmp/mysql.sock file,
Doesn't exist.
| is there a mysqld process running (#ps -ef),
This was the first thing I checked. No, no mysqld running
also you could us
Netstat -a shows the following:
tcp0 0 iepm-bw.slac.stanford:54335 iepm-bw.slac.stanford.:1000
TIME_WAIT
tcp0 0 iepm-bw.slac.stanford:54334 iepm-bw.slac.stanford.:1000
TIME_WAIT
tcp0 0 iepm-bw.slac.stanford:54333 iepm-bw.slac.stanford.:1000
TIME_WAIT
tcp
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| That happens sometimes. Do a mysqladmin shutdown and then try to
restart it. It should start just fine.
|
I ran mysqladmin shutdown which reported that it couldn't connect to the
mysql server (not surprising - the problem
I get the following:
ERROR 1045 (28000): Access denied for user
'dba'@'XP0406OEM' (using password: YES)
Did you do FLUSH PRIVILEGES as root after you performed the GRANT?
I don't think that's the problem. You only need to FLUSH PRIVILEGES
when you update the privilege tables directly. When
see if there is a /tmp/mysql.sock file, is there a mysqld process
running (#ps -ef), also you could use #netstat -a to see if there is a
process utilizing port 3306, also has there been any file corruption due to
the outage ( #fsck), does the rest of the machine work well as expected, try
a reboot
That happens sometimes. Do a mysqladmin shutdown and then try to restart it.
It should start just fine.
--ja
On Wed, 8 Feb 2006, Michael Satterwhite wrote:
> I use a local MySQL server (we're using 4.0) for development. It's been
> running cleanly for months - and the configuration file has
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I use a local MySQL server (we're using 4.0) for development. It's been
running cleanly for months - and the configuration file has not changed.
This morning we had a major power problem causing the machine to come
down in an unorderly manner. I can n
On Wed, 2006-02-08 at 11:37 -0600, John Doneker wrote:
> I was instructed to create my own userid comparable to root.
> So...
> 1. I decided to call my new userid dba.
> 2. I signon to the bugs (Bugzilla) database as root:
> 3. Then I did the following for the server level:
> mysql> grant all pr
"John Doneker" <[EMAIL PROTECTED]> wrote on 02/08/2006 12:37:01
PM:
> I was instructed to create my own userid comparable to root.
> So...
> 1. I decided to call my new userid dba.
> 2. I signon to the bugs (Bugzilla) database as root:
> 3. Then I did the following for the server level:
> mysql>
I was instructed to create my own userid comparable to root.
So...
1. I decided to call my new userid dba.
2. I signon to the bugs (Bugzilla) database as root:
3. Then I did the following for the server level:
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by ''
with gran
Dear listmembers
I am using MySQL 4.0.25.
I am trying to figure out how indexes should be defined to make the
following query as fast as possible (i.e. use indexes):
(shell script, for copy/paste)
echo "DROP TABLE IF EXISTS lrows;" | mysql test
echo "
CREATE TABLE IF NOT EXISTS lrows (
lock_id
Could you post the error log entries from the slave and the binlog where the
slave hangs , also just to make sure d2 and d3 replicate well without any
problems from d1 right ? also as per your message d4 and d5 would work well
if no replication is enabled at all so essentially its only the replica
> Well, with full disclosure, the ONLY thing you can do without changing
> the code is to modify the table.
>
> However, if you modify it, any of the "large int" (BIGINT? large int
> is not a value in MySQL) values will be truncated to the largest int
> value (4294967295).
>
> -Sheeri
>
> On 2/
Hi Conor,
The table you showed us has 2 primary keys, which is not possible.
Can you do a SHOW CREATE TABLE on *each* table?
-Sheeri
On 2/8/06, Conor McTernan <[EMAIL PROTECTED]> wrote:
> Hello, I'm having a hell of a time figuring this query out, maybe someone
> can point me in the right direc
Well, with full disclosure, the ONLY thing you can do without changing
the code is to modify the table.
However, if you modify it, any of the "large int" (BIGINT? large int
is not a value in MySQL) values will be truncated to the largest int
value (4294967295).
Caveat emptor!
-Sheeri
On 2/6/06
Any suggestions?
On 2/3/06, سيد هادی راستگوی حقی <[EMAIL PROTECTED]> wrote:
>
> Dear all,
> Thanks for your replies.
>
> The main table for me is traffic_log. I use combination of recipient_id
> and mobile_retry fields to uniquely identify each row in the traffic_log and
> use the same combination
Dear all:
I have been exploring about this issue quite a lot, and find no solution:
Platform: Debian, MySql 4.1.11, PHP 4.3.10-2, Apache.
Is there any way I can retrieve a set of values depending in a where clause:
For example:
from a set of values in one field: 1,2,5,8,9,11,13
I'd like to re
I've done similar things with sequences. This method is borrowed from
the DBIx::MySQLSequence perl module (the _sequences table can contain
many sequences, named in the "sequence_name" field):
update _sequences set
sequence_value = LAST_INSERT_ID(sequence_value + 1)
where sequence_name
Hello.
This seems like a FAQ. Search in archives at:
http://lists.mysql.com
See:
http://lists.mysql.com/mysql/101771
http://dev.mysql.com/doc/refman/5.0/en/select.html
http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html
Kleiton L R Soares wrote:
> Good Morning
>
> Hi, i nee
Hello.
The logic of your application is clear and should work (though I haven't
been digging deeply inside the code). Check that the table type is
InnoDB. 4.0.1 version is rather old and could have lots of bugs, I
recommend you to upgrade to the latest release. Another reason, is that
your algorit
Good Morning
Hi, i need make a query on my database and the result save in a text file with
coma (CSV-file)
Somepeople can help-me
Thanks !
--
---
---
Kleiton L R Soares (21-2620-0735 | 21-9639-5829)
PCS - Processos Consultoria Soluções
www.pcs.com.br / [EMAIL PROTEC
Hello, I'm having a hell of a time figuring this query out, maybe someone
can point me in the right direction.
I have a table which lists the case configurations for cases of items. Each
case will have a different combination of sizes e.g. Case 002 has 2 size 5,
2 size 7 and 2 size 8 items.
What
Hi,
I am running MySQL 4.0.1 with j/connector 3.1 and I am having problems
trying to figure out why I am not getting the results I am expecting.
I have a table that is used for generating primary keys. It only has one
item, an int that is incremented each time a key is needed. This is not m
Hello.
Perhaps, there is nothing to do with a corrupted binarylog. Check one
more time if you have a copy of the files without an errors. The last
resource in my opinion is manually find the entry of the next event
and correct the event size in the binary log. BTW the event_type: 109
looks suspici
Hi,
I tried mysqlbinlog for 5.0.18, but whether I use the --hexdump option or not,
it still aborts with the same error:
ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1635131433, event_type: 109
Could not read entry at offset 1384:Error in log format or read error
Is t
Hi Gleb,
Thank you for you reply.
I am very much willing to recover the data manually, since I am reluctant to
bring down our production environment. I checked out the binlog-link you
mentioned, but since mysqlbinlog quits with an error, it is of little use.
I am now compiling 5.0.18 to see if
Hello.
If the data in binary logs is important for you and you're ready to
research and recover the data manually. Have a look here:
http://dev.mysql.com/doc/internals/en/replication-binary-log.html
Check if the problem still exists with mysqlbinlog from the fresh MySQL
shipment. The --hexdump
I bought MySQL Pro, my Company name is INFOKOM ELEKTRINDO, I have
license serial number: xx
However how to get support by having this LIcense?
Thx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Miguel, all!
Miguel Cardenas wrote:
Hello
Am trying to compile mysql-5.0.18 under solaris 10 but get the following
error
Making all in zlib
make[2]: Entering directory `/tmp/mysql-5.0.18/zlib'
[[...]]
(cd .libs && rm -f libz.so && ln -s libz.so.1.2.3 libz.so)
false cru .libs/libz.a adl
Hi,
MySQL 4.1.10-log, Solaris
Replication stopped with an error that closely resembles bug #8215. When
examining the binlog with mysqlbinlog, it stops before reaching the end of the
binlog, with the error
ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1635131433, eve
Hello.
Taking into an account the nature of your queries, I can forward you to
these links:
http://dev.mysql.com/doc/refman/5.0/en/query-speed.html
http://dev.mysql.com/doc/refman/5.0/en/limit-optimization.html
If some of your fields have only two values ('Yes', 'No') you can
switch to ENUM
Hello.
Not enough information to make a conclusion. Please, could you provide
versions of MySQL Server and mysqldump utility. Include the command line
options for mysqldump. Check if --skip-quote-names helps you. See:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
wangxu wrote:
> When
Kishore Jalleda schrieb:
Hi you may be having issues with the byte order on the opetron's and the
P4's , this was asked earlier in the list, and here's what Jimmy from Mysql
had to say
Kishore,
Thanks for the suggestion, but all x86 have the same byte order... and
as I wrote its no
Hello.
Have a look here:
http://lists.mysql.com/mysql/194596
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
If you feel uncomfortable with 10G ibdata size, you may want to
switch to per-file tablespace:
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
http://dev
Hi,
We have moved from Mysql4 to MySQL5 and are currently planning our new database
schema. In this new approach we would like to move to InnoDB's storage engine
for transaction support and still want to use MySQL's FULLTEXT search
capabillities. And to make things easy we also want to replica
47 matches
Mail list logo
