Hi,
If I understood your message right, the answer is no. The only place
passwords are stored is the mysql database, so they're physically located
in the mysql.MYD file. They're encrypted there, too.
Iikka
**
* Iikka Meriläinen *
*
Did you flush-privileges?
--- Sandra [EMAIL PROTECTED] : Hi all,
I am getting the error when trying to connect server
from my client:
Warning: mysql_num_rows(): supplied argument is not
a valid MySQL result
resource in .
I had my tables in test database, but created a new
Its a PHP function my friend. I'm using 3,23...
--- DL Neil [EMAIL PROTECTED] :
Nick,
Explode: which version of the MySQL manual are you
using?
=dn
- Original Message -
From: nick gatsis [EMAIL PROTECTED]
To: Carlos Fernando Scheidecker Antunes
[EMAIL PROTECTED]
Cc: [EMAIL
Check some articles in
http://www.devshed.com/Server_Side/MySQL,
http://www.devshed.com/Server_Side/PHP
--- JeRRy [EMAIL PROTECTED] : Hi,
I am trying to setup a PHP form to send to mySQL
database. I know how to connect to mySQL but need
help getting the information in the form to
Is it possible in Mysql to search in 2 databases with only one search
statement?
Thanks
ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi
I am putting together a software which is based on MySQL, now I would
like to redistribute MySQL with my installation package, what do I need
to comply with?
Regards
Tobias
Tobias Eriksson
ComOpt AB
Michael Löfmans gata 6
254 38 Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42
Hi,
If wish to search on two database which are in the same server machine , the
answer is yes.
Ex:
DB A,with table A1
DB B,with table B1
select * from A.A1,B.B1;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
Volkan,
Friday, August 09, 2002, 4:53:56 PM, you wrote:
Vy I have already writen
Vy --default-character-set=..
Vy sorry about that i just wrote it wrongly in my
Vy message.
Vyelse
Vy If i write
Vy mysqld --default-character-set latin5
Vyit gives the error message:
dane,
Friday, August 09, 2002, 10:53:30 PM, you wrote:
dr My phpBB forums, say if i make a post, then it goes to the post, but
dr nothings there, so i have to go to index.php for it to show (and it will log
dr me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it
dr would
Ilyas,
Monday, August 12, 2002, 11:22:52 AM, you wrote:
IK Is it possible in Mysql to search in 2 databases with only one search
IK statement?
Do you mean use tables from different database? If the databases are
located on the same MySQL server - yes.
For example:
SELECT * FROM database1.a,
Alec,
Friday, August 09, 2002, 2:01:10 PM, you wrote:
AC If I insert a number, say X, of records using a single statement of the
AC form
AC INSERT INTO table VALUES (...), (...), ..., (...)
AC then retrieve the LAST_INSERT_ID, say Y, is it reasonable to assume that
AC the records will be
John,
Saturday, August 10, 2002, 4:32:37 AM, you wrote:
JP I keep getting a problem with our MySQL database, I know what error 127 is
JP ('Record-file is crashed / Network is down'), it keeps occuring on several
JP tables that are frequently accessed by our website.
JP I can fix the problem by
Hi,
it's a bit late reply, to my original mail sent to bugs list. Now the
problem reappeared as the box got rebooted. I was receiving in
$hostname.err:
020812 11:34:20 mysqld started
020812 11:34:20 Can't find messagefile
'mysql-4.0.2-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys'
Tobias,
- Original Message -
From: Tobias Eriksson [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, August 12, 2002 11:30 AM
Subject: What is needed to redistribute MySQL with my software?
Hi
I am putting together a software which is based on MySQL, now I would
Nick,
Understood - but did Carlos say that he is using PHP, and why use PHP when a
more efficient/quicker MySQL solution is available?
=dn
- Original Message -
From: nick gatsis [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 9:06 AM
Hi all,
We have just recently inherited a web project from another company who's
DB was Oracle 8. And as such they have provided us with an exported .dmp
file of the database they were using...
We are using mySQL as our DB backend... Does anyone know of any tools
that will allow me to import
Hi Mike,
I am not sure, but as I remember Microsoft SQLServer has Import/Export
utility (standard installation) that can import data from different sources
(Oracle?! why not).
Best regards,
Mikhail.
- Original Message -
From: Mike Townend [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I think it will be very difficult to do. In Oracle export files the data is
written in Oracle's own proprietary binary format. I don't know of any tools
other than Oracle's own import utility that is able to read the .dmp file.
You may need to get them to send you a .csv file instead.
--Walt
Description:
I use replication circle (A-B, B-A) with 3.23.51 - all ok.
But I got problem, when upgrade both my servers to 4.0.2.
Mysqld create 30 new bin-log files every second at both servers:
---
[www2:/opt/mysql-dev/var]:1303# ls -1
We don't have access to the Oracle server :(
So as to a project handover to the client they just gave them the dmp
file...
Im currently downloading Oracle from the Oracle site but it's a major
download :(
Ive found a util that attempts to get the information from the dmp files
but this is
admin,
Saturday, August 10, 2002, 6:31:56 AM, you wrote:
a Many of you suggested that, in regards to my problem with LOAD DATA
a [LOCAL] INFILE ... , I may have permissions problems. I checked with
a the host and the reply was, You have access to do all commands except
a for the grant command.
Hi,
today I noticed a strange behaviour in MySQL 3.23.49a-Replication I can't explain.
A perl-script which controls whether master- and replication-tables are equal showed
me, that a master-table was missing on both slaves (two backups are better than one
:-) )
When I controlled the master
I hate to be so rude, but does anyone have an idea?
If it's really an obvious answer, please smack me upside the head.
Thanks,
-reid
Reid Sutherland (mysql) wrote:
Hi,
I'm using a program that makes many mysql connections. Now sometimes it
leaves a hung mysql process. When I run
Hi all,
How can I change the file paht c:\windows\my.ini.
Is possible I have two files because I want to start
two instances in same machine.
I would like to change like that:
- c:\windows\my.ini
- c:\windows\my2.ini
Regards
Alexander
sql, query
EMS HiTech company is announcing the next version (1.85) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.85?
1. Some
Hello Alexander,
Yes, it is possible. Start your mysqld(-max)(-nt) instances with
--defaults-file=C:\windows\my.ini option and it should work.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Viraj,
Friday, August 09, 2002, 5:14:00 AM, you wrote:
VKA Actually, in my redhat 7.1 distribution, it has only
VKA mysql-VERSION.rpm, mysql-server-VERSION.rpm and
VKA mysql-devel-VERSION.rpm only, it's missing it's client rpm.
VKA I checked with my previous 7.0 cd set, it's missing the
VKA
p.s., if you reply, kindly CC me as well.
hi, i have the following SQL query
select col1 from table1
where
col2 = 'xxx' or col3 = 'xxx'
how can i get rid of this OR? due to my table design and the logic
involved, i have to check both these 2 columns (in a search function). i
cannot
Hi,
in the version 4.0 mysql accepte this request? select where ... IN
(SELECT )
subqueries?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Interesting a spooky.
Try to use different cursor types. As you know, ADO,
or better said, OLE DB behaves (or misbehaves)
depending on the cursor. Have you tried a FORWARD and
READ ONLY cursor.
Good Luck
--- Menard, Inc. Information Systems
[EMAIL PROTECTED] wrote:
Evening
I think I'm
Description:
See previous bug report
Mysql crashes when executing simple query:
mysql delete from statcache where spamdate 1028304682;
ERROR 2013: Lost connection to MySQL server during query
Table def:
CREATE TABLE statcache (
reportid int(10) unsigned NOT
when the version of mysql 4.1 is ready ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
i noticed this on the mysql website:
I found that when EXPLAIN gives unexpected results (like using another
index than the one you created especially for this goal), first running
ANALYZE TABLE on the involved tables helped a lot. I put an ANALYZE TABLE
for 10 or so key tables in the
If I have 4,000,000 records, and I just want to make sure that the last 100
records do not contain a certain value, ... how can I efficiently 'count'
the number of times in the LAST 100 records that a specific condition exists?
As an example,
mysql select COUNT(*) from Log WHERE
if you are using this while going through an API like perl,php,c,c++
then you could do a call like
select LogID from Log WHERE LogIP=10.0.0.22 ORDER BY LogID DESC LIMIT
100
and run mysql_num_rows() on the resultant mysql query object. hope this
is at least somewhat helpful.
Cummings, Shawn
Is anyone else still having problems with fulltext indexed tables using
4.0.2? Ours crashed over the weekend during an update, corrupting the
table. The server was left running, which is an improvement over the
behavior of 4.0.1, where the whole server would die.
The changes to the boolean
I already have my table structure in place in MySQL, and I just want to
import the data from my Access 2000 database. (the .mdb is about 50 megs)
The MySQL server is on a Linux system.
I've been using DBTools to do the import, because it allows me to import
just the data, and not create the
On Mon, Aug 12, 2002 at 12:55:32PM -0400, Cummings, Shawn (GNAPs) wrote:
If I have 4,000,000 records, and I just want to make sure that the last 100
records do not contain a certain value, ... how can I efficiently 'count'
the number of times in the LAST 100 records that a specific
There is a application out there that does this called SQLPorter made by
Real Soft Studio (http://www.realsoftstudio.com). It might be worth the $$
if it saves you some time and hassle. It worked for me going from SQL Server
6.5 to MySQL 3.23.
Hope this helps,
Tim
- Original Message -
Hey folks. I was getting some odd and unexpected results via a web query the
other day, and I finally traced the problem down -- but it lead me to wonder
if the problem was expected or a bug. Here's the deal:
When I initially created the MySQL table, I forgot to specify that I wanted
to allow
Hi DN.
If there is a quisker solution is OK to me. But i dont
know it. I believe that when a user (anybody) inserts
data in a database, you can sereate the information
you want that time. Then you just call the results
from the table (you have them ready) and dont ask the
server to work for it.
At 13:20 -0400 8/12/02, Aron Pilhofer wrote:
Hey folks. I was getting some odd and unexpected results via a web query the
other day, and I finally traced the problem down -- but it lead me to wonder
if the problem was expected or a bug. Here's the deal:
When I initially created the MySQL table,
Did you try to make an .csv file and then import it
with Mysql-Front?
I believe that both tables have the same structure.
--- Ian Zabel [EMAIL PROTECTED] : I already
have my table structure in place in MySQL,
and I just want to
import the data from my Access 2000 database. (the
Except I don't have any access whatsoever to the Oracle server... All I
have is a flat dmp file on a CD which has all the data embedded into
this file...
I have found a tool that will extract the table structure from this
file... But will not extract the data
Mike
-Original Message-
When I initially created the MySQL table, I forgot to specify that I
wanted to allow NULL in certain fields. I populated the table,
realized my mistake and then changed the field to allow NULLs. Here's
where things got weird: When I ran a select..where field is not
NULL against one of the
Julian,
the crash probably means the table is corrupt. That is a very basic query
you run. Difficult to believe in any bug in SQL itself.
Please dump your tables.
Then upgrade to MySQL-Max-3.23.51. It is best to use an official binary.
Then run CHECK TABLE on the table statcache. What does it
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 fields in question contained
NULL values from the beginning, when I populated them, even
Yeah, the table DDL in an Oracle export file is in ascii format. I've used
vi in the past to extract the DDL. You might be SOL though as far as reading
the data is concerned.
--Walt
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 11:42 AM
I don't think that's going to work because it sounds like the escapes are
built into the data. The only thing I can think of is to run it through a
function first to strip out said escape characters, and then import it. PHP
has a stripslashes() function that does that, and you certainly could
Nick,
I'm not sure if we're agreeing or not!?
If some selection/restriction can be performed within the database (designed
for efficient data retrieval) rather than when post-processing eg in PHP,
then it will be more efficient/faster. So if something can be done in either
the RDBMS or in PHP,
That is weird, I just created the same tables with the same data and it
returns 49 rows containing this:
| 8647 | FULL | 24 Henry Guesthouse| San Francisco | USA | San
Francisco | CA| CA| http://www.24Henry.com
| FULL | | 65.00 | 109.00 |1
Check out http://www.dbtools.com.br/EN/ I use it to import from access to
mysql. By the sounds of it though you have some dirty data which may or
may not need to be cleaned before going through there program. The only
real problem I had was that working with old dirty data is a pain since a
lot
Please, re-send me:
* mysqldump of the tables
* the exact UNION query that you ran
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/
sql,query
The current
behavior is what I'd expect to have happen, and what I'd expect most
people to expect to have happen. Maybe you just need to adjust your
expectations.
Paul/Keith:
OK, I see. It was a varchar field, so I assume it must have been entering
empty strings where
A better solution would probably be to implement a form of challenge
response authentication. (IE: Personal Question/Answer). This way, the
attacker has to know the challenge response to even begin the password
change transaction. Additionally, it is a security hole to email anyone
their
Hi!
On Aug 12, Ryan Barber wrote:
Is anyone else still having problems with fulltext indexed tables using
4.0.2? Ours crashed over the weekend during an update, corrupting the
table. The server was left running, which is an improvement over the
behavior of 4.0.1, where the whole server
In the simplest case, LanguageSkill and City are columns in the Persons
table. (That's the wrong way to do, IMO, but it is the simplest case.)
Suppose Language Skill is an integer column and City a char(50).
So your query becomes:
SELECT *
FROM Persons
WHERE LanguageSkill = 5
AND City =
hi,
in the version 4.0 mysql accepte this request? select where ... IN
(SELECT ) subqueries?
not implemented...
Lucas
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
If you're using InnoDB tables, replication stops the slaves from
running. Heikki said he'd try to get this fixed for 3.23.52.
--Pete
On Mon, Aug 12, 2002 at 04:05:11PM +0200, Lutz Maibach wrote:
Hi,
today I noticed a strange behaviour in MySQL 3.23.49a-Replication I can't explain.
A
In the last episode (Aug 12), Florian Litot said:
Hi,
in the version 4.0 mysql accepte this request? select where ... IN
(SELECT )
subqueries?
Most queries of this type can be rewritten to use joins.
--
Dan Nelson
[EMAIL PROTECTED]
Pardon my ignorance, what Linux table corruption and what versions of
Linux and MySQL are we talking about? I googled, but came back only with
4.4.6.7 Using myisamchk for Crash Recovery ... --skip-external-locking.
Not much help. I'm sorry if this is old news, but I thougth I was
following
hi,
i am writting a c program to connect to a mysql db and execute a bunch
of select and update statements. When I try to compile the source it works
properly but during linking i get this error:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
William,
- Original Message -
From: William R. Mussatto [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 10:29 PM
Subject: Re: Found cause of crash - simple SQL statement.
Pardon my ignorance, what Linux table corruption and what
Isn't it nice to find the answers to questions right after asking them and
before anyone else can answer
some link off google:
It appears that what's happened here is that
libmysqlclient wants to use the functions compress and
uncompress, which at a guess are the ones in libz (the GNU
zip
I am looking for a command to interpreter the timestamp field into a
date time field much like the Convert function in MSSQL. Does anyone
know of a built in function for this or will I be off on the road to
building my own function?
Thanks!
Best Regards,
Ben Turner
Hi, there,
I am trying to install MySQL 3.23.51 on Solaris 2.6 with gcc
2.95.3
but I got following message after a while of compiling. Would anyone
help me to solve the problem?
Making all in libmysql
gmake[2]: Entering directory `/snap/jimh/MySQL/mysql-3.23.51/libmysql'
gmake[2]: *** No
Ben,
I am looking for a command to interpreter the timestamp field into a
date time field much like the Convert function in MSSQL. Does anyone
know of a built in function for this or will I be off on the road to
building my own function?
Beginning with v4.0.2, CAST | CONVERT( value AS type
Is this command supported under version 3.23.51?
SHOW NEW MASTER FOR SLAVE WITH MASTER_LOG_FILE='logfile' AND
MASTER_LOG_POS=pos AND MASTER_LOG_SEQ=log_seq AND
MASTER_SERVER_ID=server_id
What does MASTER_LOG_SEQ refer to?
sql
--
Keith Johnson
NetCentral, Inc.
phone: 615.777.5304 x:13
fax:
I'm trying to use a program to create data base remotely (in Windows)
and returns the error host is not allowed to connect to this MySQL
server. What's necessary to configure in MysSQL (in FreeBSD)?
[]'s
Karina.
-
Before
In light of recent vigorous discussion on SlashDot
concerning MySQL vs PostgreSQL vs SAPDB, etc... my
management is contemplating dropping MySQL support :-(
in favor of PostgreSQL or Firebird/Interbase and I
need some help/ammo from you guys to defend MySQL.
Here are the concerns:
1) ACID
Hello,
Does anyone know how to enable concurrent_insert with mysql version
4.0.x. I can't seem to turn it on no matter what I do.
Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
1) ACID compliant transaction support. There is
concern as to whether InnoDB is ready for prime time,
especially as regards backups and our 24X7 needs. Our
databases can grow very rapidly and we can't afford to
bounce the database just to add datafiles as is
currently required for InnoDB.
Hi all,
I am using mysql 3.23.49 solaris platform.
I used load data local infile command to load tables.
I got NULL entries in my rows (i.e. some rows have null in all fields) and
since I executed this command twice I got same entries twice.
I tried to remove null rows by doing:
delete from book
Thanks for the response,
Regarding...
Don't get me wrong, [subselects are] neat to have,
but I really don't mind waiting...
Are there other factors?
Yeah, we have SQL dynamically generated from SQL
Generator code which is bombing out with queries
having 32 table joins and this will
Hi,
We are looking for load balancing and high availability system for MySQL+InnoDB
servers. Does anybody have an experience in MySQL clustering ?
At this time we study Mosix with MFS-DFSA but we are not sure that is the best
solution because a shared memory problem. The DBBalancer seems to be
hi all,
i have a problem with load data... statement. i'm using MySQL 3.23.49 from
RedHat 7.3. i read Paul DuBois book about MySQL, and tried to load data to
my member table,
mysql LOAD DATA INFILE member.txt INTO TABLE member;
but i didn't work.
i've tried by removing the 'local', but it
At 2:16 + 8/13/02, LR P wrote:
hi all,
i have a problem with load data... statement. i'm using MySQL
3.23.49 from RedHat 7.3. i read Paul DuBois book about MySQL, and
tried to load data to my member table,
mysql LOAD DATA INFILE member.txt INTO TABLE member;
but i didn't work.
What was
I have been searching for a way to restrict access to a database. So
far all I see that is possible is to grant access to databases. What if
I want a user account to be able to access every database except for the
mysql database? There is no way to do this without running grant
statements for
At 21:39 -0500 8/12/02, Jason wrote:
I have been searching for a way to restrict access to a database. So
far all I see that is possible is to grant access to databases. What if
I want a user account to be able to access every database except for the
mysql database? There is no way to do this
Hi,
I am using the following code for a username /
password combination. A java box appears which the
user needs to input a username/password. This works
fine, BUT how do I make it so if the user wishes to
logout they can? I've tried closing the browser on
many browsers but on some you remain
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Where are places to obtain information about the Perl API for MySQL?
Is there possibly a list specific to that topic?
Thanks.
-BEGIN PGP SIGNATURE-
Version: PGP Personal Security 7.0.3
Dear Sir/madam,
we are able to connect Mysql database using JSP in Linux RedHat-6.2 OS
(with out using user and password).
when we are trying to connect using user and password it was not able to
connect.
We wrote code like this
String DBUrl =
hi
Is there anyone can solve my problem with query...i have two table as
below:-
Table employee
--
ID position name
--
AManagerAA
BClerk BB
cClerk CC
Table Leave
---
ID approval status
-- --
B A
Hi all,
I am using mysql version 3.23.47 on RedHat linux 7.2. I found that the
permission I have granted before, for example, login the mysql server
and execute 'grant select on *.* to [EMAIL PROTECTED] identified by
test; flush privileges'. Then I can access to the mysql server from
the
84 matches
Mail list logo