Hi Charlie,
Don't worry, all questions are OK. :-)
Instead of trying to double-click mysql.exe, open your Command Prompt
and, assuming the mysql\bin directory isn't in your PATH, navigate to to
mysql\bin directory and run mysql from there or specify the full path.
e.g.
C:\cd \mysql\bin
Sorry for repeat email...but this seems like an omission in mysql
functionality.
Sooo many apps come w/pam support, or the ability to use ssl.
I realize that in order to use an ssl cert, you'd somehow need to lookup the
subject dn in the cert and go against ldap to get a uname/pwd, etc.
From a
Daevid Vincent [EMAIL PROTECTED] wrote:
I have my schema set so that a field in a table has a default value of 16.
I also have a script that initializes the database, but I don't want to
delete the record since I want the other fields' data preserved. Is there a
way to find out what the
Bill Leonard [EMAIL PROTECTED] wrote:
Let me preface this by saying I am not a MySQL guru myself, but more of a
general sys admin... !
One of our users is trying to execute the LOAD DATA INFILE command (using
PHP to talk to MySQL). It is failing for some reason... Everything I believe
is
After successfully setting up PostgreSQL and better understanding the user and
permission problems I attempted to reinstall mySQL which had been running but
b/c of permission stuff i could only access databases that began with test.
I installed the OS X bundle with Startup module and then got the
I have this statement that works perfectly fine in Access and MSSQL: (In
words, i first get the top 50 id values according to the where clause and
then i get the maximum of those id values)
SELECT Max(id) FROM (select top 50 id from systemevents where infoId in
( 3 ) AND id 100 order by id
Ion-Mihai Tetcu [EMAIL PROTECTED] wrote:
I had set up replication between 2 4.0.14 servers and everything seems to work OK.
Except that SHOW SLAVE HOSTS on muster returns nothing. What am I missing ?
Use report-host option on the slave:
Use the LIMIT clause in mysql instead of TOP clause for access and mssql.
Luck !
- Original Message -
From: Wajih-ur-Rehman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 12:22 PM
Subject: plz help
I have this statement that works perfectly fine in Access
I know about this limit statement but even if i write the following query,
it *still does not work* because of the nested select statement:
SELECT Max(id) FROM (select id from systemevents where infoId in ( 3 )
AND id 100 order by id ASC LIMIT 50) AS t1
- Original Message -
Dear Toro Hill,
Thank you for the gentle explanation,
I believe you mean this:
Hence it is not possible to insert, update or modify anything into
TABLE PRODUCT_ORDER
Because :
No is auto Increment, cannot be directly manipulated,
product_category
product_id
customer_id
Hi,
All my MySQL users have access to all databases and all tables, allthough
I've only given them access to one.
How can I correct this?
Is it possible to have them *only* see their database when i.e. typing 'show
databases;', and also refuse them connection to any database but their own?
Hi,
I have a serious problem with a site. It's a ASP site running on IIS5 and
MySQL 4.0.15.
I have a DECIMAL(10,2) field in a table. I've now experienced that on some
days, the decimal digit is ignored, meaning that a value of ie. 14.00 is
represented af 1400, 135.00 as 13500.
I have search all
I have two MySQL machines, each is both master and slave for each other (to
en sure high availability).
Then today I rebooted one machine, and when the machine came online again,
the other machine did not replicate from the rebooted machine any more.
Why can that be, do I have to do something
Hello
I often get these errormessages. Why?
* X clients is using or hasnt closed the table properly
(No clients are using the table.)
* found X parts, should be X
* table is marked as crash
(table stopped working, i need to repair it)
Im using mysql-nt 4.0.12
Myodbc 2.x on some
I have four tables that i'm trying to join together most are pretty
small(100-200 rows tops) and one, the Response table is 127,000 rows. The
query i'm currently executing is
SELECT Business_Unit.Business_Unit, Question.Text_Long, AVG(Response) from
Question
INNER JOIN Response on
S?ren Neigaard [EMAIL PROTECTED] wrote:
I have two MySQL machines, each is both master and slave for each other (to
en sure high availability).
Then today I rebooted one machine, and when the machine came online again,
the other machine did not replicate from the rebooted machine any more.
H?kon Nilsen \(Exinet AS\) [EMAIL PROTECTED] wrote:
All my MySQL users have access to all databases and all tables, allthough
I've only given them access to one.
How can I correct this?
Do you have entry for anonymous user in the table 'user'?
Is it possible to have them *only* see
Thank you for the response Victor!
On 9/22/03 4:02 AM, Victoria Reznichenko [EMAIL PROTECTED]
wrote:
One of our users is trying to execute the LOAD DATA INFILE command (using
PHP to talk to MySQL). It is failing for some reason... Everything I believe
is set properly, i.e:
- the user has
Dear all,
At the moment I'm working via an R (geoR) MySQl for the querying,
analysis and displaying of geographical data. The problem is that this
is not a GIS environment.
Does somebody not how I can query results via ARC INFO (or another
GISpackage) out of our mySQL database and create a
Thank you, Egor,
I *had* the anonymous user, but I deleted it since I couldn't find the use
for it. But I figured out what the problem was. I was
using --safe-show-database, but it didn't seem to work.
My error was that I gave users privileges. I also gave the privileges to the
user on the
Gilmore, Jason [EMAIL PROTECTED] wrote:
A mysqlhotcopy issue has stumped no less than three of us here today at
work, ensuring that the solution is glaringly obvious. We're trying to
use mysqlhotcopy to copy a few databases. We want to make a local copy,
nothing exotic, just want to move the
Hi group,
Is there anything I need to set in MySQL in order to use USER variables?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL
Will someone tell me the real difference between FLOAT numbers and DECIMAL numbers?
What are the implications when I use either of those types?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office
On OS X, when issuing the top command in the CLI, my pageouts value is:
large number (0)
eg: the number in parentheses is zero, but the other number is large.
Is this a sign of a problem? It's a rather busy server with around
80 databases totalling 500MB or so. If this is a problem, how do
Hi there,
My problem at this time is following: I have a table of position
bookings, having information of a position code, beginning time of the
booking and end time:
Pos | Begings | Ends
APP | 2003-09-30 11:00:00 | 2003-09-30
Jeff,
Try creating a new index on Question containing just the question_key field,
and try it again.
Andy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 22 September 2003 13:23
To: [EMAIL PROTECTED]
Subject: join not using first primay key, per explain
well, I am working with mysql for less than 2 months so I may not give you
right answer but I guess we cannot solve this problem without programming.
The point is how to combine the times to have a one POS with continuous
time. this query is an example to combine to records:
SELECT table1.pos,
John May wrote:
On OS X, when issuing the top command in the CLI, my pageouts value is:
large number (0)
eg: the number in parentheses is zero, but the other number is large.
Is this a sign of a problem? It's a rather busy server with around
80 databases totalling 500MB or so. If this is
I need help with the proper syntax of my INSERT
Statement.
I have spoken to the support staff of my RADIUS
Vendor they stated that enable to support SHA
The Coolum for password has to have the encrypted
password prefixed with {SHA} not just the hash
I need to include the literal string of {SHA}
I know this may seem like a trivial question, however I am
new to SQL and it's syntax.
I need to know what the difference between single 'quoting'
and double quoting a string. When and why do I use one
or the other,
Any help answering this would be greatly appreciated.
Thanks
Jeff Stout
CSG
Does anybody know what this error is all about? and how do to get rid of
it... It started when I upgraded 4.0.13 to 4.0.15
---
030922 5:17:30 InnoDB: Error: page 1 log sequence number 0 768348475
InnoDB: is in the future! Current system log sequence number 0 330400180.
InnoDB: Your
One of the developers is having a problem optimizing a table in MySQL
4.0.14-standard on Solaris 9. The optimize seems to succeed but when he
tries to access the table with a SQL client, we get an error of
something to the effect that MySQL cannot fine MESSAGES.MYI. After
running 'myisamchk -o' on
Hi,
I am trying to install Mantis on Linux but I am totally new for linux as
well as for Mantis.
I have managed to install Linux. I was not sure which components are
required for Mantis So I have selected all the components. Now my Linux is
UP and need you help for the further installation.
Gustavo,
- Original Message -
From: Gustavo A. Baratto [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, September 22, 2003 7:33 PM
Subject: innodb
Does anybody know what this error is all about? and how do to get rid of
it... It started when I upgraded 4.0.13 to
Jon Hancock [EMAIL PROTECTED] writes:
When you issue this null ALTER TABLE, is the entire table locked
during the build?
The table is read-only during the build.
i.e. Is the only way to defragment to effectively take the table
offline during the rebuild?
Well. Not quite offline, but
as I know, there is no any difference between single and double except the
environment. in ANSI mode, just you should use single quotation. for more :
http://www.mysql.com/doc/en/String_syntax.html
- Original Message -
From: Stout, Jeff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
At 4:22 PM -0400 9/19/03, Jeff McKeon wrote:
We've got mysql 3.23 installed on a redhat system via the rpm's that
come with RedHat 8.0. I'd like to change the default data
directory so
something other than /var/lib/mysql. I know this is supposed to be
possible with a start switch of
Your not using mysqlhotcopy correctly.
/usr/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory]
The problem is this
mysqlhotcopy -u root --suffix=091703 staff /backups
look at -u
here is a format from inside mysqlhotcopy
mysqlhotcopy --method='scp -Bq -i
I mean look at the --suffix
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
--Sent: Monday, September 22, 2003 1:26 PM
--To: 'Gilmore,
Director General: NEFACOMP [EMAIL PROTECTED] wrote:
Is there anything I need to set in MySQL in order to use USER variables?
No. What is wrong with user variables for you?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
At 06:04 PM 9/21/03 -0700, Ray Tayek wrote:
hi, trying out opnecms. so i installed mysql on slak 8.0. added a root
password (something like ... root password opencms) like the doc says, so
i can do a: use mysql and create databases and tables if am root on the
slak box. but only if i am root.
What follows is a short story, all true and quite stressful. No database
servers were harmed in the making of this server, but a couple were
threatened with loose rack mount rails.
We are trying to move over to InnoDB, but we have a few problems that we
just can't figure out:
First, for some
Hi,
This is more of a PHP question, but I can't find the answer.
I'm trying to generate a string that contains a br, to insert into a MySQL
table. It appears the br is being stripped out either just before or
during the update.
** code **
// has both info, update both
$ad_contact = $tr_email;
Dumb Question. I need to move my data from their current access database to my new
MySQL server through an ODBC connection. The tables on both ends are set up
identially. I have added a linked table to the access database called EXPARTAB1. The
data is in EXPARTAB. I tried: INSERT INTO
Ok well I reinstalled again and it seems to be working ok now. Thanks anyways ;)
--- Matt W [EMAIL PROTECTED] wrote:
Hi Charlie,
Don't worry, all questions are OK. :-)
Instead of trying to double-click mysql.exe, open your Command Prompt
and, assuming the mysql\bin directory isn't in your
is there a trick to saving Excel spreadsheets into a CSV format that will
import into MySQL or phpMyAdmin reliably?
my CSV files get jumbled up, if they load in at all. There is a bug i have
been told concerning columns that contain alphanumeric and just numeric
fields.
I use Excel [office 2k
46 matches
Mail list logo