Hello, MySQL gurus,
I have a non-unique key of 2 columns, the 1st is a varchar(15),
2nd is a int(10) unsigned. But when I 'explain' a query that uses this
key, the key_len is only 15 with the key name shown up in the 'key'
column of this table correctly though. According to the manual,
Hi, mysql Gurus,
Sometimes I need to execute 'select * into outfile '/tmp/t1.out'
more than 1 times before I get the right result. But once mysql succeeds
in writing t1.out, it does not overwrite it if the same sql command is
executed for the 2nd time unless t1.out is removed. Is there
Hello, MySQL Gurus,
I have a mysql server (4.0.20) that has been flaky these days. I
can't connect to it by 'mysql -p' or shutdown thru mysqladmin. It just
hangs there forever without doing anything. I tried to 'ps -Aef | grep
mysql' and sees nothing but the mysqld_safe and the mysqld_max
Hello, MySQL gurus,
I am just wondering if there is a way to set MySQL so that you
can have the name of the mysql table completed for you if you hit tab,
like typing file names in bash, you only need to type enough characters
to uniquely identify the file or directory name, then you press
Hello, mysql Gurus,
Because of disk space issues, the data dir of my mysql DB is somewhere
else other than /var/lib/mysql. I did not link /var/lib/mysql to the real
data dir though. It works OK until I want to use perl DBI which complains
can't connect to mysql thru
Hello, MySQL gurus,
I am wondering how I can grant a user the privileges to all the db except
for mysql DB. THere are many databases so I don't want to grant one by one.
But 'revoke all on mysql.* from user' does not work. Thank you for help
ginger
--
MySQL General Mailing List
For list
Hello, MySQL gurus,
Since I have been moving data around using mysqldump recently, I have
found sth annoying:
If a table has a column defined as 'float not null' and the corresponding
txt file used to load it have sth like 'nan' for the column, although
giving warnings, the record will be
Hello, MySQL gurus,
I just installed mysql 4.0.20 on an athlon i686 linux red hat. Then I copy
the my-huge.cnf to /etc/my.cnf and only added these 2 lines to the file
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/host.pid
when I use 'sudo -b mysqld_safe --user=mysql' to
Hello, mysql gurus,
I have been trying to transfer some huge databases (20G) to another
server using mysqldump. Here is my command
mysqldump --add-locks --allow-keywords -q -p db db.dump
When I tried 'mysql -p db db.dump' in another server, everything goes
all right until at some point it
Hello, MySQL gurus,
Sometimes the 'local' option of 'load data infile' is disabled for
security reasons (that is what I got from web). What could be the security
problem? I have another question, is there any way to change a variable of
mysql server without shutting it down?
Thank you for
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu (i386). I
started mysql server with 'safe_mysqld --user=root ' . Then I found some
variables needs to be optimized. SO I shut it down with 'mysqladmin -p
shutdown' using root. But I was connected to the mysql server at
I don't have such files. Unfortunately. Am I hopeless?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB
I got it fixed with the msg from --err-log. THank you so much for all your
help. I couldn't have made it without your hints.
ALl the best
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello, MySQL gurus,
I have been trying to output the result of some large query to a temporary
table and then query from there. But all my trials ended up 'ERROR 2013 at
line 7: Lost connection to MySQL server during query' before creating the
temporary table. The version of MySQL is 3.23.54,
Hi,
The max packet site is 1048576. But I don't think it is a problem cuz I
have successfully outputted the result of this query before. I checked
mysqld.log. This is the tail I think might related to the problem:
Number of processes running now: 0
040406 22:22:01 mysqld restarted
Cannot
I think this is the problem (cited from mysqld.log)
Some pointers may be invalid and cause the dump to abort...
followed by my query to create the tmp table
But I am not sure how to fix it.
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello, MySQL Gurus,
I am just wondering if anyone has seen this before querying an innoDB table:
select count(*) from Table where field1=3;
returned 782 rows
select count(*) from Table where field1=3 and field2 is not null;
returned 666 rows
Here comes the shocking part:
select
Hello, mysql Gurus,
I am wondering if there is any data integrity protection can be done if I
allow uses to update database from mysql Control Center or Excel and any
other applications that is connected to mysql thru mysql ODBC. I need to
reject the action if it makes violation of the data
Hello, mysql Gurus,
I am wondering if there is any data integrity protection can be done if I
allow uses to update database from mysql Control Center or Excel and any
other applications that is connected to mysql thru mysql ODBC. I need to
reject the action if it makes violation of the data
Hello,
I am just wondering how I can make a trigger to update multiple tables
efficiently. (mysql db). RIght now I am thinking of making copys of the tables
involved and update the copies to see the result. But it could be time consuming if
the tables are huge. Any one has good ideas
21 matches
Mail list logo
