Put a .my.cnf file in root's home directory.
Make it owned by root and mode 400.
Put root's mysql password here, and cron can
run the backup, but nobody except root can read
the .cnf.
[EMAIL PROTECTED] wrote:
i have mysql in redhat and i would liket o automate the backup process..
i would
chown -R mysql.mysql /usr/local/mysql
ROUTLEY, Merrindal (MR) wrote:
Hi all,
I have recently downloaded mysql version 3.23.45 and I am struggling to get it to
start.
Every time I type in ./safe_mysqld the program starts and then shuts down immediately
with the following being written to
If it thinks it will retrieve more than a third of the records, the
index will not be used.
[EMAIL PROTECTED] wrote:
I get the following results when doing a SELECT off a single table I have.
What's bizarre is that the index is no longer used when i expand my list of
states to be included.
Binary data is binary data.
It doesn't mattrer whether it is GBK or and audio file,
or a jpeg.
If you escape the data properly before inserting it you will get
back the same data you stored.
Your application must display it properly.
xuefer tinys wrote:
re-posting multibyte problem.
does
chown -R mysql.mysql /usr/local/mysql
[EMAIL PROTECTED] wrote:
Trying to install 4.03 from the tarball...
Any idea whay I am doing wrong??
Thanks, S.Alexiou
Here is what I get
...linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
020918 21:55:07 ./bin/mysqld:
Michael Boudreau wrote:
I can't tell if this is an SQL question or a MySQL question, so please
forgive me if it's not germane. I'm wondering whether I'm expecting
MySQL's LEFT JOIN to do something it can't, or if I just don't know
my SQL well enough.
Given a database with these
Did you try a straight join so MySQL won't swap the order of the tables?
Philip Smolen wrote:
Right. The simple example listed at the bottom of this message works great
under version 4. Version 3 gave the right answer, but it was very slow.
That made me upgrade to version 4.
However, even
mysqld --user=mysql --skip-grant-tables
Mario Ohnewald wrote:
Hi!
I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux
What i did (http://www.mysql.com/doc/en/Resetting_permissions.html):
# rcmysql stop
# mysqld --skip-grant-tables
Fatal error: Please read Security section of the manual
Using DESC on an index only works with V 4.
Philip Smolen wrote:
I'm trying to make a query faster. It seems simple, but I can't make it
work.
This is a common case for me:
SELECT *
FROM very_large_table
WHERE (simple_condition)
ORDER BY an_indexed_field DESC
LIMIT 5;
For simple queries this
Don't run myisamchk while the server is running.
Mike Lucente wrote:
Isn't that what 'myisamchk -o' does?
On Tue, 17 Sep 2002, Victor Pendleton wrote:
Mike,
Erro 127 means that the table is marked as crashed. You should run a
check and repair if necessary.
Error code 127: Unknown
perror 28
Error code 28: No space left on device
Andreas Metzner wrote:
Hi All,
After a query
SELECT * INTO OUTFILE test.csv FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written
in perl you would do
my $qselcat=$dbh-quote($selcat);
$whichpart = AND key1=$qselcat;
René Fournier wrote:
Hello everyone,
I'm trying to Select on a field that contains a doublequote, and can't
figure out how to pass it throught the Select statement (couldn't find
anything in the docs
Do not run myisamchk with the server running.
Stephen Sokalski wrote:
version: 3.23.37 running on an RAQ
Problem: I can not log into MySql as root - it hangs after I give it
a password.
Background: MySql was running fine for a year and then just stopped
running.
Symptoms: 1) Mysqld
I do:
slave stop
mysqlhotcopy
slave start
Martin Waite wrote:
Mysql, sql, etc.
Hi,
I am using a slave to perform backups using mysqlhotcopy.
This locks all tables in my database for 10 minutes.
Sometimes the replication is aborted during the period
that the tables are locked. The error
Put an index on password.
That should speed it up for you.
Kristian Koehntopp wrote:
Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell:
If you have proper indexes on alias, the optimizer should not
make a table scan. You can try to add an index on pw too. Or
you could combine the
Maybe a simple
mysqladmin flush-logs
would have done it.
Mark Dieterich wrote:
Jeremy,
What would I do without the internet??? I restarted mysql by hand and
the discrepency immediately went away. I should have thought about
that.
Thanks!
Mark
On Wed, Sep 11, 2002 at 12:01:29PM -0500,
Is the file there, and readable by the user 'mysql' ?
Xiaolin Zhao wrote:
Hi, All
I am trying to make MySQL 4.0.3b work with AIX 4.3.3.
But whenever I did the `./bin/safe_mysqld ` command,
I get following error:
020910 08:31:33 mysqld started
020910 8:31:33 Can't find messagefile
is run as mysql user.
That is why I can not understand it.
Any idea?
Best regards,
Allen Zhao
--- Gerald Clark [EMAIL PROTECTED]
wrote:
Is the file there, and readable by the user 'mysql'
?
Xiaolin Zhao wrote:
Hi, All
I am trying to make MySQL 4.0.3b work with AIX
4.3.3.
But whenever I
of lasy and security breaking act, but at
least that confirms the nature of the problem.
Best regards,
Allen Zhao
--- Gerald Clark [EMAIL PROTECTED]
wrote:
Make sure mysql has search privileges through all
the
directories to the file.
Xiaolin Zhao wrote:
Hi,
Yes, it is existing:
ibmaix:/usr
I think the point of a question is to get the correct answer.
The correct answer was given.
David Lloyd wrote:
Hmmm...
Specify the fields you want in your query.
example:
SELECT stat_id, stat_name, stat_data FROM build_stats
WHERE stat_date LIKE ...
I think you miss the point of the
The source is written in C.
Check out the mysql client program.
Many of the utilities listed on the MySQL site are
also 'C' programs. You can download some of them and
take a look.
I would not recommend this as your first exposure to 'C'.
You might want to hire a programmer to assist you until
Why is that a problem?
Chuck \PUP\ Payne wrote:
Well I am glad for the help :). I am get an old table clean up but need to
re-index my table. I think there is on small problem. It's is ISAM table and
not myISAM.
Chuck Payne
Magi Design and Support
Mysql and sql
Mark Sibly wrote:
Hi,
I'm new to this list, and have a few basic MySql questions:
* Is it safe to convert a timestamp field to a datetime one? ie: will this
'touch' each row and stuff up the ordering (hopefully not!).
What happend when you tried it on a test table?
* I'm building a BBS
insert ignore into select from
will skip duplicates.
Karl J. Stubsjoen wrote:
Hello,
How can I determin what erros occur from an Insert into select from
statement? Namely, I'm looking for any duplicate record errors. It is
important to inform the user (in a web browser) whether or not a
It means mysql does not own its directories and files.
chown -R mysql
/usr/local/that-long-directory-name-that-should-have-been -symlinked
Richard W. Berriman wrote:
The contents of the error log in
mysql-3.23.49a-pc-linux-gnu-i686/data is:
020908 17:00:27 mysqld started
020908
Put the server on the machine with the data.
You don't want your server doing full table scans
across the network.
Jaime JLO. López Ortega wrote:
Hi!
I have just installed MySQL 3.23.52 in a Windows2000. This machine is connected in a
network.
I would like to now if it is possible to install
Write it in perl.
Perl has modules for MySQl and Email.
Keith Burke [Experience IT] wrote:
Greetings,
I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on
You have to create a mysql user and
chown -R mysql /usr/local/mysql
then run
./scripts/mysql_install_db --user=mysql
Tony Butcher wrote:
Hi,
I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make
install go fine, but then when I try to run the mysql_install_db script
Try the manual.
It has a section on resetting the root password.
Basically you restart the server with --skip-grant-tables option
Check out chapter 20.11
Adam Cripps wrote:
I'm locked out of mysql database - it seems that all my users can't access
it, through lack of privileges, even root.
I have seen this post 3 times today.
The message is telling you it can't find
libz.so.1
Obtain and install zlib.
( I run Linux, so I can't tell you where to get it. )
Shravan Durvasula wrote:
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I
You need to throttle back the inserts.
You are doing 5-10 inserts per second, but
that is fully loading the server.
Do 1 or 2 inserts, and sleep a second.
Monte Ohrt wrote:
Hi,
I have hundreds of mysql databases on a server, mostly filled with
newspaper articles for web sites.
For one
Just shut down all the servers before copying the files.
Check out live replication.
It may be a better solution.
Mark Hennessy wrote:
I have a Master MySQL server which does not listen publicly, and it
distributes a database to my publicly accessible MySQL servers via
rdist/ssh every 15 mins
. Hennessy[EMAIL PROTECTED]
On Fri, 6 Sep 2002, Gerald Clark wrote:
Date: Fri, 06 Sep 2002 15:15:30 -0500
From: Gerald Clark [EMAIL PROTECTED]
To: Mark Hennessy [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Master MySQL server rdist db to public MySQL
that fills, or a lock queue, or something
else? Although the inserts are done in rapid succession, there is only
one connection at a time so it shouldn't be a # of connections issue.
And why is the entire server affected, not just that table?
TIA
Monte
Gerald Clark wrote:
You need
perror 28
No space left on device.
I guess your disk is getting full.
John Wards wrote:
Hi,
I am getting a weird error message in mysql.
I am doing this query
SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1
WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test
It is just a config file.
You don't run it.
PathFinder Software wrote:
Hi,
I am a not yet that experienced with System Administration and
need a little holding hand here if possible.
I am running Red Hat 6.2 with MySQL installed and running.
Frankly I have read the README and HELP and still
Myan GUI based clients use a new connection for each query, and therefore
can not be used to test locking or transactions.
Stefan Kroon wrote:
Dear developer(s),
I tried to use MySQLGUI 1.7.5 for Windows, downloaded from the
mysql.com-website. I had problems with using temporary tables. First
Check your DNS.
Philippe Dhont (Sea-ro) wrote:
Hi all,
I am a beginning user of mysql
I installed the server, no problems there. Did some tests and it really
looks nice to learn, I am a very beginning user so i tested a query on the
server
Select user,host,password from user;
This works
2002-09-29 = 1973
I suppose dte1973.
Johnny Withers wrote:
I'm a bit confused here.. dates are not my strong point..
I have a table with a date column in it (DATE datatype)
a few values:
mysql select dte from images\G
*** 1. row ***
dte:
That is as high as an unsigned tinyint can go.
Change it to an int.
Tony Devlin wrote:
I have a problem with MySQL. I am trying to insert data using INFILE, and
it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
further, either by manual insert or textfile insert. I
That is not valid SQL.
a table can't be like something.
I think you ommitted the field name.
I also don't see why you need a join , unless you have duplicate ids.
Gabe wrote:
First off, please excuse me if this is the wrong list to post this sort of question
to (and please direct me to the
It shoul d be running as user mysql .
Mertens Bram wrote:
On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
As it says in the documentation, If the LOCAL keyword is specified,
the file is read from the client host. If LOCAL is not specified, the
file must be located on the server. That
Other companies require you to sign up for a Beta program before you can
even look at it.
The public doesn't even hear about it until the Beta is through, and the
product is ready.
You probably will never know how long the Beta cycle lasted.
You are privileded to be given such early access to
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Mertens Bram wrote:
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
Put into my.cnf file :
[mysql]
local-infile=1
or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following
Your query overloads expendituredate.
Mysql now has to scqan the whole table to see if the new expenditure
date will
meet the where clause ( which it never will )
try DATE_FORMAT(expendituredate,%F=%b-%Y) as expdate
and see what happens.
kamesh jayachandran wrote:
Hi all,
I have a table
your date strings are incorrect.
As a string it should be '2002-08-01'
but it can also be treated as a numeric.
try:
and expendituredate between 20020801 and 20020831
kamesh jayachandran wrote:
Hi Gerald,
I tried the following query,
select DATE_FORMAT(expendituredate,%d-%b-%Y) as
use the -f option to ignore the duplicates.
Chris Barnes wrote:
Hi,
I have a database which a few tables which have a few fields set with
auto_increment and i'm having alot of trouble restoring the backup because
the backup recreates the table with the auto_increment field, but when it
tries to
You seem to havew a leading space in your newuser account.
Juri Nysschen wrote:
Hi
I have a problem with privileges on MySql NT 3.23.52. I hope that someone
can provide me with a solution.
If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
another db (CUSTOMDB) in the
Hardware?
Operating System and version?
MySql version?
Precompiled, you compiled?
Which compiler?
[EMAIL PROTECTED] wrote:
Hi. These last days, after some months of running relatively smoothly,
I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
just goes astray and
You have carriage returns in your data file.
Try adding a 'terminated by' to your load data.
compo guy wrote:
I am using MySQL version 3.23.11-alpha on Win98. I have created a
database with a table borrower whose description is as follow:
mysql describe borrower;
Fifield, Mike wrote:
I have a table with around 150 entries in it. I am querying the table with
the fallowing command.
SELECT * FROM guestbook LIMIT 140,9
This is working fine I am getting the last 9 entries but I would like it to
return them in reverse order. Is there a way to do this? I
Why use odbc when native drivers are available?
Norris, Joseph wrote:
Groups,
I have this snippet of code:
$dbh = DBI-connect( dbi:ODBC:${db_name}, $user, $pass)
or DoError(Unable to connect: $DBI::errstr);
#$dbh-debug(2);
$fsql = qq!select empl_no_a, user_ln, user_fn, user_mi, aka,
Ajay Patel - SunService wrote:
I am a beginner at SQL and would appreciate any help with a simple
query.
I have two tables:
host
patch
The host table contains details for a particular host (OS, cpus, memory, etc)
and the patch table contains patches installed on that host.
For example:
Then it doesn't belong on the MySQl list, does it?
Norris, Joseph wrote:
Agreed except in this case what I have to read is a FoxPro database -
(yuck!)
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 11:28 AM
To: Norris, Joseph
Cc
You are displaying your strings in hexadecimal format.
Sergio Barbosa Villas-Boas wrote:
Hi, all
I need help on this.
I'm testing mysql.
I did a very simple table and I'm writing a C++ application to read data
from it.
The connection/authentication/query part of the application seems to work
What have you tried?
What did you get?
Why is it not what you expected?
Luc Foisy wrote:
Some ficticious data
ID Data1 Data2 Data3
1 1 141 1
2 5 140 1
3 4 142 1
4 3 141 1
5 2 142 1
6 5 142 1
7
The mysql datetime will have to be
'1999-03-03 12:00:00'
or
1999030312
Maurizio Danilo wrote:
Hi,
I have to import some data in Mysql from a Sybase bulk
copy (bcp) text files, and I have some problems with
date type format fields.
The sybase db has datetime fields and in the
dump file
describe user.
Paul Maine wrote:
I have a column defined in a table as type date. I desire to include a date
comparison in the WHERE clause of the following statement. The following
statement is not working correctly, I suspect that there is a formatting
issue. The statement returns true even
-3.23.49/libexec/mysqld: Error on delete of
'/usr/local/mysql-3.23.49/var/host.domain.pid' (Errcode: 13)
020814 15:25:48 mysqld ended
Good thought though ! Any other ideas ?
Regards,
Mark
From: Gerald Clark
Date: Wed, 14 Aug 2002 08:53:17 -0500
Did you check your error logs?
Does mysql have write permissions to /home/admin ?
John Wards wrote:
I am having problems with mysql loggin slow queries. I have set up mysql.sh
like this
log_dir=/home/admin/slow_slog.log
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file
I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
I'm trying to set up a replication database and cannot get the slave
to parse the log files on the master.
The slave is connecting to the master as indicated in the log file.
I have tried to
Send the set autocommit=0 just as you send any other query in perl.
Bob Boden wrote:
Attempts to disable auto-commit mode in Perl using the DBI command
$dbh-{AutoCommit} = 0; returns the following message, Transactions not
supported by database.
I am using the latest version of MySQL-Max
Look again.
/usr/local/mysql is owned by root.
Mark Gillett wrote:
Hi all,
Have built mysql (mysql-3.23.49.tar.gz)
--prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enable
-assembler
on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended
patch
That is really odd, because I don't see a select statement anywhere.
Mary Stickney wrote:
SQL QUERY SQL QUERY
I inserted a row , and set the sales to 0 for the years that there is none ,
and set the sales to the sales amount for th years
that there were some
INSERT INTO TempSap
Let us know how your support issues are addressed when you have your
first problem.
Mine were never even acknowledged on the postgresql group.
That was the reason I went with MySQL. I have never regretted it.
Norris, Joseph wrote:
Group,
I have to move my work from Mysql to Postgres (
Empty strings are NOT nulls.
They are just zero length strings.
Aron Pilhofer wrote:
Changing the column to allow NULL doesn't mean that any of the existing
values will be *changed* to NULL. That seems to be what you're expecting,
but why?
No, no. Maybe I didn't explain well enough. The
It is not a bug.
As soon as Computer1 releases the lock,
Computer2 will have its query processed.
Never write a program that keeps a lock for more than a few miliseconds.
Eric Cotting wrote:
MYSQL Server: 3.23.49a-log
MYSQL Client: 3.23.3 alpha
MYSQLGUI: 1.7.5
Operating System: Windows NT,
DO NOT run myisamchk while the server is running.
lorenzo.kh wrote:
Hi,
I am using mysql 4.0.0-aplha on win 2000 professional.
I install mysql in c:\mysql.
I write a script ( customerscript.txt) and i save this script in
c:\mysql\bin.
The contents of customerscript.txt I will paste at the
Check the files in the directory.
I bet they are not owned by mysql.
Cliff wrote:
Hi, I am trying to upgrade to 4.02 from 3.23.47 on FreeBSD 4.6. The mysql
database does not want to work for some reason, when I move my old mysql
database over the new one, it does not start up, giving an error
That is because source is a mysql client command, not as sql command.
It gets executed by the client 'mysql'.
The 'mysql' client reads it line by line, and passes the lines to the
server.
The server never sees the scriptfile.sql.
You will have to write a PHP modules that reads the file, and
Michael Zelina wrote:
This is an interesting idea... I thought about doing this,
but the variety of data types prohibited me from doing so.
Initially, I was going to make everything VARCHAR(80)... but
that seemed to be horrible for data storage purposes and would
prevent me from being
Did you also update the perl DBI modules to match?
Luca Bonci wrote:
Hello everybody.
I was running a web server with mysql-server 3.22.32-log
on a debian box and using perldbi as an interface
from html pages and mysql-server.
I upgraded the dedian package to 3.23.49-log and I am not able
As it may be for others,
I don't have access to a news feed, so it would be good-by for me.
Bart Burkhardt wrote:
hello list,
i think it would be better to have a mysql news server instead of this email
list. i will name some reasons that i think of, correct me if i am wrong..
- with a
If the columns are defined as not null, just add a unique index on all
the fields.
alter table ignore add unique(col1.col2.col#);
walt wrote:
Does anyone know a good way find and remove duplicate records from a table?
I can create an identical table structure and use a script to pull records
select name, amount from myTable order by amount desc limit 1;
destr0 wrote:
If I hav a table myTable:
id nameamount
1john2 2joel 15
I want to get the name of the person with the largest amount.. but I
can't seem to
SQL does not exist in a vacuum.
You have to run a client.
The client is part of or runs under some scripting language ( perl ,
php, sh, command.com )
which in turn runs on an operating system.
You have to somehow pass values that you want to select, update, or insert.
So it really not possible
for mysql.
Open your OSX manuals and start reading.
David Houghton wrote:
On Thu, 25 Jul 2002, Gerald Clark wrote:
create a group called mysql
greate a user called mysql, and make it a member of the mysql group.
There is no groupadd or useradd command on MacOSX
mysql doesn't own the table or database.
Jeff Dyer wrote:
I am developing a new application using MySQL instead of MS SQL Server 2000,
I have just shelled out for the Microolap Delphi SQL DIrect Access
Components, having successfully converted an existing SQL Server database to
MySQL.
HOWEVER,
William R. Mussatto wrote:
On Wed, 24 Jul 2002, Dermot Paikkos wrote:
Date: Wed, 24 Jul 2002 17:46:00 +0100
From: Dermot Paikkos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: how to update time field with current time?
Hi
Probably a silly question but how can I set a time field to the
Your application uses the field size and type to validate the data
BEFORE sending it to MySQL.
Norris, Joseph wrote:
Hello,
What you say below is of great interest to me. Currently I have been
writing front end code to handle the size
issue but I would like to be open to other
Pete French wrote:
We are discussing the 'mysql' client which is often used to write
scripts that run under the
UNIX shell.
...
If you write a script that has two semi-colons in a row, the second one
is ignored and no error message is given.
Err, not true (in amysql script anyway)
Cindy wrote:
I seem to be destined to become an expert on restarting mysql and
dealing with passwords despite myself :-). This time I'm working on a
slight variation: restarting mysql on a machine that we haven't been
using for some 18 months and that I myself have never used.
Mysql appears
20 simultaneous cartesian products on large tables would be expected to make
any sql server busy, not to mention use a lot of temporary disk space.
Are you sure you are not running out of disk space?
Andrea Carpani wrote:
Here's my problem:
I've just installed mysql version 3.23.51 (before
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors be before you are notified?
Alain Williams wrote:
Hi,
I thought that I would report a very minor bug that I have just found
Alain Williams wrote:
On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
From: Gerald Clark [EMAIL PROTECTED]
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors
Does mysql own master.info ?
If you copied it as root, mysqld probably can't read it.
Nicholas Stuart wrote:
Hello all. I have been trying to add a second slave to my server but have
come up to a hopefully easy problem. The first slave is up and running
fine, but after copying down the master
Run myisamchk BEFORE you start the server!
William_dw -- Sqlcoders wrote:
Hiya,
We're running a 1gz server which crashed around an hour ago and I'm trying
to find out why,
it's averaging 60 queries per second according to mysql status and I figure
that's why the server crashed although it had
You can see them because you are root, and you own them.
Mysql can't see them because it is mysql.
chown -R mysql /var/lib/mysql
Richard Fox wrote:
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm'
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.
How
print them to a log file, and
tail -f logfile
from another window.
Fei Chen wrote:
Dear all,
I'm trying to write some UDFs and it will help a lot if I can print
debugging information out directly to the screen so I can see what's going
on. But printf() etc does not print to the mysql client
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 continue
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 problem
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
Also
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 MyISAM
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
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 Kramer
Cc: [EMAIL PROTECTED]
Subject: Re: Can access DBs when
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
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 Windows NT
1 - 100 of 544 matches
Mail list logo
