years How can I do that
Regards
Vivek Aggarwal
Hello-
I am looking for "ELF-64 relocatable object file - PA-RISC 2.0 (LP64)"
platform binaries for 4.1.8 mysql. Please lemme know where I can
download this from?
Thanx,
Vivek
PS: I downloaded this from the mysql.com
mysql-standard-4.1.8-hp-hpux11.00-hppa2.0w
ptdh172:vk
Hello all,
I am going to migrate a MsAccess database to MySQL. I
wanted to know if somebody ahs doen it and what
problems you might face and workaround them if
possible.
Also, do let me know if my query is broad??
Reagrds
VK
___
can access
this interface again.
Please note that I am able to use root login for all other purposes but
Webmin does not allow to enter into MySQL Interface only.
Regards,
Vivek
-
Before posting, please check:
http://www
ata of the source tables and the
columns. So I don't understand why should/would it change the data
types of columns.
thanks
Vivek
> -Original Message-
> From: bvyas3 [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 6:36 PM
> To: CHAUDHARY, Vivek; mysql
> Cc:
(30),
address char(50)
any clues,
Vivek
-
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 <[EM
e-B TO table-A;
3) You can try;
ALTER IGNORE TABLE table-A add unique (columns_with_unique_values);
Be careful in using this as there are some issues with this.
cheers
Vivek
> -Original Message-
> From: oswaldo [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 26, 2
picked up this
DB because it costs nothing. And now it has come on me to maintain it
apart from maintaining Oracle, Informix, Ingres etc.
once again thanks for your help.
Vivek
> -Original Message-
> From: kenm [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 5:2
Has anyone got Erwin working with mysql. I guess all directly
non-supported DBs by Erwin are suppose to work via ODBC but I have not
been able to find ODBC driver (either generic or for mysql).
thanks
Vivek
-
Before posting
server hung-up. But even after
users got out it was in the hung state. Nothing in the error log files
to give any clues.
thanks
Vivek
> -Original Message-
> From: joseph.bueno [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 19, 2002 1:18 AM
> To: CHAUDHARY, Vivek
> Cc:
Since I didn't get any response (like mysql server) I am sending it
again.
thanks
Vivek
> -Original Message-
> From: CHAUDHARY, Vivek
> Sent: Wednesday, April 17, 2002 3:34 PM
> To: '[EMAIL PROTECTED]'
> Subject: Mysql unresponsive
>
>
>
commands, scripts
that could test for inactivity etc.
Needless to say that I am a newbie on mysql front.
Vivek Chaudhary
Database Administrator
"IT" STMicroelectronics, Phoenix.
Phone:(602)485-2271
Fax: (602)485-6402
Cell:(602)363-1492
Email: [EMAIL
So far I have seen this feature in Oracle and DB2 alone. I am yet to
find any other RDBMS.
Vivek Chaudhary
> -Original Message-
> From: len [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, April 13, 2002 7:10 AM
> To: mysql
> Cc: len
> Subject: Bill-of-Materials
>
what's there now, since they seem to be ignoring the
MIPS based equipment lately.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivek
Your filter really makes having a discussion difficult. I think I'll
just go away.
> "m" == mysql <[EMAIL PROTECTED]> writes:
m> Your message cannot be posted because it appears to be either spam or
m> simply off topic to our filter. To bypass the filter you must include
m> one of the fol
> "DF" == David Favor <[EMAIL PROTECTED]> writes:
DF> The problem is the Web hosting service I use does not have this
DF> package installed. In other words, there is no libpthreads.* in
DF> any of the library directories.
But FreeBSD native threads do not need any libpthreads.* files. Your
p to the language interpreter and optimizer to do it efficiently.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vive
> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes:
MW> We are just now building the first MySQL-Max binaries with support for
MW> Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM
Does this imply that BDB tables are stable enough for production use,
or is it still con
dexes
on nullable columns. ISAM did not.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: v
#x27;3',2
and resulting in a parse error. The fix was to call
$sth->execute($start+0,$howmany+0) and then DBI did the right thing.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTE
> "GC" == Gerald Clark <[EMAIL PROTECTED]> writes:
GC> Perl/DBI, or any mysql client on Linux should connect to mysql on NT
GC> with no problem. Why would you need ODBC?
Except that perl/DBI requires an underlying C library for the DBMS in
question. I understand that the sybase libs might
il. Perhaps you need to write a program that
queries the database and then sends the mail you want.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-45
not
stable.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.
> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes:
MW>* Added `SET TRANSACTION ISOLATION LEVEL ...'
How about documenting this?
http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite
uninformative as to what the different levels mean.
--
be sure to download the instructions with it.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
---
ed to evaluate them both yourself probably with some
benchmarks and then decide which is "better".
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD
ary...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vi
e the japanese charset while leaving the other tables and DBs alone
(using default Latin1)? Is this possible withour running multiple
instances of mysqld?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [
see
what it has to say.
Also, what are your mysql permissions (from the GRANT commands you've
issued) for your currently logged in user? Also, is the mysql daemon
process allowed to write to the directory you are asking it to write
to?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
an
if ($$types[0] == &Mysql::FIELD_TYPE_STRING)
you are doing an assignment, not a comparison.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-
le the position of B can be left
what's wrong with
INSERT INTO goo (A,B) VALUES (NOW(),A)
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-45
build mysql from ports.
I'd highly recommend upgrading to FreeBSD 4.2-STABLE so that you also
get the very important C++ library/compiler fixes.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PR
ete things in batch size of $limit (I use 200 rows), and
sleep between the deletes to let other threads do their thing with not
too much delay.
Ideally, MySQL would allow the delete to be concurrent with other
operations.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Viv
MAIL PROTECTED]>
M> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
M> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL
ote I have to add is that if you also use php4 with mysql
built-in, then absolutely make sure that php is built to use the
system mysql library and not its own copy.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, In
s
d> probably an easy fix but here goes. When I try and run
Your best bet on FreeBSD is to build the MySQL port form /usr/ports.
It is really well done.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Inte
trate
if it is incorrect.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera htt
>"-lm" has been specified in the linker option line.
Before or after the -lmylsqlclient flag? It needs to be after.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EM
> "MK" == Mikel King <[EMAIL PROTECTED]> writes:
MK> guys I think you are making this a way bigger problem than it
MK> really is...e-merce crap is generally taxed based on the location
MK> of the vendor; much the same way in which mail order businesses
MK> are taxed. You really only have to w
> "BR" == Brian Reichert <[EMAIL PROTECTED]> writes:
BR> When I try to do a mysqldump on the localhost, I get an out-of-memory
BR> error:
BR> # mysqldump -uroot -proot customer audit_trail_271
BR> mysqldump: Out of memory (Needed 8164 bytes)
BR> mysqldump: Got error: 2008: MySQL client
> "TT" == The Tilghman <[EMAIL PROTECTED]> writes:
TT> You're trying to use a Telnet client with a MySQL server. Instead,
TT> use a MySQL client with a MySQL server and a Telnet client with a
TT> Telnet server. Mixing protocols doesn't really work for anybody.
well, you can use the telnet
> "RD" == Russ Davies <[EMAIL PROTECTED]> writes:
RD> Thanks for the suggestion, but this would still mean converting the data
RD> type from within ASP (the 'True' type) down to a char ('T') would it not?
then use
ENUM('False','True')
instead. Enum can have any string you want. I person
> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes:
DK> 30gb eide hdd
DK> Will the machine fall over because it doesn't have enough ram/CPU
DK> power (for about 20k users per week as below)? any ball park
DK> comments eg no worries, close call, not a chance?
Your bottleneck on a database is
> "NR" == Noah Romer <[EMAIL PROTECTED]> writes:
mysql> insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue)
NR> values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
NR> ERROR 1064: You have an error in your SQL syntax near
NR> 'when,field,oldvalue,newvalue) values
NR>
> "RH" == Rolf Hopkins <[EMAIL PROTECTED]> writes:
RH> That also depends on your definition of *PRODUCTION* status. If you are
RH> going to make a profit using MySQL then you need to purchase a license.
Not any more; MySQL is GPL in the current version.
--
I beleive, is that Oracle finds MySQL such a threat to
their business that they have to put out a migration kit to make it
easy for people to switch to their product.
It shows that the popularity of MySQL is being taken seriously by the
majors.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> "EJD" == Evan James Dembskey <[EMAIL PROTECTED]> writes:
EJD> is it possible to install Gnu make onto teh Dec in a way that it does not
EJD> interfere at all with the rest of the system? If so, how do I do it?
When you install gnu make, call it "gmake". Then run "gmake" when you
need it.
ing?
See mysqlhotcopy that comes with recent mysql versions.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera
> "TS" == Tim Samshuijzen <[EMAIL PROTECTED]> writes:
TS> We're running a large database on a dedicated server.
TS> When I look in the list of active processes, I notice that a
TS> complicated query takes up no more than about 30 % of CPU.
TS> During this time the CPU is more than 60 % idle
> "GLC" == Gerald L Clark <[EMAIL PROTECTED]> writes:
GLC> You do not say what version you are running.
GLC> Older versions did not allow updating the primary key field in that
GLC> manner.
he's not updating the primary key field.
nuary (ie, update FreeBSD to 4.2-STABLE).
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vi
> "jds" == j d stumbles <[EMAIL PROTECTED]> writes:
jds> I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
jds> updating the tables concerned continuously, via REPLACE INTO, INSERT INTO
jds> or UPDATE statements.
I've never had table corruption on a Solaris box, even
> "AH" == Alan Halls <[EMAIL PROTECTED]> writes:
AH> Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an
AH> error during the make command.
Using extreme powers of mental telepathy, we might be able to guess
your problem. However, if you told us exactly what the erro
cs are just made
up, I made one up for you ;-)
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
> "AR" == Ann Ricchiazzi <[EMAIL PROTECTED]> writes:
AR> I am trying to choose between mySQL and Oracle for a Linux server. My
AR> specific questions are:
AR> 1) Will mySQL handle 3000 hits/day well?
You need to define what a "hit" is. Is it a simple select on the
primary key of a single t
> "l" == lkeeton <[EMAIL PROTECTED]> writes:
l> First does anybody know the website address for that searchable
l> site that allows you to search on mysql archive emails. I would
l> appreciate if I could get that. I also am looking for opinions on
Does anyone read the footers on the message
> "JK" == Jan Kirchhoff <[EMAIL PROTECTED]> writes:
JK> If the Slave gets out of sync (loses the connection to the server), connects
JK> again and tries to catch up, it processes those two queries *within one
JK> second* which would result in an duplicate primary key on the slave. The
JK>
> "MS" == Marc Swanson <[EMAIL PROTECTED]> writes:
MS> As you can see the date field has been updated to the current date/time even
MS> though the update query was only supposed to modify the text field. For
MS> claarity the date field started out with 2001-01-07 08:00:00 and ended up
MS> wi
> "MW" == Matt Wagner <[EMAIL PROTECTED]> writes:
>> As far as I know, just try building it on an i386 running BSDI 4.1
MW> Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he
MW> could give Aaron here some pointers.
Try using gmake for bsd systems. The makefiles are proab
59 matches
Mail list logo