I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
15.8 has no exact binary representation, so a test for equality will fail.
Do not use floating point if you want to test for equality. Try DECIMAL
Miguel Figueiredo wrote:
>Hello all,
>
>I have a (probably dumb) question.
>My table "temperatura" has two fields described bellow.
>
>mysql> descr
15.8 has no exact binary representation, so a test for equality will fail.
Do not use floating point if you want to test for equality. Try DECIMAL
Miguel Figueiredo wrote:
>Hello all,
>
>I have a (probably dumb) question.
>My table "temperatura" has two fields described bellow.
>
>mysql> descr
Mysql must own its files and directories.
chown -R mysql /var/lib/mysql
assumong /var/lib/mysql is the data directory.
FISHER,JOE (Non-HP-Roseville,ex1) wrote:
>I have 2 SuSE Linux 7.2 machines at home... These boxes have completely
>different hardware in each... But the O/S on each, contains
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
perhaps because you are root@eros, and not [EMAIL PROTECTED]
root wrote:
> Hi
>
> How do I get off the list ?
>
> I have tried several times with sending a mail to
> mysql-unsubscribe-srabol=mysql-unsubscribe-ing.aguirre=internetica.com.mx@lis
>ts.mysql.com, and tried the
> http://lists.mysql.co
How would you do:
set field='Jim said, "that's crazy."'
you would have to escape the quote somehow. The '\' is the escaper
character.
set field='Jim said, "that\'s crazy."'
That means hat the escape character must also be escaped.
Check the manual for the section on special characters.
Most
check for a .my.cnf file in the user's home directory. It may have
conflicting entries.
Brad Emerson wrote:
>
> When I am logged in to my Linux system as root mysqladmin works
> correctly. i.e. finds mysql.sock in the correct location.
>
> When I am logged in as a normal user I get this erro
Install your ncurses rpm.
Paul Warren wrote:
>I've been frustrated with this for the past I-donno-how-many days. Has
>anyone been able to get MySQL to work on Red Hat 7.2?
>
>I've been getting multiple errors. The First was the resolveIP() right from
>the beginning. I follwed what the mysql webs
The client has to be able to search var/lib/mysql and read and write the
var/lib/mysql/mysql.socket.
It is probably not able to do one of the above due to imprpoer
privileges at the filesystem level.
Doug Thompson wrote:
>Egor:
>
>Yesterday, I wrote and described that my fix for a single cpu,
Michal Dvoracek wrote:
>Hello,
>
>s possible to create table with default value returned by built-in
>function ??
>like:
>
No.
>
>create table x (a int not null default UNIX_TIMESTAMP());
>
What is wrong with the timestamp field type?
>
>
>When inserting new column in table field a will conta
Does mysql own the mysql database directory, and all its files?
You should have run it as
mysql_install_db --user=mysql
Rance Hall wrote:
>
> Hello all
>
> I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at
> that computer now, so that could be wrong slighly) install pkg
>
>
If more than a third of the rows would be selected, it is faster not to
use the index.
Over 2 million records match the '2'.
How many are there total?
Steve Gardner wrote:
>Hi All
>
>Could someone explain to me why an index in a select I am doing is only
>sometimes used.
>The select I do is a c
I know that the server is running under safe_mysqld
> --user=mysql it couldnt find the files cause under that account name
> apparently they dont exist.
>
> The mysql user is part of what group, so I can chown the dir, and
> start again?
>
>
> Gerald Clark wrote
>
>&
what about
select Url from table where Ref = 'foo'
Salada, Duncan wrote:
>I am hoping I can get some help with a difficulty I am having with a table
>of mine. I am going to give a lot of background info, so please bear with
>me. First, let me say that I using 3.23.49. Now some info about the
Grant all on mysql.* to 'root'@'localhost' identified by "password";
What version MySQL are you running?
You need 3.23 for GRANT to work.
Kathy Reyes wrote:
>I just gave up, everything that I tried did not work.
>
>I killed mysql and then
>started with safe_mysql --skip-grant-tables
>then I
USE db2;
alan4100 wrote:
>mysql
>
>Paul,
>
>I was afraid to hear that. It had said about line 2 in the error message.
>This line #2 looks normal.
>
>May I ask you to check this script below, but I am afraid it may be
>annoying. I will eventually put this on posting. Remember I use Windows XP.
>
None of these selects will use an index.
1. An index can not be used for LIKE '$something'.
2. An index will not be used if 1/3 of the entries match.
3. See #1.
Jaime Teng wrote:
>Hi,
>
>I have this table:
>mysql> describe eventlog;
>+-+--+--+-+-+-
Try:
echo "
load data infile '/home/loader/txt/file_${date_proc}.txt' into table debits
fields terminated by ';'
" | mysql -u user -ppass dbname
Oswaldo Castro wrote:
>Hi List
>
>I'm new to MySQL and I need help on how to pass shell parameter to a mysql
>script file (bash/SuSE 7.2)
>
>I have
All init.d daemons take one of two options. These are "start" and "stop".
Init supplies the correct option when changiing run levels.
Where the daemon resides varies among versions of UNIX/Linux.
[EMAIL PROTECTED] wrote:
>>Description:
>>
>regarding mysql.server daemon
>
>>How-To-Repeat:
>>
>
Did you dump the 24 records on both boxes and compare them?
Maybe someone updated the records on the slave, and now the dates don't
match.
Vico Timmermans wrote:
>I think i stumbled upon a bug that's got something to do with join
>size. Detailed information below.
>
>Using 2 intel-linux platfo
Maybe you really wanted ORDER BY.
Tobias K. Tobiasen wrote:
> Hello
>
> I think the gruop by is behaving strange. Could someone please explain
> this or maybe point me to a definition of the group by. (Inspired by
> http://www.mysql.org/doc/E/x/Examples.html).
>
>
> CREATE TABLE shop (
> arti
Your alias and column name are the same.
Which one do you think is being tested?
Also DATE is a reserved word.
Chuck \"PUP\" Payne wrote:
>Hi again...
>
>When I felt proud because last week I had asked about how to use NOW(), and
>get answer that got me working, but now I have a strange problem
You are passing a string to compare to a date. If you do this, pass it
in the string format.
Other wise " and t_boxdaily.boxdate < 19990101 "
Steve Briant wrote:
>Hi,
>
>I think I may have spotted a bug in connection with the LEFT JOIN statement.
>
>The following SQL
>
>select name, sum(
Steve Katen wrote:
> Ruben,
>
> If you leave it as NOT NULL it should default to NO. "If an ENUM is
> declared NOT NULL, the default value is the first element of the list
> of allowed values."
>
> SIDE QUESTION:
> Are you doing something like: select * from table where enum_colum="NO"
>
> I
crontab -l
will list your current crontab entry.
Cron is not running your job from a browser.
If it won't run from your unix
$
prompt, it won't run from cron.
Harpreet Kaur wrote:
> I am trying different options but everytime i make a change and type
> crontab mycron.txt in telnet it comes
The only way I can see to get this message is if the
client you are on when running mysql is 192.168.10.2
You should be using the IP address of the server you are connecting to,
not the IP address of the client machine.
George Pitcher wrote:
>Toni,
>
>check your logs to make sure that the clien
I see no column named Site.nome showing that it is wrong.
ds wrote:
>Hi,
>
>I'm having a strange problem using SQL vars (@variable) and an order by
>expression.
>
>I have a query that returns a record for each day.
>Each record has a date (data), a column with the daily total value
>(uv_views)
insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2',
'TN,NC,AL') ;
Jim Philips wrote:
>Yes. I found that page earlier. I still don't see how it answers my question.
>What is the proper syntax for an insert statement?
>
>On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:
Don't include a from clause with the last_insert_id(), or you will get
a full table scan.
The last_insert_id will only give you the insert id for the last record
inserted.
mysql mailing list user wrote:
> Hi,
> I have a big problem with last_insert_id() query.
> I am adding records to a tabl
Don't put quotes around your password.
Dion Wickander wrote:
>I set up a script to rotate my logs for mysql and cron fires it off
>perfectly the logs are rotated but when the shell script gets to the last
>line which is...
>
>mysqladmin -u usernam -p"Password" flush-logs
>
>it will not execute i
This is a mail list for MySQL users.
If a user knows the answer to your problem, and feels like answering,
you may get a correct,
or incorrect answer.
If you REQUIRE quick response, pony up for a service contract like I did.
Clay Loveless wrote:
>At this point, I'd like to solicit tips on how
The semicolon does not belong there.
Anna Fowles-Winkler wrote:
>Anna Fowles-Winkler wrote:
>
>>Paul DuBois wrote:
>>
Paul DuBois wrote:
> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >Well, the function is called like this:
> >
> >mysql_real_query( mysql_connec
kapil nakra wrote:
> I am facing problem in compiling c++ program using mysql libraries. I
> am doing this for the first time. I would appreciate if anyone of you
> help me out.
>
> thanks.
>
>
> folowing is the code
> ___
> #include
> #include
> #include
>
Nick Wilson wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>
>* and then James Carrier declared
>
>>It'll be something like:
>>
>>/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
>>
>
>Well, that's certainly progress of sorts :-)
>It's just 'hanging' now. It s
Opening a file access it by its inode.
Once it is opened, it can be renamed, or deleted, and this will have no
effect
for the process that has it open.
Flush logs will close the inode, and create a new log, which will assign
a new inode
to be opened.
File names are just handy pointers to inodes
Python has its own MySQL interface module.
You don't need MyODBC.
Sabine Richter wrote:
>Hello,
>
>I can't think straight today. So please help me:
>I downloaded and installed myODBC 3.51. As far as I understand, it is
>only the driver, which provides the connection to the database. In my
>examp
Error 13 is a permission problem.
Mysql does not own the file.
You probably repaired it while logged on as root,
and changed ownership of the file.
Make sure it is owned by mysql.
MySQL wrote:
>Hi all,
>
>I was trying to repair a table with myisamchk and got the following message:
>
>"error: 'x
Unfortunately, you did not tell us what version you are running, or what
platform you are running it on.
Try rebuilding the indexes with myisamchk or whatever is appropriate for
your table type.
Sheni R. Meledath wrote:
> Hello:
>
> I have a problem while selecting the records from a table.
They must be owned by the user under which the mysqld runs, or change
them to mode 766.
Milan Reznicek wrote:
>I have a problem with updating MySQL database on linux with mysql
>3.23.24-beta-log. I have prepared a database on Win98 SE platform
>with 3.23.49a and when i moved to my linux server
It should be 'username'@'localhost'
Mark Shade wrote:
>Yep...
>
>I am in as root, so I should have rights to everything.
>
>Yep, I have confirmed that the dbname is right, but doublechecking it
>multiple times. Plus, this happens even on db that I did the same thing to
>only a week ago. Th
Make sure mysql owns its database files and directories.
[EMAIL PROTECTED] wrote:
>>Description:
>>
> I was getting a read-only error on one of my many databases. So, I tried doing
>mysqladmin restart and now I'm getting "Can't find file: './Belzon/jobs.frm' (errno:
>13). I've tried look
Use gcc 2.95.3
[EMAIL PROTECTED] wrote:
>>Description:
>>
> Our mysql server is crashing multiple times every day. In looking through the
>logs, in mentions that we should check our key buffer, but the memory size is well
>within our systems ability. Basically, if I don't find out how t
Make sure mysql owns the tables and their directorys, and has write
privileges to them.
I talking about UNIX permissions here, not mysql permissions.
Bill Flanagan wrote:
>Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM
>tables on which I am unable to do updates or insert
Check your indexes.
Daniel Lim wrote:
>Hi there,
>I have MySql version: 3.23.36 running on RedHat 7.1, it has been
>working fine for sometimes until a day ago when the INSERT into for new
>record appeared to return OK status but upon verifying the record isn't
>there?
>
>This is an example;
>
Myisamchk returns an exit code.
if myisamchk myfile.MYI ; then
do something
else
do something else
fi
Mark wrote:
>Hello,
>
>Is there a way I can do a "CHECK TABLES" which will return an exit code of
>some sort, to use in a shell-script? Looking at the output of a myisamchk is
>fun, bu
It is asking for myslq's root password, not the su password.
If you have not set it yet, skip the -p option.
Todd Cary wrote:
>YES! I was missing something: Telnet!! I can log in *BUT* I am unable to
>change the MySQL password.
>
>mysqladmin -h www.myhost.org -u root -p password 'new_password
Because mysql needs 'rx' permissions to read and search the directory.
755 should have been sufficient.
Menard, Inc. Information Systems wrote:
>I figured it out but I'm a bit confused as to why it happened.
>I'm running the load as user1. The file resides at /home/user1/data/filename
>Permiss
Don't use 'more'. It adds characters to the output.
Instead:
mysql --host=host --user=user --password=pwd < error_repeat.sql
Elliot Smith wrote:
>Description:
>I used mysqldump to create an SQL file containing a dump of all databases on
>the server, including all tables and data (using --a
You will get better response if you post only once, and NOT as a reply
to someone else's question.
Peter Engström wrote:
>Hello everybody!
>
>How can I do a fulltext search on several tables
>with just one SQL query?
>
>Best regards
>/Peter
>
>
>
>--
try timestamp(14) instead.
[EMAIL PROTECTED] wrote:
>Description:
> Problem with timestamp(8) and GROUP BY
>
>How-To-Repeat:
>
>mysql> CREATE TABLE test (
>-> id int auto_increment,
>-> dd timestamp(8),
>-> data int,
>-> PRIMARY KEY (id)
>-> );
>Query OK, 0 rows affecte
You need to install DBI first.
Amy Zediak wrote:
>
>I'm a little confused on how to add things to @Inc path...i'm trying to
>install Msql-Mysql-modules and it says that my DBI/DBD is not in the
>@INC
>
>Thanks
>Amy
>
>
>
-
Be
You should NOT be running myisamchk while the server is running!
[EMAIL PROTECTED] wrote:
>I get this message when I do a myisamchk on a table right after I use
>phpMyAdmin or other mysql client tools.
>
>What do I need to do to get the table to close properly? I have been
>having to run myis
All the numeric types are returned as strings. If you want to convert
them to numbers, you need
to use scanf or atod type functions.
Michael Flora wrote:
> Hello all, this is my first post to this list. I am relatively new to
> MySQL, and my question might be a basic one.
>
> I have a table
Did you check out the -w option to mysqldump?
andy wrote:
>Hi there,
>
>I am trying to get only records out of a table mathing a query. This should
>be piped into a textfile. My problem is that I have to transmit this records
>to a new machine. So the output should be a kind of sql commands whi
Maybe
if (!($result)) {
Try
print STDERR "RESULT=$result\n";
to see what you are comparing to.
Chris Hohimer wrote:
> thanks for all the replies!! but it is not working.
> here is the loop:
>
> if($result == EMPTY SET){
> $Scheduled = NULL;
> }
> else{
> $Tech = mysql_result($result,
No you can't, but check out LIMIT.
Marco Stagno wrote:
>>IMHO, The Right Thing to do this, is to create the additional data in
>>your application (as you said you won't change the table).
>>
>
>(...)
>
>thank you!
>
>>If you want this with SQL for sure, using user-defined variables will
>>work:
Are you shure you don't really want ENUM('y','n')
SET('y','n') will allow the field to be both 'y' and 'n' at the same time.
Chris Knipe wrote:
>I'm talking under correction here, but
>
>SET('y'.'n') default 'n' NOT NULL - should work. I normally just do all
>this stuff via phpmyadmin, it work
You mean
SELECT ObjId,ElemId,count( distinct Objid,ElemId ) from Elems group by
ObjId;
?
Csaba Gabor wrote:
>Seems like this should be an easy question, but I just don't get it:
>
>If I have CREATE TABLE Elems (ObjId INT, ElemId INT);
>Is there a nice query to find the Number of Distinct Ele
Cindy Nelson wrote:
> Hi,
>
> I am using SuSE 7.0 and MySQL 4.0.1. I had quite a time
> getting the daemon started on Linux but finally succeeded.
> I can start the daemon logged on as su and I can connect
> to the database as user=mysql and modify the existing DB
> called test.
>
> I set the p
It looks to me like 'a' is '127-30-127-1'
Notice the dashes.
I don't believe you are splitting the IP address into 4 separate numbers.
Chris Knipe wrote:
>Hi again,
>
>Not to long ago, I had a query regarding the best way to store IP addresses
>in a DB, and make sure that they are unique.
>
>I
Mysql does not own the database and its tables;
chown -R mysql /usr/local/mysql/var
( or whatever the database location is. )
Kariuki, JohnX K wrote:
>Hi I am pretty new to linux and I was trying to setup and use mysql, I
>followed the directions you provided about compiling it and installing
1. What does this have to do with ssh?
2. Does root@yourmachine have permission to connect to mysqld on
202.157.188.2?
ally wrote:
> Dear all,
>
>I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm
>trying to connect to it by ssh from another machine(ip 202.157.137.97) as
>f
Any permissions set for users on the database will be invalid.
Martin Rode wrote:
>Hi there,
>
>I was wondering if I can rename a MySQL instance (MyISAM) by simple
>stopping the server and rename the data directory? A quick test did not
>show any problems. I am now wondering if I can get other p
Taylor Lewick wrote:
>Hi all. I have searched the documentation, and i found some info, but I wanted to ask
>the lsit a little more about auto_increment.
>
>First, if I use auto_increment, and then delete a field, I assume mysql leaves the
>remaining fields with the original numbers...
>i.e.
MySQL doesn't own the files.
chown -R mysql /var/lib/mysql
eh wrote:
>Errno 13 on starting mysqld
>
>I am using SUSE 8.0
>on a 586 computer
>I installed MYSQL 3.23.48 from the Suse-CD (By the while four times)
>
>At first I was running (as described in
>/usr/share/doc/packages/mysql/README.Su
The mysql user was not granted write permission on the database?
Anil Garg wrote:
>The persmissions seems to be ok.
>ne other ideas!!
>- Original Message -
>From: "Kiss Dániel" <[EMAIL PROTECTED]>
>To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Tuesday, June 11, 2002 12:
chad kellerman wrote:
>Hello,
> I am sure this is an easy question but I am not thinking clearly for some
>reason. :^)
>
> If you set a column to auto_Increment. You do not have to put the
>auto_increment # in the insert statement to get it to be inserted. Mysql
>does this automat
ORDER BY mountainheight DESC LIMIT10
Yrjö Mäenpää wrote:
>As there is no TOP operator nor nested selects in MySQL, I wonder if there
>still exists some clever way to make"top ten" type of a query , i.e. to
>select ten best selling products or ten highest mountains for example.
>
>thanks
>
>
>
CREATE TABLE X (FLD1 INT PRIMARY KEY);
or
CREATE TABLE X (FLD1 INT, UNIQUE(FLD1));
UNIQUE applies to an index, not a field.
Andy Sy wrote:
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Andy Sy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Friday, June 14, 20
That is correct.
Use NOT NULL in the definition to force unique keys.
[EMAIL PROTECTED] wrote:
>>Description:
>>
> If a null column is used in a unique index then mysql fails to throw a
> key violation when multiple identical inserts (with nulls) are
> performed.
>
>>How-To-Repeat:
>>
> create
perror 12
Error code 12: Cannot allocate memory.
Either :
1. Add memory ( good )
2. Add swap ( Not so good )
3. Tune for less memory usage.
David BORDAS wrote:
>Hi list,
>
>just have this when connecting to my mysql dedicated server :(
>The server is like this :
>bi PIII 1 Ghz
>1Go of ram
>Ra
The manual says:
chown -R mysql.mysql /usr/local/mysql
You did not do that.
Do the same for MySQL's data directory.
Michael Sellers wrote:
>I'm very new to mysql. Just learning. I'm trying to correctly set up the
>permissions for the files under the mysql/ directory. I've included a
>lis
Or better yet,
add a sleep 2 to the beginning of the init.d program you are starting
that expects to connect to mysql.
Why slow down the booting for everybody when some other daemon that
expects to connect to mysql
can not handle a failed connect properly?
Florin Andrei wrote:
>The init.d scr
Your string contains special characters, and must be properly escaped
before storing.
Use the appropriate string escaping function in your language ( if it
exists ) or
write a routine to escape them for you before storing them.
The manual lists the special characters.
henry lee wrote:
> Dear
ORDER BY whatever DESC LIMIT 100
Mark S Lowe wrote:
>Is there a nifty way to select just that last 100 records with MySQL? In
>Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
>out with MySQL.
>
>Please advise! Thank you!
>
>Mark
>
-
With linux you would:
Add /usr/local/lib to your /etc/ld.so.conf file and run ldconfig.
Sun should have something similar.
[EMAIL PROTECTED] wrote:
>>Description:
>>
> what do I have to do to get configure to use correct gcc options like:
>-I/usr/local/include -R/usr/local/lib ???
>
>I u
shutdown the mysqld, move the data direectory,
and set up a symbolic link.
Rahadul Kabir wrote:
>Hi,
>I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql
>installed datadir turned out to be /var/lib/mysql. /var directory has
>it's own partition (/dev/hda3) and total space available i
You brought it up.
You made the comparison.
Give us a break.
Dave Morse wrote:
>Looks like you want to bring up something that doesn't have anything to
>do with the original question which is your perogative. But please
>don't compare MySQL with Oracle and mainstream SQL RDBMSs. Give us a
>bre
That is a difference in the behavior of
isam and myisam tables.
jason wesley upton wrote:
>EXPLANATION:
>
>here's the pertinent piece of my sql create statement:
>
>ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (ID));
>
>i have used this create statement numerous times without this "problem". in
chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] wrote:
>>Description:
>>
> When starting safe_mysqld mysqld shutsdown immediately with no error
>message. However looking at /var/lib/mysql/matrix.err gives the following
>error messages:-
>mysqld started
>/usr/libexec/mysqld: can't find
It looks like you configured it to install in the source directory.
Pushkar Pradhan wrote:
>I used gnu's make as recommended, make was successful, however gmake
>install gives the foll. error:
> /usr/local/gnu/bin/install -c copy-db
>/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db
>/usr
They are not SQL statements.
They are both command line tools.
You don't run them from inside the mysql client.
hlam wrote:
>I'm trying to do a backup of my DB using "mysqldump"
>and "mysqlhotcopy" but both functions are sending me an error on SQL
>syntax.
>Could someone tell me what's the cor
You check index files, not table names.
myisamchk -k 0 -rq $MYSQLDIR/test/BestGuess.MYI
Archer Barrie wrote:
>>Description
>>
>Having followed the instructions in section 5.2.8 to create a table using
>LOAD
>DATA INFILE *without* its indexes, the indexes are *still* created at the
>end
>of th
That is the normal behavior for ISAM type files.
Convert them to MYISAM.
Richard Fox wrote:
>>Hi,
>>
>>I have a mysql table which has a run_id which together with user_id forms
>>
>the
>
>>primary key for the table. run_id is not null and auto-increment. I delete
>>records from this table, and a
Well, if it is read only, it won't be able to update from the master.
GRANT your users no write permission.
Pierre Baridon wrote:
>
> is it possible to start a server in 'read only' mode ?
> so that users cannot write in my slave server ?
>
> thanks,
>
> Pierre
>
>
>
>
>
>
> --sql,query
>
>
>
No, those are termcap database entries.
Configure is looking for libtermcap or libterminfo int .the /lib directory.
If you are running RedHat Linux you need to install the ncurses rpm.
David Johnston wrote:
>When running ./configure I am getting the error no termcap libraries but in
>/usr/lib/te
Naathan wrote:
>Hello,
>
>Greetings!
>
>I am trying hard to connect to MySQL database stored on Linux machine
>through a
>VB program running on windows on another machine.
>
>My problems are ..
>
>Problem No1:
>
>My Windows machine is under a Windows NT domain.
>Linux machine is under another W
A. John Peters wrote:
> New error msg, I think I have permissions right
No you don't.
Mysql must own the database directories and files.
>
>
> 020711 08:37:57 mysqld started
> 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file
> '/usr/var/e-mac
> .pid' (Errcode: 13)
> 020711
OOPS!
Bob Bell wrote:
>On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark
><[EMAIL PROTECTED]> wrote:
>
>>Naathan wrote:
>>
>>>I am getting the following error message like .
>>>
>>>" [TCX][MyODBC]Host is not allowed to conn
Use adduser, or the appropriate command for your version of UNIX to
create the mysql account.
Alex Jarvis wrote:
> To summarize: I was getting a "cannot connect through
>socket..." error. It would appear that the server is not running and the
>socket doesn't exist. So I tried to start t
Since -p="" is not valid syntax, it should not work.
There is no equal sign after the -p, and no space between the p and the
password which needs no quotes.
If you have no password leave out the -p option.
Derek Fountain wrote:
>Hi,
>
>I have a server running 3.23.41 on Redhat 7.1. The probl
What would you expect?
You ask for the whole file, and then ask
that it be sorted by two fields.
How do you expect this to happen without a temp file?
Tiago Antao wrote:
> Hi!
>
> I have a very simple query
> SELECT a, b FROM t ORDER BY a, b
> I also have an index on t(a)
> I have run ANALYZE
>
I verified his problem with 3.23.38 here using myisam files.
The key here is that the unique index is across TWO integer
fields, one of which is auto_increment.
Victoria Reznichenko wrote:
>Richard,
>Thursday, July 11, 2002, 7:26:00 PM, you wrote:
>
>RF> But the default table type is already MyI
The server must be able to read the file, and since the server normally
runs as the user 'mysql',
it will not be able to read files sitting in root's home directory.
Put the file in /tmp, and make it readable by others.
Sofiane FAESSEL wrote:
> hello everybody
> I have a problem using mysql and
Did you copy the master.info file over too?
Santiago Alba wrote:
>Hi All,
>
>I had a system replication on Linux consisting of MASTER and only one SLAVE.
>I stopped replication, I did a backup on my slave and it recreated in
>another machine so now I have two SLAVES connected to database MASTER
The mysql user should own the databases and files, not root.
David Kramer wrote:
>I am able to access all of the database instances that I have created when
>starting Mysql with safe_mysql(as root user). As soon as I start mysql any
>other way, I keep getting the Access Denied Error. Can root
t. Do I " chown " the binaries and database files to
>my new user? Or Do the binaries always stay to root?
>
>Thanks much!
>
>DK
>
>-----Original Message-
>From: Gerald Clark [mailto:[EMAIL PROTECTED]]
>Sent: Friday, July 12, 2002 11:08 AM
>To: David K
Difficult to answer without knowing what the
"unix-socket problem" is.
p shah wrote:
>Hi,
>
>I want to know one thing about MYSQl,
>Why does this software always give the unix-socket
>problem when compiled and installed.
>
>I am installing on redhat 7.1.
>
>Is there a remedy to this or this will
If mysql owns them, 0770 should be fine.
System Administrator a.k.a. The Root of the Problem wrote:
>USually all the databases sets up fine BUT recently, I have
>had to adjust databases to 0777 in order to get them to
>work and change the ownership.
>
>I prefer the more secure model of mysql.
>
1 - 100 of 593 matches
Mail list logo