I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.
This works with LOAD DATA INFILE :
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES"
but when i try:
mysqlimport --ignore-lines=2 -uro
On Thu, 15 Jan 2004 08:44, Computer Mail wrote;
> If I create a program that just queries data from a
> MySQL table and processes it...am I required to
> release that program under the GPL?
No. The below;
0. This License applies to any program or other work which contains
a noti
Hi John,
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 6:37 AM
Subject: Re: How does key buffer work ?
> Matt,
>
> Many thanks for the answer. It has helped enormously.
>
> First, I have been getting the odd index corruption that has proved to
be
> ver
Why use WinMySqlAdmin to view databases? The MySQL Control Center has a lot more
features and its usage is very straight forward.
If you are referring to the name that you gave it the first time you ran it then I
don't know. I'm curious about how to set it myself.
--
MySQL General Mailing Li
Thanks for the additional information. When 4.1.2 comes out, I'll give it a
test and return with some stats on real world result times (for my data set
at least).
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Quick Question Here:
I think I may have figured out my little problem with the thing wanting to
use localhost as opposed to the actual name of NapMarilu. Could it be that
when the server 2003 machine was originally setup before the installing of
MYSQL that in the IIS portion of the machine, th
EP wrote:
I am wondering:
I can see the MySQL data files for my various databases.
What technically prevents me from simply copying those files and using
copies
- to move my database to another file structure or server
- to back-up my current db
Yes, I did put my finger in the electrical socke
Hi list, two questions:
- Any tips on improving openbsd performance for mysql 4.0.17?
- Creating an index on a primary key improves performance?
thank to all.
> -Message d'origine-
> De : Computer Mail [mailto:[EMAIL PROTECTED]
> Envoyé : Wednesday, January 14, 2004 2:45 PM
> À : [EMAIL PROTECTED]
> Objet : MySQL GPL License Question
>
>
> I understand some of the GPL but I am a little
> confused on this issue:
>
> If I create a program that
Well, RedHat 9 says mysql is *already* installed. But I can't start it. And
when I attempt to configure it using mysql_install_db, it says to run make
install on it first. When I try to ./configure, it says it can't be found.
(i know gcc exists) When trying "make && make install", it says nothing
I have the user hardware set to be able to connect to the database from any
host. That is why I am so confused as to why this doesn't work.
Mike
> From: Andrew Boothman <[EMAIL PROTECTED]>
> Date: Wed, 14 Jan 2004 01:04:36 +
> To: Mike Tuller <[EMAIL PROTECTED]>
> Cc: MySql List <[EMAIL PROTE
Since I didn't get any replies to my previous message (see below), I am
trying to compile MySQL myself, to see if it results in a more stable
system when using replication. However this is failing consistently with
the following error:
make[4]: Entering directory `/usr/src/mysql-4.0.17/sql'
source
That did the trickthanks so much!
Cory
On Wed, 2004-01-14 at 12:50, Douglas Sims wrote:
> Would something like this do what you want?
>
> SELECT project_id, SUM(time_worked) AS total FROM time_daily WHERE
> user_id='clh' AND period_id='27' GROUP BY project_id HAVING total>0;
>
>
>
> Cor
I understand some of the GPL but I am a little
confused on this issue:
If I create a program that just queries data from a
MySQL table and processes it...am I required to
release that program under the GPL?
I have a MySQL server set up with some tables and I
created a seperate application to quer
Matthew,
Someone asked this question last year. It turns out that there's only a
one-character difference between the InnoDB and MyISAM .frm files.
See the posting below from last May for a way to recover the InnoDB table
structure, given an InnoDB .frm file but no data files, basically by
patch
On Wed, 14 Jan 2004, Ugo Bellavance wrote:
> mysql 4.0.17 on redhat 9 or debian 3.0
>
> mysql> show variables like 'log';
> +---+---+
> | Variable_name | Value |
> +---+---+
> | log | ON|
> +---+---+
> 1 row in set (0.00 sec)
>
> mysql>
Like this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
umysql> use test;
Reading table information for completion of table and column names
You can turn off this fea
Would something like this do what you want?
SELECT project_id, SUM(time_worked) AS total FROM time_daily WHERE
user_id='clh' AND period_id='27' GROUP BY project_id HAVING total>0;
Cory Hicks wrote:
Hello,
I must be having a goober moment.I am running the following sql
query with no probl
From: Cory Hicks [mailto:[EMAIL PROTECTED]
> Hello,
>
> I must be having a goober moment.I am running the following sql
> query with no problems:
>
> SELECT project_id,
> IF (SUM( time_worked ) > '0.00', SUM( time_worked ),'NULL') AS total
> FROM time_daily
> WHERE user_id = 'clh' AND period
Hello,
I must be having a goober moment.I am running the following sql
query with no problems:
SELECT project_id,
IF (SUM( time_worked ) > '0.00', SUM( time_worked ),'NULL') AS total
FROM time_daily
WHERE user_id = 'clh' AND period_id = '27'
GROUP BY project_id
However, having 'NULL' appear
Hi,
Quick question since I can't see to find version information online.
What version was enum first supported under?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:39 AM 1/14/2004, you wrote:
Hi,
My MySQL Server crashed yesterday and I repaired all the
tables.. However now the server is performing about ½ its old speed. Is
there anything I can do other than optimize the table?
-- Keith
Keith,
You could try Analyze Table and O
Sorry, 4.0.16, not 4.0.17, if it changes anything.
> -Message d'origine-
> De : Ugo Bellavance
> Envoyé : Wednesday, January 14, 2004 12:07 PM
> À : [EMAIL PROTECTED]
> Objet : setting a variable
>
>
> mysql 4.0.17 on redhat 9 or debian 3.0
>
> mysql> show variables like 'log';
> +
mysql 4.0.17 on redhat 9 or debian 3.0
mysql> show variables like 'log';
+---+---+
| Variable_name | Value |
+---+---+
| log | ON|
+---+---+
1 row in set (0.00 sec)
mysql> set global log=on;
ERROR 1193: Unknown system variable 'log'
W
Hi!
On Jan 13, Kurt Haegeman wrote:
> Hi,
>
> When trying to create a fulltext index on my large table, I get the
> following error:
>
> ERROR 1034 (HY000): 121 when fixing table
Sorry, I still cannot repeat this :(
Could you try to create a smaller test case ?
I would expect that you need on
Hi,
My MySQL Server crashed yesterday and I repaired all the
tables.. However now the server is performing about ½ its old speed. Is
there anything I can do other than optimize the table?
-- Keith
On Tuesday, January 13, 2004 11:52 PM CET, Anders Norrbring wrote:
> Hiya all!
>
> I'm curious about if there's a simple way to manage user quotas in a
> MySQL database? F.x. user one can have 10MB data in the database and
> user two can have a maximum of 5MB?
>
> Anders Norrbring
AFAIK MySQL has
Hi all,
Thanks very much for the advice, it gave me more than enough input to
resolve my problem!
Kind regards,
Tom Hesp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi there,
I am posting this message again sice my previous post
was vague.
I have recently configured a server which runs redhat
7.2. I followed the installation procedures to install
mysql database and PHP on the same server and they
seem to run properly.
My aim is to load data into a mysql dat
On Wed, 2004-01-14 at 13:32, Chris W wrote:
> Are there many php or mysql configuration considerations for making the
> site secure? I have already done the obvious with my sql and set up the
> grant tables with passwords for all users and removed the [EMAIL PROTECTED] user.
Give the MySQL user
Can you post the code that does the update?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I wanted to run by everyone what I am doing in my application to help
prevent someone from inadvertently or intensionally breaking the system
and compromising security. First some quick background. This is an
Apache/php/mysql project. It is a wish list database where people can
create an account
Original Message
Subject: Re: Searching for matching zipcode in a list of (ranges of)
zipcodes
Date: Wed, 14 Jan 2004 14:14:19 +0100
From: Mirza <[EMAIL PROTECTED]>
To: Tom Hesp <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Hi,
If you rewrite ranges 3612-3621 to have all
I am using 4.1.0 and 4.1.1 on Windows
On WinXP, it even crashes the server when I add extra date fields.
On Win2k AS, it doesn't crash the MySQL server but it returns unexpected
results.
Thanks
Emery
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
Tom,
Change your database so that you have an engineer table and an
engineer_zipcodes table. Each engineer can have multiple entries in the
engineer_zipcodes table.
Engineer
Engineer_id integer auto_increment primary key
Name
Address
Etc
Create index engineer1 on engineer(engineer_id)
Engineer_
Hi all,
I am looking for a simple solution to find a zipcode in lists of zipcodes.
I have a table with customer data including the customer's zipcode and a
table containing information about service engineers. The service engineers
can define a list of zipcode (ranges) of areas they want to (or a
Matt,
Many thanks for the answer. It has helped enormously.
First, I have been getting the odd index corruption that has proved to be
very annoying. I had checked the changes document for releases since
4.0.13 and there didn't seem to be any mention of an index problem but now
I'll upgrade asa
Hi fellas,
I wrote a php program that loads and displays data
into and from a mysql database. It connectes and
displays the data correctly. But when you fill a form
and click submit it acts as if the data is written on
the data base while isn't if you check it by manual
connection.
What could be
[EMAIL PROTECTED]
.
Hi Ken,
> Oracle has "Dual" does MySql have something similar?
MySQL doesn't have a "dual" table. But if you take a look at the
"Dual" in Oracle, you'll only see this:
CREATE TABLE Dual (Dummy VARCHAR(1));
INSERT INTO Dual ('X');
So you can easily create one yourself.
> In Oracle I use SYSDATE
Oracle has "Dual" does MySql have something similar?
In Oracle I use SYSDATE and USER a lot as default column values when
creating a table. Can you do something similar in MySql and how?
Does MySql support sequences? How?
Relationships - can the code be interfered with or do I have to w
Hi John,
I'll give my comments. :-)
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 2:04 AM
Subject: How does key buffer work ?
> I've been trying to optimise the operation of a MySQL (4.0.13)
> installation on a Windows 2000 based web server.
First, I
Mike Johnson wrote:
From: Ruslan U. Zakirov [mailto:[EMAIL PROTECTED]
Hello.
Table 1:
Items
id, Name
Table 2:
Properties
id, Item, Name, Value
I want select Items _and_ all thier props only if Item have specified
property.
Example:
Table Item:
1, Mouse
2, Monitor
3, Keyboard
Tab
Hi Eli,
Eli Hen wrote:
"Kurt Haegeman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when f
What kind of my.cnf file are you using with that setup?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 8, 2004, at 2:48 PM, [EMAIL PROTECTED] wrote:
We moved our main production server to a dual opteron last night,
running SuSE 9.0 x86_64 (kernel 2.4.21), and the binaries mysql
On Tue, 13 Jan 2004, EP wrote:
> I am wondering:
>
> I can see the MySQL data files for my various databases.
>
> What technically prevents me from simply copying those files and using copies
> - to move my database to another file structure or server
> - to back-up my current db
Copying will not
I've been trying to optimise the operation of a MySQL (4.0.13)
installation on a Windows 2000 based web server. After going through the
docs and browsing the net for some time, it seems that after ensuring that
your database design is sound and your queries correctly structured with
the right i
On 13 Jan 2004 at 10:11, Eve Atley wrote:
>
> I am attempting to construct a select statement in which I can find values
> between two fields: start, and end. I have tried using "BETWEEN" and
> comparing with <= and >=, but neither meet success. Can someone please set
> me straight? This is meant
48 matches
Mail list logo
