Thanks Brian
but i'm on Red Hat enterprise server so i wouldn't be able to use the
Features of FreeBSD and restarting the server is not a solution for me
as i need to be able to perform hot backup.
One of my solutions was to bump the database in a text file. this wroks
fine for small tables but
Hello,
Can somebody tell me the exact version from when `
around object names were allowed?
Thanks in advance.
Regards,
Karam
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL G
Garth Webb said:
> You might have better luck with this on the [EMAIL PROTECTED] list,
> re: why this doesn't work. This works for me though:
>
> $pk = $dbh->{mysql_insertid};
>
> On Mon, 2004-06-14 at 21:42, Daniel Kasak wrote:
>> Hi all.
>>
>> I'm writing an app in Perl / Gtk2, and I'm havin
Unfortunately species_id is a column I am using for joining so I need the
fully qualified name both in the SELECT and the ORDER BY.
Anyway - I have just installed 40.17 on an old PC and found this statement
works on 4.0.17, so it is clearly a "feature" of 4.1.2 and I will report
it
Thanks
You might have better luck with this on the [EMAIL PROTECTED] list,
re: why this doesn't work. This works for me though:
$pk = $dbh->{mysql_insertid};
On Mon, 2004-06-14 at 21:42, Daniel Kasak wrote:
> Hi all.
>
> I'm writing an app in Perl / Gtk2, and I'm having trouble with DBI's
> last_
Paul McNeil wrote:
last_insert_id() should work. You are updating using @bind_values. What is
the text of that? Does it indeed create a record?
@bind_values is an array of values that gets populated from my form.
It has the same number of elements as the number of placeholders in my
SQL, and
At 08:33 AM 6/15/2004, you wrote:
Hi
i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do
anyone have an answer for my PLEASE
Johan H
Johan,
Check out www.crlab.com. Their MySQL works great and is inexpensive. Their
tech support is great too.
There is also Zeos but there is no
Dave -
I would recommend (if not done so already) adding an index on owner.
That should improve the speed quite a bit.
On Tue, 15 Jun 2004 21:06:47 +, Dave Torr <[EMAIL PROTECTED]> wrote:
>
> Thanks - that is basically what I used to do (it works fine now on 4.1.2)
> but it was very slow as
Thanks - that is basically what I used to do (it works fine now on 4.1.2)
but it was very slow as there are a LOT of rows and this method returned all
of them.
From: Garth Webb <[EMAIL PROTECTED]>
To: Dave Torr <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: How to COUNT rows when they h
Thanks for the info!
At 15:01 6/15/2004, Darryl Hoar wrote:
>I'm using the Zeoslib control to do just that.
>www.zeoslib.net. Works like a champ for me.
>And its opensource.
>
>
>> -Original Message-
>> From: W. D. [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, June 15, 2004 2:01 PM
>> To: [
* Frank Bax <[EMAIL PROTECTED]> [040615 12:59]:
> At 03:14 PM 6/15/04, Tim Johnson wrote:
> >We are importing data from 3 CSV files.
<..> >the 3 tables into 1.
> >
> >Taken as a sum, we should have about 330 columns
> >and 5000+ rows.
Hi Frank:
>
> Are you saying:
> each CSV contains about 110
Shawn this is very helpful indeed and greatly appreciated, I now have a better
understanding of what is needed I now have alot of reading to do :)
It funny I was thinking on the way home that logically it would make sense to
pull the records in the format of the MySQL insert but for the life of me
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [040615 12:11]:
>
> Well, Tim, since you can't fix the data on the way out of the database (the
> original application), you will have to fix it on the way in. My best
> advice is to create 3 new tables in MySQL that look just like your 3 raw
> data files.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 01:29 pm, Eric Gunnett wrote:
> You can do a reset master, and it will start the log over at 001 and
> remove the old log files that are there.
Thanks,
I also had to restart the slaves (change master to command) to start
At 03:14 PM 6/15/04, Tim Johnson wrote:
We are importing data from 3 CSV files.
Documentation regarding the originating
database is for the most part, not available
to us.
Translating directly from CSV to .sql files, we
can see that the three files are really the
first, second and third parts of on
Mack Richardson wrote:
I'm running MySQL 4.0.20 on Mac OS X 10.3.4. I've added the my.cnf to the
etc directory,
Which one, and why?
Did you restart the server after changing my.cnf?
but mySQL server returns the following error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/
Hi,
> >> i'm looking for fast reliable driver to connect to MySQL from Delphi 7
do
> >> anyone have an answer for my PLEASE
> >
> >We're using the Microolap.com components - they have either
> >direct components (TDataset compatible) or a dbExpress driver.
>
> Would I need a driver like this if ru
Hi Steven,
> I've been looking at the post in the website, but cannot find a clear
answehr
> about views.
> Once is stated that it will be available in 5.0, and once that it's
allready
> in 4.1.
> In the 5.0 features list etc. nothing is mentioned.
> I like to know: when and how (docs) can I use
I'm running MySQL 4.0.20 on Mac OS X 10.3.4. I've added the my.cnf to the
etc directory,but mySQL server returns the following error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Removing my.cnf does not solve the problem. I have had to reinstall MySQL
to
Well, Tim, since you can't fix the data on the way out of the database (the
original application), you will have to fix it on the way in. My best
advice is to create 3 new tables in MySQL that look just like your 3 raw
data files. Use a LOAD DATA INFILE command to populate each of your 3
"raw" t
OK, now we are closer to a solution. Typically it is much easier to convert
data on the way OUT of a database than it is on the way INTO a database.
I would recommend exporting the results of 3 specific queries from your
existing data (I can't tell you exactly how to do this as it differs from
p
Hi,
I've been looking at the post in the website, but cannot find a clear answehr
about views.
Once is stated that it will be available in 5.0, and once that it's allready
in 4.1.
In the 5.0 features list etc. nothing is mentioned.
I like to know: when and how (docs) can I use views with mysql ?
At 09:04 6/15/2004, Martijn Tonies, wrote:
>Hi,
>
>> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do
>> anyone have an answer for my PLEASE
>
>We're using the Microolap.com components - they have either
>direct components (TDataset compatible) or a dbExpress driver.
Would
Hello mysql gurus:
We are importing data from 3 CSV files.
Documentation regarding the originating
database is for the most part, not available
to us.
Translating directly from CSV to .sql files, we
can see that the three files are really the
first, second and third parts of one huge table
and c
Thanks Shawn you ahve been very hyelpful indeed and have helped clarify my
thoughts on finding a solution for this problem of 2 structurally different
DB's.
The first DB is SQL and holds all compnay data the second is MySQLand holds all
website products which are snippets from the SQL what I need
I knew there was a better way than what I suggested! Of course, you'll want
to use your actual query for the first line:
SELECT COUNT(*) as c FROM pet GROUP BY owner HAVING c > 1;
SELECT FOUND_ROWS();
Michael
Garth Webb wrote:
You could also try:
SELECT owner, COUNT(*) FROM pet GROUP BY
- Original Message -
From: "Gloria L. McMillan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 15, 2004 11:16 AM
Subject: Test greeting & question
> Hi, once again!
> \I tend to get on and off this list.
>
> I have myCC and I was wondering what this means in my CREATE f
At 12:22 +0100 on 06/11/2004, Andrew Dixon - MSO.net wrote about Query Help:
Hi Everyone.
I have the following a table with a varchar column that contains a comma
delimited list of id's from another table that relates the item keywords in
the other table.
The table keywords contains
keyword_id (int
--- Eve Atley <[EMAIL PROTECTED]> wrote:
>
> I noticed the answer from Shawn Green, and wanted to
> let you know that I,
> too, find the manual a bit too technical.
>
> I use PhpMyAdmin with great success. You want to go
> into the SQL tab in the
> main window, and hand-type a basic query in that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am trying to prune some bin-logs and noticed:
mysql> show master logs;
++
| Log_name |
++
| db-bin.001 |
| db-bin.002 |
| db-bin.003 |
| db-bin.004 |
| db-bin.005 |
| db-bin.006 |
| db-bin.007 |
| db-bin.008 |
| db-bin.009
You can do a reset master, and it will start the log over at 001 and remove
the old log files that are there.
Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED]
>>> Jeff Smelser <[EMAIL PROTECTED]> 06/15/04 11:26AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am tr
--- [EMAIL PROTECTED] wrote:
>
> David,
>
> I am sorry but I have never used phpMyAdmin. I don't
> know what it can and
> cannot do.
>
> What I am referring to as "the client" is the
> command-line interface tool
> that comes bundled with MySQL. If you are going to
> do any serious MySQL
> datab
David,
I am sorry but I have never used phpMyAdmin. I don't know what it can and
cannot do.
What I am referring to as "the client" is the command-line interface tool
that comes bundled with MySQL. If you are going to do any serious MySQL
database administration, I *STRONGLY* encourage you spend
--- [EMAIL PROTECTED] wrote:
>
> David,
>
> Try writing your queries to the screen (or as
> comments into your HTML) then
> running those queries *manually* from the MySQL
> client. You should be able
> to spot your design or logic errors pretty quickly.
Thanks. I still haven't learned how to d
hello-
i am running into trouble compiling on redhat 7.2 (2.4.7-10)
configure and make run without dying - make test however produces the
following output:
02:17:35([EMAIL PROTECTED])/tmp/source/mysql-4.1.2-alpha>make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale
>Hi, once again!
>\I tend to get on and off this list.
>
>I have myCC and I was wondering what this means in my CREATE file.
>
>) TYPE=MyISAM;
>
>Could somebody please translate this into English?
Please read: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
>
>I am interested in the UNIQUE p
Version 5.x contains the ability to use stored procedures and logic. You
could also look into using lua as your scripting language for MySQL.
-Original Message-
From: Lourenço de Paula
To: [EMAIL PROTECTED]
Sent: 6/15/04 11:54 AM
Subject: Re: Batch Script
Thanks, but can not I use a MySQL
Which is better? I guess that all depends on your entity relationships.
If I assume that each PERSON would have only 1 USER record and each USER
would match to only 1 PERSON record. That is a "1-to-1 relationship" or
(1..1) and is typically stored with all of the necessary column in just one
tabl
Thanks, but can not I use a MySQL native script language like in MS Sql
Server and Oracle?
- Original Message -
From: "George Chelidze" <[EMAIL PROTECTED]>
To: "Lourenço de Paula" <[EMAIL PROTECTED]>
Sent: Tuesday, June 15, 2004 1:23 PM
Subject: Re: Batch Script
here is a quick perl scr
You could also try:
SELECT owner, COUNT(*) FROM pet GROUP BY owner;
SELECT FOUND_ROWS();
On Mon, 2004-06-14 at 20:41, Dave Torr wrote:
> Thanks - this did not work for me as I am on 4.0.17 - presumably this works
> on 4.1 (seems to need the SubQuery feature)? If so I will upgrade
> imme
Curtis Seyfried 2 wrote:
Yes,
Linux RH9 2.4.08
When I run the /opt/lampp/lampp start command, Apache starts, SSL, starts
and another service, mysql seems to start. But when I try to connect to
mysql with admin or cc or other tools, so I can setup databases and
tables, it tells me mysql is not runni
On Tue, Jun 15, 2004 at 08:04:00AM -0500, Steve Buehler wrote:
> I am having a problem with a backup script that is written in a shell
> (/bin/sh) script to backup my mysql databases. For some reason on any day
> with an even number I get the following error:
> MySQL could not be stopped, exitin
On Tue, Jun 15, 2004 at 10:14:54AM +0400, Vinay wrote:
> Hi,
> I just like to know what is the best way to dump the databases to flat
> files as some of the tables on my system are up to 1.4G and the whole
> database size is over 2.5G . I trying to set up a cron job that will
> back up the table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 10:43 am, Carlos Sunden wrote:
> I am not completely sure what this is although I've read about it.
www.innodb.com.. Gives you all the info you can handle.
Jeff
- --
Not quite human any longer.
-BEGIN
Hi, once again!
\I tend to get on and off this list.
I have myCC and I was wondering what this means in my CREATE file.
) TYPE=MyISAM;
Could somebody please translate this into English?
I am interested in the UNIQUE property.
Would making my replies to survey subject to UNIQUE make thej less e
Hi everybody, I'm newly subscribed so please be gentle :)
I have a design problem whose solution seems to be directly linked to
the MySQL way of handling joints.
I created a table USER which manages all entities allowed to connect to
the system.
|---| |---|
|PERSON | |C
"InnoDB is included in binary distributions by default as of MySQL 4.0."
Hello
Is InnoDb always used when installing MySQL whether RPM or binary is used?
I am not completely sure what this is although I've read about it.
Thanks!
Carlos
-
D
Hi,
In my database I've a table with a field that control de version of may tables, now I
need to make a script to update my tables and I would like to make something like that:
DECLARE
i number;
BEGIN
select version into i from mytable;
if version = 1 then
create table...
insert
I use mysql3.53.x
I wish to query as value of rows on any table
Here's my table named mytable
id date pictures subject
271503 2003-10-25 20031026035655_5326 9 BENY
271502 2003-10-25 20031026035628_6401 283 PLATFORMU
271501 2003-10-25 20041026035610_1017
>John:
>
>A couple of suggestions. First, a better way to identify duplicate files
> in to
>use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file
> is
>residing on the server. It would be a good idea to store the md5 sum in
> the table.
>
>I think your problem can be solved with
Hi,
> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do
> anyone have an answer for my PLEASE
We're using the Microolap.com components - they have either
direct components (TDataset compatible) or a dbExpress driver.
With regards,
Martijn Tonies
Database Workbench - deve
Hi
i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do
anyone have an answer for my PLEASE
Johan H
Let me start off by saying that your JOINs are well written but you don't
"need" to check against both table_1 and table_2. If A = B and A = C then B
= C. It works in both algebra and in databases. However, I would separately
try joining _1 to _3 and _2 to _3 to see if either join resolved faster.
I am having a problem with a backup script that is written in a shell
(/bin/sh) script to backup my mysql databases. For some reason on any day
with an even number I get the following error:
MySQL could not be stopped, exiting...
It is really weird because it will run on odd number days without
Bravo! Ken. Great explaination! - Shawn
Michael Stassen
David,
Try writing your queries to the screen (or as comments into your HTML) then
running those queries *manually* from the MySQL client. You should be able
to spot your design or logic errors pretty quickly.
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
To be honest, there are probably hundreds of workable solutions to the
*very* generic problem of moving data from one database to another. Using
an ODBC driver (or drivers) would definitely be an option. One of the
simplest methods is to export your spreadsheet to a CSV file (comma
separated, stri
Hi -
perhaps this is a bug - but I figure I'd try here first in case I'm doing
something wrong.
Master is 4.0.20 - slave connect and replicate fine, HOWEVER, for each
binlog dump a new thread gets created and the old one is NOT released.
Within a couple of days my master sever is flooded and allo
last_insert_id() should work. You are updating using @bind_values. What is
the text of that? Does it indeed create a record?
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-Original Message-
From
You wrote
> $pk = $dbh->last_insert_id();
I believe you can get the created ID with the query, "Select @@IDENTITY;"
This returns the last created ID from the connector object.
Peace
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Michael,
- Alkuperäinen viesti -
Lähettäjä: "Michael McTernan" <[EMAIL PROTECTED]>
Vastaanottaja: "Mysql" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Monday, June 14, 2004 9:40 PM
Aihe: DROP TEMPORARY TABLE and implicit commits
> Hi there,
>
> I'm using MySQL 4.0.18 and fi
"Henry Chang" <[EMAIL PROTECTED]> wrote:
>
> I have MySQL replication setup between Master A and Slave B.
> Everything was working fine, until one day replication was broken.
> Status on the slave shows the following error message:
>
> Last_error: Error 'Can't drop database X. Database doesn
I tried even with
thread_stack=10
(starting from thread_stack=10 and increasing by 10 times each time)
It still keeps on crashing.
Note that my select is
SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(S
[resending this with another mail user agent to bypass the spam filter]
Dear Andy,
I have this weird problem with 1 transaction locking out another for
no
apparent reason and in an inconsistent fashion. I'm using mysql
4.0.18
with innodb tables. The table in question has 2 primary keys: CID and
I have 3 tables:
- table_1 - pri key is id+lang
- table_2 - pri key is id
- table_3 - pri key is id+lang (Full-Text table)
To join all 3 tables with their keys and run a full-text query, I understand I need to
put the Full-Text table at the end of the joins..
If I use the tables as def
Just a note...
> Thanks - this did not work for me as I am on 4.0.17 - presumably this
works
> on 4.1 (seems to need the SubQuery feature)? If so I will upgrade
> immediately!
This isn't a subquery -- this is a Derived Table.
With regards,
Martijn Tonies
Database Workbench - developer tool for
66 matches
Mail list logo
