Hi All
It seems that compiling MySQL on a Solaris 8 box is a non-trivial task if your
environment is different to the MySQL developers (whatever that is). It has
taken me a couple of days, hacking & trawling the mailing list to get a
successful compile. I thought I would share my findings with ot
I'm using MySQL 3.23.38 as master and MySQL 3.23.49 as a slave in a simple
replication.
I configured the system as the manual said, using the default bin-log on the
master (www-bin.001)
The problem is that every night (at 5:00) the replication stops. The
master.info file on the slave server s
--- Darren Young <[EMAIL PROTECTED]> wrote:
>
> -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?
==> Try out search key words: "DBI Perl tutorial" in
http://www.google.co
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 cl
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
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 =
"jdbc:mysql://localhost:3306/database
-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
iQA/AwUBPViONutdIID34ZgYEQLPQACfTkcpF5O7nklg3vkeNPtJP
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
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 th
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 e
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.
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 i
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 a
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 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
> 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 Inno
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)
h
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 compli
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 posti
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: 615
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 t
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
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
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 com
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 corrupti
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':
my_compress.o(.text+
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
followi
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]
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
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)
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 = 'London'
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 serve
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 passwo
> 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 strin
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
/_/ /_/\_, /___/\___\_\___/ Larnac
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 of
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 |
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, the
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 wri
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
To
> 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, ev
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
> 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 is not
> NULL" against one of the f
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-
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]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > I already
> have my table structure in place in MySQL,
> > and I just want to
> > import the dat
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 tab
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.
If
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 NUL
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 -
S
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 condit
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 tabl
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 se
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, Sh
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 LogIP="10.0
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 nigh
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 PROTECTED
>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
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
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 l
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
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
VK
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
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 improvements
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
__
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 m
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 upda
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" com
I am just in the process of migrating a few sites from Oracle to MySQL. I
had access to both servers and wrote a little PHP program that queried one
and wrote to the other. I think that will be your best bet. Install a
temporary Oracle server import the DMP file. I used a utility called TORA
t
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 fail
>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 ww
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 Wea
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]>
Se
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 t
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
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 wo
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'
0
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
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
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,
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> wo
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.
Vy>else
Vy> If i write
Vy> mysqld --default-character-set latin5
Vy>it gives the error mes
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 PROT
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 38
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 ar
Check some articles in
http://www.devshed.com/Server_Side/MySQL,
http://www.devshed.com/Server_Side/PHP
--- JeRRy <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hi,
>
> I am trying to setup a PHP form to send to mySQL
> database. I know how to connect to mySQL but need
> help getti
Its a PHP function my friend. I'm using 3,23...
--- DL Neil <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
Nick,
> Explode: which version of the MySQL manual are you
> using?
> =dn
>
> - Original Message -
> From: "nick gatsis" <[EMAIL PROTECTED]>
> To: "Carlos Fernando Scheid
Did you flush-privileges?
--- Sandra <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > 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
87 matches
Mail list logo
