>Description:
using LOAD DATA INFILE from Perl crashes table
>How-To-Repeat:
issue LOAD DATA INFILE from Perl w/ DBD::mysql 2.1020 installed
>Fix:
i downgrade to 2.0491
>Submitter-Id:
>Originator: Rich Allen
>Organization:
none
>MySQL support: none
>Synopsis: LOAD
I have a db with slightly over 614,000 records of names and addresses. In
the address column, there are quite a few records like
"123 any rd # 2"
"319 w. 1st st # B"
"4321 test blvd # 42"
etc
I want to replace all the number signs with the actual word 'number'.
Is there a SQL command I can use
1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
file?
My.ini file is below:
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
enable-local-infile
local_infile=1
When I perform the LOAD DATA LOCAL INFILE 'file_name.txt' INTO... command
from a client application using MyOBDC
At 23:46 2002-10-04, Chris Couture wrote:
>1 - Where does mySQL normally store it's data base
>files?
>
>* From what I have seen, it depends on how you install it. You can
>check in the my.ini file and that will let you know where it is.
On Linux (which I believe is the one in question) it
1 - Where does mySQL normally store it's data base
files?
* From what I have seen, it depends on how you install it. You can
check in the my.ini file and that will let you know where it is.
2 - Can you change the default directory for a data
base?
* Yes, you can change this in the my.
Installed mysql-3.23.43-pkg on Solaris Sparc 8. Get the missing library
error on everything I try.
Anyone know what to do?
Here's the error log entry for the command ./usr/local/bin/safe_mysqld
--user=mysql &
021004 21:41:12 mysqld started
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libs
On Fri, 2002-10-04 at 20:38, tmb wrote:
> HELP ! I'm a newbie to both Linux & mySQL.
>
> I have a simple mySQL sample data base running on a
> Red Hat 7.3 machine.
>
> It was already setup when I got it.
>
> Now I want to find the data base files that mySQL
> creates so I can back them up... an
HELP ! I'm a newbie to both Linux & mySQL.
I have a simple mySQL sample data base running on a
Red Hat 7.3 machine.
It was already setup when I got it.
Now I want to find the data base files that mySQL
creates so I can back them up... and for my education.
I can't seem to get Linux to search t
> -Original Message-
> From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
> Subject: Memory Limit
> And what is the calculation for the memory also
The formula you want is (this does not account for InnoDB buffers either):
key_buffer_size + (record_buffer + sort_buffer)*max_conne
Hi!,
> From: W [mailto:[EMAIL PROTECTED]]
> Sent: 04 October 2002 15:11
> To: [EMAIL PROTECTED]
> Subject: Question Regarding Update Year statement
> I'm looking for a date function that will allow me to update only the year
> portion of a field to a particular year, in this case, 2002.
>
> I've
I'm encountering a situation with MySQL that's really driving me crazy and I
have been unable to locate a solution. I'm hoping that someone on the
mailing list can provide some guidance...
I'm attempting to use a piece of php software (phpBB) which is talking to a
dedicated MySQL server via TCP.
I've uninstalled the previous version and installed the latest version
3.23.52.1. safe_mysqld is now running. I'm making progress but getting
bogged down in the littlest things. I feel ignorant, but I know once I get
over the first hump, I'm well on my way.
I'm trying to change the password
In the last episode (Oct 04), Arthur Fuller said:
> Does MySQL support GUIDs? Is there any code around that is equivalent
> to the built-in M$-SQL function NewID(), which returns a GUID?
Providing GUIDs is usually the job of the OS, and there really isn't
much of a standard for it yet. One solut
Does MySQL support GUIDs? Is there any code around that is equivalent to the
built-in M$-SQL function NewID(), which returns a GUID?
TIA,
Arthur
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I had gotten some feedback on this, but I still do not have enough
information on this to resolve it.
the initial thoughts & comments I got from people the believed it was a
connectivity problem. this is on an internal network. the linux box has
shared drives I use all day everyday with no prob
I have a Mysql DB schema which consists of some core tables in a database
'core'.
Then I have about 22 separate databases which have between 20 - 150 tables a
piece. I normally will stay within one of the daughter databases but
occasionally have to mine data from one of its sisters. I would rather
On Fri, Oct 04, 2002 at 12:36:30PM -0700, David McInnis wrote:
> Can someone please help me with the following? Normally I would do this
> with a nested select, but since this is not available in MySQL I think I
> need help.
>
> Here is what I have: An order table with sales tax total and an
>
Well, what I need to do is something like this:
select sum(tax) from orders, orderdetail where orders.id =
orderdetail.orderid and (productid = 1 or productid = 2 or productid =
3)
The problem is this that when I run this sql query:
select orderdetail.itemid, orderdetail.id as odid, orders.id,
So you want a SQL QUERY something like:
SELECT ORDERDETAIL.id as detailid, qty, unitcost, unitcost * qty as
extended from ORDERDETAIL
LEFT JOIN ORDERS ON orderid = ORDERS.id
WHERE ...
Right?
What's the problem you have with tax requests that you hinted at last time?
David McInnis
Here is my table schema.
Thanks for your help.
David
ORDERS
+--+---
| Field| Type
+--+---
| id | int(10) unsigned zerofill
| clientid | int(11)
| refid
Hello All,
I'm looking for a date function that will allow me to update only the year
portion of a field to a particular year, in this case, 2002.
I've tried "UPDATE [table] SET YEAR([field]) = '2002' WHERE [field] > 2002"
but this gives me an error. The MySQL documentation only seems to cover
David McInnis wrote:
>>select tax from orders, orderdetail where orders.id =
>>orderdetail.orderid and (productid = 1 or productid = 2 or productid =
>>3)
>>
>>I can get multiple tax amounts where an order has multiple matching
>>records in orderdetail. I know that I can group by order.id, but
Can someone please help me with the following? Normally I would do this
with a nested select, but since this is not available in MySQL I think I
need help.
Here is what I have: An order table with sales tax total and an
orderdetail table with ordered, itemid and qty.
What I need to do is form
Two things. I see the following in one of the mysqld.log files:
021004 14:41:05 mysqld started
021004 14:41:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
021004 14:41:05 mysqld ended
We have red hat 2.4.7-10. When I tried to install a later version of mysql,
I get
Thanks for all the responses on how to import a dump file that will not
write over existing tables and not stop with an error on existing tables -
in other words just add missing tables. As Victoria pointed out, there is no
option in mysqldump to add the appropriate create table option [IF NOT
EXI
On Thu, Oct 03, 2002 at 06:39:26PM -0500, Shane Allen wrote:
> We have a 4.0.4-beta master and slave.
>
> The slaving process starts correctly, but randomly (and frequently) has
> issues.
>
> When the server starts, it will slave, but eventually will hit one of
> two conditions:
>
> - Duplicate
On Fri, 4 Oct 2002, Cohan, Sean wrote:
> How can I either remove this installation so I can reinstall the latest
> version from scratch, or get mysqld started with this installation?
Find the var directory for the mysql installation. There will be log files,
typically machine.name.err
--
Sa
I'm new to this list. I hope I don't break any rules, but here goes. I'm
just getting on linux box that someone else set up with mysql 3.23. That
person unfortunately is back in school and hasn't yet answered my questions.
As if his exams are more important than my questions, imagine that.
I
Hi everyone!
I need to run an update query on 400 sets of data.
Being given a list of 400 names with 2 email addresses (company and
private) each, the task is to update all people who have an old email
address (either company or private).
So here are my questions:
1.Is there any way I can loa
Greetings...
I am developing an application on MySQL using the MySQL API's.
I have .sql file with 1 insert statement. I want to run all the queries
in one shot. mysql_real_query() allows me to execute only one query at a
time ?
So what do you think is the best approach to execute all the qu
Hi all,
I'm fairly new to MySQL and PHP, but have been reading a few books and
experimenting a bit. I've created a php application that will allow me to
view all the fields in my Database, but have not been able to correctly
build a search function in it. Here's a little background on what I
Begin forwarded message:
From: "Clayburn W. Juniel, III" <[EMAIL PROTECTED]>
Date: Fri Oct 4, 2002 10:24:06 America/Phoenix
To: "Clayburn W. Juniel, III" <[EMAIL PROTECTED]>
Subject: Re: Create table if not exists from mysqldump?
On Friday, Oct 4, 2002, at 08:48 America/Phoenix, Clayburn W.
William Martell wrote:
>rice and on hand quantity from these three tables. Each part number is
>the same in all three tables. The other fields are different. I would like
>to display each tables data sorted by item number. I am having trouble with
>my select statement.
>
>
SQL: select * from
With gcc 3.2, I get this:
g++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/var\""
-DSHAREDIR="\"/usr/local/share/mysql\""
-DHAVE_CONFIG_H -I../innobase/include
-I./../i
Hi List,
I am new to mysql so I ask for your patience...
1 - I am trying to load a text file (with mysql-front) to a table that
contains a TEXTdata type field. Despite of the documentation (TEXT = 2^16
bytes), after the load of the file that field is truncate to 51 characters.
On the text file I
I have a few questions regarding recovering an innodb tablespace/datafile.
Here's the situation.
I lose a drive on my master database that contained an innodb datafile. I then
shut the database down and umount that drive.
What would I need to copy from the slave database in order to bring the
Brent Baisley wrote:
> Well, there is the ideal setup, which requires intimate knowledge of the
> database, lots of disks and extra administration. And then there is the
> easy setup. Ideally you don't want to have any "hot" disks which will
> cause contention. This requires you to place your bu
In which tables of the three that you mention are the fields:
part number, part description, location, part cost, sell
price and on hand quantity
What is the structure of each or the tables.
-Original Message-
From: William Martell [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04,
Hi,
I'm having trouble in configuring the my.cnf for "optimal" condition on my server.
My MySQL server (3.23.52max) is running on Solaris 8 - Sun Sparc 4 processors and 4 GB
memory.
and my.cnf is :
- keybuffer : 768M
- sortbuffer : 8M
- recordbuffer : 8M
previously is :
- keybuffer : 1024M
-
On Thursday, Oct 3, 2002, at 20:41 America/Phoenix, John Kelly wrote:
> Hi, I am trying to use mysqldump to dump the structure of a single
> database
> and want the output to make create table commands that include the IF
> NOT
> EXISTS switch so that when the file is imported into an existing
Pass Filter: sql,query
Hello All,
I have three tables in my database
t1, t2, and t3. Each table has records that are the same or similar. I
am trying to SELECT part number, part description, location, part cost, sell
price and on hand quantity from these three tables. Each part number is
the
>Description:
I have a table with columns containing
keywords in cyrillic. If I write i.e.
select * from imgs where kw_1 like '%xx%'
(xx are two cyrillic letters and kw_1 is the first
keyword-column. The table contains 2666 rows.)
MySQL returns a lot of words(396 rows) and all of them
do
right. it also won't run on mainframes. :)
corereader is designed to query all platforms from
an ms. windows frontend.
>
> Thanks John,
>
> I looked through your web site, it seems to me that corereader is
> microsoft based product. I'm on Linux RedHat 7.2.
>
> thanks
>
>
>
> [EMAIL P
right. corereader is designed to query all
platforms from an ms. windows frontend.
>
> Thanks John,
>
> I looked through your web site, it seems to me that corereader is
> microsoft based product. I'm on Linux RedHat 7.2.
>
> thanks
>
>
>
> [EMAIL PROTECTED] wrote:
>
> > corereader wi
Hello there!
If I have a table with 100,000 records in and I have two columns in the
table, one an ID field (int) numbered 1 to 100,000 that is indexed etc. The
other field is a text field with say 100 words in each row.
What would produce the fastest search if I wanted to search for all entrie
* Michael T. Babcock
> Its well appreciated to see examples of what works and what doesn't too;
> its nice to know how to get one's queries in an order that makes the
> MySQL optimizer's life easier. I'm trying to decide if there's some
> logical way to inform MySQL that it can reorder a series o
I hate this spam filter with a passion.
Original Message
Subject: Re: Re: Fwd: Re: OT: Reply-Adress in this list
Date: Fri, 4 Oct 2002 17:25:26 +0200
From: [EMAIL PROTECTED]
To: Michael T. Babcock <[EMAIL PROTECTED]>
sql,query
Niclas Hedhman wrote:
>I don't care which beco
Hello,
I have a very serious problem.
I hope you can give me some advice, that would be very appreciated.
I have a mysql query like this
SELECT PartnerID,CampaignID,BrowserID,count(DISTINCT IP)
FROM tblData20020930
WHERE EventType='Impression' AND
.
If I may beg the List's tolerance for a while -
The practice of putting responses before the (often wildly varied and
prolix) text prompting that response means that those whose eyesight is not
what it used to be, if indeed it yet remains, do not have to wait for aeons
as speech software gri
Josh Trutwin wrote:
>The first query averages about 0.085 seconds from the mysql prompt, the
>second about 0.075 seconds and the 3rd 0.065 seconds.
>
>Thanks for some great advice, this has been bugging me for a while!
>
>
Its well appreciated to see examples of what works and what doesn't too;
Well, there is the ideal setup, which requires intimate knowledge of the
database, lots of disks and extra administration. And then there is the
easy setup. Ideally you don't want to have any "hot" disks which will
cause contention. This requires you to place your busy tables (read or
write)
Niclas Hedhman wrote:
>I don't by the "less functionality" argument any more than "if you have a good
>emailer". I think I have a good emailer, and on the "munging" lists, I press
>Reply-All, it will also send to the original author, but >95% of the case I want the
>list, and original author d
Jan Steinman wrote:
>This is a high-traffic list. The only way some of us can contribute is to get it in
>digest format, and the endless quotes make digest reading painful.
>
>
I read the list 'live' if you will (not pre-digested) and find it
equally irritating. I'd appreciate everyone takin
Using RedHat 7.2 and GCC 3.1 to compile the MySQL 4.04 beta, I get the
following error:
./gen_lex_hash > lex_hash.h
./gen_lex_hash: error while loading shared libraries: libstdc++.so.4:
cannot open shared object file: No such file or directory
Is this a bug or a problem with my configuration??
I have tried that with no success. A suggestion was made though of just
tarring the data dir, I think I shall try that route.
Mike
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 6:46 PM
To: 'Mike Hillyer'; MySQL Mailing List
Subje
äÏÂÒÙÊ ÄÅÎØ.
> >> Yes, temporary table are replicated properly since 3.23.29:
> >> http://www.mysql.com/doc/en/Replication_Features.html
>
> AK> Hmm... What is the reason?
> AK> If I create a temporary table in one process, I can't use it in another.
> AK> And after close connection table wi
Palash,
Thursday, October 03, 2002, 7:44:33 PM, you wrote:
PMK> i have just installed mysql.i was able to start the mysqld
PMK> process.howeveri am unable to set password for root using the following
PMK> command sequence :
PMK> ./bin/mysqladmin -u root -password 'abcd'
This statement
Andrey,
Thursday, October 03, 2002, 6:08:16 PM, you wrote:
>> Andrey,
>> Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
>>
>> AK> Why is temporary tables replecated?
>> AK> Is it true?
>>
>> Yes, temporary table are replicated properly since 3.23.29:
>> http://www.mysql.com/doc/en/Replic
* Jan Steinman
> Is there a simple way to duplicate one or more rows in a table?
>
> I tried:
>
> INSERT INTO table SELECT * FROM table WHERE criteria
>
> but apparently INSERT...SELECT cannot function on the same table.
Right, but you can use an intermediate temporary table:
CREATE TEMPOR
On Fri, 4 Oct 2002, Stephan Gloor wrote:
> When trying to create an index on
>
> Table ANSCHLUSS:
> | ID | int(11) | | PRI | NULL| auto_increment |
> | TELEFON | varchar(20) | | MUL | ||
> | REGION | int(11) | | | 0
William,
Thursday, October 03, 2002, 10:14:04 AM, you wrote:
>> I have three tables in my database
>> t1, t2, and t3. Each table has records that are the same or similar. I
WM> am
>> trying to SELECT part number, part description, location, part cost, sell
>> price and on hand quantity from the
John,
Friday, October 04, 2002, 6:41:46 AM, you wrote:
JK> Hi, I am trying to use mysqldump to dump the structure of a single database
JK> and want the output to make create table commands that include the IF NOT
JK> EXISTS switch so that when the file is imported into an existing database it
JK>
Or your could ...
mysqldump -u -p -h --all --add-drop-table --add-locks --
complete-insert --compress --extended-insert --flush-logs --force --opt --ve
rbose --databases > test.sql
- Original Message -
From: "swati sandhya" <[EMAIL PROTECTED]>
To: "John Kelly" <[EMAIL PROTECTED]>; <[E
Hi,
Do u mean when u take a dump you need to add before
each table "drop table if exists"
then here is the command.
mysqldump -u -p -h
--add-drop-table > test.sql
regards,
Praveen
--- John Kelly <[EMAIL PROTECTED]> wrote:
> Hi, I am trying to use mysqldump to dump the
> structure of a single
64 matches
Mail list logo
