Eko and all,
> >The MyIsam storage engine is a non transactional engine and InnoDb is
> >a transactional engine. That is the main difference. So I think the
> >MyIsam engine should be faster.
However, some file systems that have journals are faster than non
journalling file system. It's not alw
David,
> Can anyone recommend this book? Or, if not, what book can you
> recommend for a newbie.
I always recommend Paul Dubois' New Riders Book:
* http://www.kitebird.com/mysql-book/
Paul's probably lurking on the list. I bought the 1999 edition and I
still refer to it :)
DSL
--
MySQL Gen
Hi There,
I have a replication setup on my local network (so any updates can be
transported at around ethernet speed).
Here's the behaviour I see:
* MySQL Master
- I do a whole slew of drop table and create tables
* MySQL Slave
- It doesn't pick them up
... until ...
- I restart the slave
It does
Hi,
> I have a problem connecting to the mysql server. I installed a new
> server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some
> websites running on it using the mysql server. Last friday I had a
> crash of one off my other servers and I copied the websites and db's
> to this new s
Fafa,
> I am running this non-profit organization working together with
> various charity organizations across the world.
>
> We would like to setup an efficient member database using MySQL
> rather than having some ugly formatted MS Word document listing
> them.
>
> What would be the purest an
Theresa,
> Knowing that MySQL is an open source software I'm in favour of this
> application and wldlike to try out this product, wonder why I can
> download this application for my necessary practice for both
> Client/Server application.
I assume you mean "How can I download the Mysql server a
James,
> We had a strange instance happen here with one of our MySQL servers.
> We have multiple MySQL installations, and one of the MySQL servers had a
> problem with daylight savings time.
>
> Basically, when we ran a select now(); MySQL reported time that was two
> hours ahead of the actual t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LOL
You could skip the "make test" part...
;-P
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE/GmBzmk7m2JX6ki4RArT8AJ0TIXkdJtdLnp8ZX1QX9dAyhrKVSACgo4Q3
BU5O9jhdfBp5nIh/zShajrI=
=zUaW
-END PGP SIGNATURE-
--
MySQL Ge
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim,
> What would be the ideal RAID configuration for a dedicated MySQL db
> server running on FreeBSD?
>
> We're also running some MySQL databases on Windows 2000 Servers. What
> about the best configuration for a dedicated W2k server running MySQ
> Return-Path: <[EMAIL PROTECTED]>
> Received: (qmail 22305 invoked from network); 23 Nov 2002 12:54:44
> - Received: from monster.filearena.net (202.6.159.69)
> by www.mysql.com with SMTP; 23 Nov 2002 12:54:44 -
> Received: from lightning.adam.com.au (lightning.adam.com
.159.69)
> by www.mysql.com with SMTP; 23 Nov 2002 12:49:31 -
> Received: from lightning.adam.com.au (lightning.adam.com.au
> [203.2.124.20])
> by monster.filearena.net (8.12.6/8.12.6) with SMTP id
> gANCnRbT035234 for <[EMAIL PROTECTED]>; Sat, 23 Nov
>
I know that there are binding that allow one to speak SQL to MySQL for:
* PHP
* Perl
* Java
...there must be more, all with their own idiosyncrancies, strong points
and weaknesses. Rather than having a holy war about which binding is
better (I prefer Perl but I certainly use PHP when it's approp
Jerry,
> I have some questions on using ODBC with My SQL.
:-)
> I have a MySQL on on an ISPs database server. I'd like to
> pull data from it into Excel. It appears that I need to
> use ODBC to do this. Do the server need to have ODBC
> installed or do I just need it installed on the PC I wa
Mark,
> >>Note that mysql does not support bind variables. If you think
> >you're>using them, whatever API you are using is filling them in
> >before>sending the statement to mysql. Bind variables do solve
> >quoting>problems, though, so if you use them, know why you're using
> >them :)>
Rumou
Stephanie,
> Does anyone know if there's a way in MySQL have the same functionality
> without installing the whole program on a users machine? I'm using a Java
> program along with Connector/J and a MySQL DB. We are trying to make it so
> the user doesn't have to install MySQL everytime they wan
Actually, I'd suggest the New Riders Book by Paul DuBois, "Mysql"...what
was it you wanted to achieve with your book:
* do you want a reference
* a tutorial
...?
mysql,query
DSL
-
Before posting, please check:
http://www.
What's the advantages of using Embedded MySQL instead of, say, Berkely's
DB?
[mysql, query]
DSL
--
Qualcuno no mi basta.
Vivere cercando il grande amore.
Vivere come se mai dovessimo morire.
(Anastasio, Valli e Travato)
-
Any reason you can't upgrade to a newer version?
mysql,query
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this threa
Adam,
> Obviously MySQL would have advantages if I intended to use it as a server
> database with concurrent users. But is it faster than Access in the
> single-user environment, when dealing with large databases?
MySQL in a single user environment is a pain in the arse because of its
lack of a
Joao,
> I think I've already asked this before, but I will try again. Do I loose
> too much performance using InnoDB tables in autocommit mode instead of
> using MyISAM tables?
Possibly, but "too much" is really relative on what your needs are. What
are you trying to achieve and what is more im
Gerald,
> Now I am getting the following:
>
> install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains;
>C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
> line 3;
>
> I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I
>fix this?
No, it's separate f
Gerald,
> #!perl
>
> use strict;
> use DBI();
>
> # Connect to the database.
> my $dbh = DBI->connect("DBI:mysql:database=club;host=localhost",
>"jwp", "x",
> {'RaiseError' => 1});
>
> $drh = DB
Mysql Query
---
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hmmm,
(mysql, query)
> Thanks
That's OK.
> It's 2.4.18
Sorry, I meant distribution...eg is it RedHat, Slackware ;-?
> So, I will try to unistall and install from the
> tarball, yes?
It wouldn't hurt. How did you install it in the first place?
DSL
--
Con te partiro, su navi per mari
Che
Spiros,
> linux:/home/db/TMPOUT # rpm -q mysql
> package mysql is not installed
>
> linux:/home/db/TMPOUT # rpm -qa | grep MySQL
> MySQL-shared-4.0.3-0
> MySQL-client-4.0.3-0
> MySQL-devel-4.0.3-0
> MySQL-4.0.3-0
> linux:/home/spiros/TMPOUT #
Ok.
> mypc@linux:~> /usr/bin/mysql
> ERROR 2002:
You may want to check out CPAN for:
Apache::DBIx
...
(kill the mysql query spam thingo)
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
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 question. What if you have table with
50 fields and you just don't want field 45, 46 and 48? It would be much
e
You could do something like:
> linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
> error: package MySQL-4.0.3-0.i386.rpm is not installed
Don't add the RPM on the end.
Also, what does:
* rpm -qa | grep MySQL
...show. It will be in there. Use that name.
mysql,query
DSL
--
Con te par
H,
> >>> Suppose I have a field named title that contains
> >> one
> >>> of these
> >>> I am a Man
> >>> I am a Woman
> >>> We are Men
> >>> We are Women
Why not split this into two fields:
pronoun enum('I','WE')
gender enum('MAN','WOMAN')
OR a SET
title SET("I","WE","MAN","MEN","WOMAN",
Mark,
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> Is it an sql command?
Parse the contents of "SHOW DATABASES" and then use the ouput of that to
"SHOW TABLES"...
mysql, query.
DSL
---
Hi There,
(mysql, query)
>From the online manual I see:
--
innodb_data_file_path
Paths to individual data files and their sizes. The full directory path
to each data file is acquired by concatenating innodb_data_home_dir to
the paths specified here. The file sizes are specified in megabytes,
h
Neal,
> Sorry for the MySQL newbie question ... but are there not primary/foreign
> key constraints in MySQL 3?
In MyISAM tables or ISAM tables no.
> I can't imagine that this is right. Perhaps
> I'm just overlooking something
innodb?
(mysql query)
DSL
( mysql, query )
> Can anyone help.
> I'm installing (at the mo) 4.0.3 Beta, but the error message is the same
> which ever version..
>
> libmysql.c: In function `mysql_real_connect':
> libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from
> incompatible pointer type
> libmysql.c:16
Paul et al,
> At 18:59 -0400 8/31/02, qlarry wrote:
> >here a file size limit in my sql
>
> What?
I think that loosely should translate as "Where is a file size limit in
MySQL" which I would then interpret as "Is there a file size limit in
MySQL".
All MyISAM tables are stored on the local fil
Andy,
( mysql, query )
> you could install MyODBC to write the tables directly from MS A. to MySQL
> via ODBC.
>
> Works ok and did a good job for me.
> > I've looked through the archives of this list but all methods of porting
> > a ms access db to mysql seem to require installing additional
Paul,
(mysql, query)
> It *can* use TCP, but that's just the transport protocol through which
> the replication information is processed. Replication can also be
> done between two servers on the same host, using a UNIX socket or (on
> a Windows box) a named pipe. The "replication protocol" i
H...
( mysql, query )
What permissions does a user need to issue:
LOCK TABLES blah WRITE
???
I have a user which I have:
GRANT ALL ON * TO user (blah blah)
...but that user can't lock any tables. Only the mysql root user can...
Version 4.0.2, built from source on RH 7.1.
DSL
--
Say
David
[ mysql,query ]
> update CompanyContacts
> set ByEmailAddress = '[EMAIL PROTECTED]'
> where Description like '%marve%'
Can you show us the output of:
describe CompanyContacts
...and also what is the exact error message?
Are you connected as a user who is allowed to update the CompanyC
[ mysql, query ]
> could someone point me to the right direction please
Are you generating it in MySQL (using sql) or are you using a
programming language to do it?
DSL
-
Before posting, please check:
http://www.mysql.com
Dave
[ mysql query]
> when I installed mysql 3.23.43 it instructed me to be sure to add a password with
>the following results-
> :
> seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password'
> Enter password:
> /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed
Amit,
> I am trying to run the following query:-
>
> select red,green,blue from colorchanger where
> colorcode = select value from jobattributekit where
> attributekit = "Color" and jobnumber =
> "28200124RB4-001" and scenario="JN75K";
It doesn't support subselects. It's having a problem with
Father,
[ mysql, query ]
> Is it a good idea to use an auto increment field as a primary key in mysql?
> I know in some products like paradox it is a bad idea because of possible
> corruption problems down the road?
I don't believe there would be any problems in the latest versions of
MySQL; o
Adam,
[ mysql, query ]
> However, you can do it manually (I think) by playing around with both
> the order of the where clause and the order of the join clause
Yes.
> Also, MySQL has a really wimpy default configuration (I can't figure out
> why). Here is my /etc/my.cnf (I don't know what th
l,
>
> I want to create an one to one relationship among
> tables using SQL. How can i do this. I creates an
> relation but it dose not expect my needs. For Ex they
> are two table say tbset nad tb tbprocess. If i set an
> one to one relation between the two tables in which
> the master table is
Brent
> Don't know if that's what you are trying to do. But I can't think of any
> reason to permanently replicate a table in the same database.
Maybe the other person is duplicating the data to do test stuff to it...
mysql,query
[I hope the spam thing lets this through]
DSL
--
We are not
[in order to avoid the spam filter]
mysql
mysql
sql
[end avoid]
(this is a test, I've got the pips with the spam filter when I'm not a
spammer -- especially when MOST of the messages from this list register
above 3 on http://www.spamassassin.org/)
GRUMBLE
James Foley wrote:
>
> Hi,
>
> If
46 matches
Mail list logo
