On Fri, Jan 31, 2003 at 04:36:05AM -0700, Prasanth Krishna wrote:
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
Why?
Have you looked at MyISAM MERGE tables yet? They're a style of
partitioning that MySQL lets you play with.
Do InnoDB
Read the section in the manual about timestamps, this is expected behavior,
it is how it is supposed to work.
http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If
Hi,
The MATCH() column list must exactly match the column list in some
FULLTEXT index definition for the table, unless this MATCH() is IN
BOOLEAN MODE.
from:
http://www.mysql.com/doc/en/Fulltext_Restrictions.html
On Thu, 2003-01-30 at 21:40, R. Hannes Niedner wrote:
If I create a FULLTEXT
Marco,
mysql update T_ORDH set STATUS=2 where PK_ID=26272;
ERSTELL_DATUM is set to the current date. I know that a timestamp
takes the current time, if set it to NULL, but since I'm not touching
it, it shouldn't change, should it?
A quick workaround is
mysql update T_ORDH set STATUS=2,
Hi Gerald,
I do not know what you mean by opening one database? Medic is a
database. Are saying that two database are involved?
And , why would updates be excluded. I read the documentation
about replication and did not see anything about updates not occurring
under certain situations.
I
There is a BOOLEAN type, which really is a TINYINT. Any non-zero value is
true and zero is false.
I use this columnt type with all my checkboxes in Visual Basic.
HTH
JFernando
* sql *
-Original Message-
From: David Hefford [mailto:[EMAIL PROTECTED]]
Sent: January 31, 2003 06:46
To:
You have mistaken the syntax, use the option
--set-variable max_connections=200
or add to your my.cnf file in one of [mysqld], [server] or [safe_mysqld]
sections:
set-variable = max_connections=200
On Thu, 2003-01-30 at 17:16, [EMAIL PROTECTED] wrote:
Hi Group,
I want to start my mysql
Hi,
Have you looked at MERGE tables (http://www.mysql.com/doc/en/MERGE.html) ?
Hopre this helps,
Joseph Bueno
Prasanth Krishna wrote:
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
Do InnoDB tables support partitioning?
thanks.
Prasanth
SHOW PROCESSLIST
Check http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html for details
Hope this helps,
Joseph Bueno
Mustafa Yelmer wrote:
How i list connected users(active) to mysql server?
it is important to know connected users for me?
Mysql runs in server-client system, and each host of
Hi,
You have the BOOL type in MySQL which is a synonym for TINYINT(1).
Maybe this is the best approach.
You may see the manual in Column types section.
On Fri, 2003-01-31 at 11:46, David Hefford wrote:
Have used many databases but am just getting into MySQL and am totally rapt
about it :) I
Don't know if i understood your question very well, but try:
# mysqladmin proc
in command line or execute the query
SHOW PROCESSLIST
On Fri, 2003-01-31 at 11:49, Mustafa Yelmer wrote:
How i list connected users(active) to mysql server?
it is important to know connected users for me?
Mysql
In the last episode (Jan 31), Maximo Migliari said:
So, my dear friends, could we conclude that Linux is a more appropriate
platform for running MySQL
on a multi-processed machine?
I was desperate to try and compile MySQL 4.0.9-gamma on my FreeBSD
4.7-stable machine, which is
dual
At 12:17 +0100 1/31/03, Marco Deppe wrote:
Hi,
I was already questioning my sanity,
Don't. Reading the manual is more helpful. :-)
but the problem below is
reproduceable:
This is how my table looks:
mysql describe T_ORDH;
--+--+-+++
I use version 2.
Christian Andersson wrote:
Hi there, I have a little question for you in the mysql community..
I was wondering how persons in this community handles changes to the
database when your application that uses the database needs some new
tables, columns, etc...
Do you have an
Since that is exactly how the manual describes it, it must be a feature.
If you have more than one timestamp, they will all get set on an insert,
but only the first will be changed on an update.
Marco Deppe wrote:
Hi,
I was already questioning my sanity, but the problem below is
reproduceable:
Moi,
every now and then my otherwise happely running mysqld has a thread or two
stuck in the state 'statistics'. If I kill it with `mysqladmin kill poor
threads id` it does get registered as 'killed' (According to `mytop`). But
the thread refuses to die. They do die eventually but it can take a
Hi all:
I am running MySQL 4.0.9 on Red Hat 7.2
Also using MyODBC to connect to a Win 2K system running a RADIUS server
(Steel Belted Radius)
I have a MySQL database that tracks usage information coming from the
RADIUS server. Everything is working, but the problem is that the RADIUS
server can
-Ursprngliche Nachricht-
Von: Guddack Thorsten ICM MP SCM GO 21
Gesendet: Freitag, 31. Januar 2003 20:51
An: 'Gelu Gogancea'; '[EMAIL PROTECTED]'
Betreff: Re: Replication Problems/Questions
Hi,
thank you for you're response,
but in the mysql-manual version 4.0 they said that the
Thank you Paul and Diana,
I the 6 hours that passed before my message appeared on the list I rechecked
the excellent MySQL documentation and found the answer as indicated by both
of you. I just missed to look for the answer under restrictions... my fault.
Best/h
On 1/31/03 11:12 AM, Diana
This is OT... Seems an Apache configuration problem..
You compiled apache with
./configure --prefix=/usr/local/apache --enable-module=so
so i think your DocumentRoot directive in httpd.conf is
DocumentRoot /usr/local/apache/htdocs
(i'm not shure, but something like that) and that's why you
These are the last two lines in config.log
#define MACHINE_TYPE i386
configure: exit 77
Maximo.
At 01:37 PM 31-01-03 -0600, you wrote:
In the last episode (Jan 31), Maximo Migliari said:
So, my dear friends, could we conclude that Linux is a more appropriate
platform for running MySQL
on a
Hi.
Accessing MySQL is equally easy in any of the languages (C++, Perl,
PHP, Java). So if that is the main point and it's correct that you,
Prabu, are already comfortable with C++, stick with it.
A reason a lot of people use Perl, PHP or Java is that many use MySQL
in conjunction with web pages
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
product_options_1.options,
basket.price, basket.quantity,
I normally do not use PHPMyAdmin. But when I had to do that once
on a client's sites (he didn't have shell access to a shared server ),
i had a similar problem. I couldn't import its own dump.
I believe it was a bug, and should've been resolved in later versions of
PHPMyAdmin. Try to update.
Sorry guys/gals, just a test for the mysql list.
sql
-
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
Hi.
I am sorry, I am not able to follow you. Maybe you should describe in
more detail what components are involved and what you want to
archieve. (If you simply want to store information you get from a
device, I don't understand where the database related problem is -
just store the data as you
Hi List,
again some Questions to replication in mysql:
I test the replication with following setup:
1 Server in Europe as the master, 2 servers in Asia and south america as
slaves.
Both slaves does the replication very fine.
Every insert, update or delete is replicated very fine, even with
: The fastest way would be to use C.
: But the reason for using a DB would be.
: 1. Access to data. You could use PhPMyAdmin or some thing you
: put together
: to update the policy so making managing the data easy (possibly so non
: tickers should make changes).
: 2. If
Just a test for the MySQL list.
sql
-
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 [EMAIL PROTECTED]
To
: When creating a table can you use multiple Table_Options?
:
: The O'Reilly Managing Using MySQL show on page 288 a
: table been created
: with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
No commas used to seperate multiple options. Here is an example I just
tried
Hi.
On Fri 2003-01-31 at 10:39:13 +, [EMAIL PROTECTED] wrote:
Hi
When creating a table can you use multiple Table_Options?
Yes. How about simply trying out beforehand?
The O'Reilly Managing Using MySQL show on page 288 a table been created
with two options ...)AUTO_INCREMENT = 1,
Hi.
On Fri 2003-01-31 at 08:27:11 +, [EMAIL PROTECTED] wrote:
Is it possible to mix javascript and PHP in the same script??
Of course. One (PHP) is run on the server side in order to create a
page which is sent to the client (here: the browser). The other
(Javascript) may be contained in
I am not doing that - so maybe that is why I am confused
by your response - sorry. I am new to mysql so bear with
with
I created a table in the test db called test. I logged into the
server using db mysql and inserted a record into test.test
and the insert is present in the linux-bin.001 log
How to change mysql root password in redhat 7.3 ?
Thanks
-
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
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
don't ask me why, I'm new to this things.
That's because the rpm installation puts there a file mysql to be
easier to configure starting services
If you want mysql to start everytime your machine reboots, have a
Hi.
On Fri 2003-01-31 at 10:05:40 +0100, [EMAIL PROTECTED] wrote:
any further news about 4.1 binaries release date?
Why the eagerness? 4.1 will be alpha. If you are going to use it
seriously (in your development), you want to compile it yourself
anyhow, because you will have to recompile it in
I get this message in mysqld.log when trying to access the server via
TCP/IP.
When using sockets it works fine.
Regards
Michael Skaastrup
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi.
On Fri 2003-01-31 at 12:17:42 +0100, [EMAIL PROTECTED] wrote:
I was already questioning my sanity, but the problem below is
reproduceable:
[...]
If I do
mysql update T_ORDH set STATUS=2 where PK_ID=26272;
ERSTELL_DATUM is set to the current date. I know that a timestamp
takes the
At 8:12 + 1/31/03, Jonathan Bedford wrote:
Hi
When creating a table can you use multiple Table_Options?
The O'Reilly Managing Using MySQL show on page 288 a table been created
with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
The comma should be omitted. You can specify multiple
PROBLEM with your JDBC driver - mysql connector.
I am developing using jdk1.4.1 on Mac OS X. I am using the mysql
driver - mysql connector java 2.0.14. I am creating a table in
mysql
thru java ... the code to do this is below:
try
{
On Fri, Jan 31, 2003 at 04:36:05AM -0700, Prasanth Krishna wrote:
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
Good Day Prasanth,
The MERGE table handler allows multiple MyISAM tables with identical
structure (but different data) to
Have you checked for network problems? You might try FTPing a file to and
from the production server, or something similar, just to rule this out.
I've had slowness problems with various apps that were driving me *nuts*
until I found a network issue causing them. In a few cases I had a duplex
It doesn't run over the network.
The reports are requested from a website , and a record is inserted into the
ReportQueue.
And then the reports are run local on the Production machine and then
emailed to the recipient.
At this time only 2 people order reports.
Mary Stickney
TAG-TMI
Data
On Fri, Jan 31, 2003 at 10:16:05PM +1030, David Hefford wrote:
Have used many databases but am just getting into MySQL and am totally rapt
about it :) I am writing a front end in realBasic that needs to be able to
run on various backends, MySQL being the main one. All of the others have a
OK, here goes the whole thing:
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
It was created by configure, which was
generated by GNU Autoconf 2.53. Invocation command line was
$ ./configure --with-mit-threads=no
In the last episode (Jan 31), Maximo Migliari said:
OK, here goes the whole thing:
configure:2461: checking for C compiler default output
configure:2464: cc -O -pipe -march=pentiumpro -D__USE_UNIX98
\
-D_REENTRANT -D_THREAD_SAFE -DHAVE_BROKEN_REALPATH \
Hi.
On Fri 2003-01-31 at 12:32:51 +0100, [EMAIL PROTECTED] wrote:
Hi there, I have a little question for you in the mysql community..
I was wondering how persons in this community handles changes to the
database when your application that uses the database needs some new
tables, columns,
Description:
One of our customers had a table named group, admitedly a bad design
but still not something that should cause mysqldump to fail hard!
How-To-Repeat:
Name a table group and run mysqldump, even with --opt
Fix:
Quick workaround is to rename the table, but
Prasanth,
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
An easy way to slice it into chunk would be:
CREATE TABLE tblPart_1 SELECT * FROM tblFull LIMIT 0,1000;
CREATE TABLE tblPart_2 SELECT * FROM tblFull LIMIT 1000,1000;
CREATE TABLE
On Fri, Jan 31, 2003 at 10:55:18AM -0300, Alejandro C. Garrammone wrote:
How can I create different user accounts for a table?. (I've just installed
the MySQL, and the root just don't have a password yet..how can assign one?
Hey Alex,
Check out the user account management section of the
Natale,
- Original Message -
From: Natale Babbo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, January 31, 2003 5:10 PM
Subject: 4.1 binaries
any further news about 4.1 binaries release date?
Lenz has now completed the build of 4.0.10.
I do not know, but 4.1.0
On Fri, Jan 31, 2003 at 08:46:53AM +0100, Webmaster LLBfrance wrote:
Hello Zak,
Thanks for your response.
I try the way you told me, but it seems there is
another problem :
The old foreign keys always exist.
In consequence, there are double references.
How can i resolve that problem ?
On Fri, Jan 31, 2003 at 10:39:13AM +, Jonathan Bedford wrote:
Hi
When creating a table can you use multiple Table_Options?
Heh. Why not just try it? :)
The O'Reilly Managing Using MySQL show on page 288 a table been created
with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
Hello!!
I have various databases, one with a table with more than 3 millions
of registers, and other has 250 MB, 50MB. My ibdata1 grow to more than
1 G, well I do not want my big database, I drop the database but the
size of the ibdata continues with the same size, what can I do?? I
waant my
On Fri, Jan 31, 2003 at 01:49:24PM +0200, Mustafa Yelmer wrote:
How i list connected users(active) to mysql server?
it is important to know connected users for me?
Mysql runs in server-client system, and each host of clients are different
(i assume)
Good Day Mustafa!
You can get a list
Mustafa
Try this command from the client window:
show processlist;
You must be logged in from root to list all connections.
If you are logged in as normal user, only those connections
which you have privileges are listed.
David
How i list connected users(active) to mysql server?
At 12:17 PM +0100 1/31/03, Marco Deppe wrote:
Hi,
I was already questioning my sanity, but the problem below is
reproduceable:
This is how my table looks:
mysql describe T_ORDH;
--+--+-+++
Field |Type |Null |Key
On Fri, 2003-01-31 at 10:48, Robert Mena wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Ex. suppose I have an autoincrement field called num
and the last one has value of 10.
I delete the last on and insert a
try using the command:
mysqladmin -v processlist
Gaganis
Mustafa Yelmer wrote:
How i list connected users(active) to mysql server?
it is important to know connected users for me?
Mysql runs in server-client system, and each host of clients are different
(i assume)
Mustafa Yelmer
Software
On Fri, Jan 31, 2003 at 06:48:45AM -0800, Robert Mena wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Ex. suppose I have an autoincrement field called num
and the last one has value of 10.
I delete the last on
Wow, one hell of a discussion! :-)
: Now, let's say DATADIR is in /var/lib/mysql/ under Linux, and under
: Windows this is c:\mysql\data\ (I'm not informed how paths will look
: like when you share them between OS's).
:
Guys, are you sure you can share files between two
Hi.
On Fri 2003-01-31 at 06:48:45 -0800, [EMAIL PROTECTED] wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Most of this depends on which MySQL version you use and which table
type, unfortunately. OTOH, for the
Description:
The --allow-keywords option has no effect if the server can
use the SHOW CREATE INFO command (it's the other else branch).
All the new code only make use of opt_quoted which is set by
the -Q option and quotes illegal table/column names instead of
I'm a new mysql user running on OS X. I have set up a test database and am
trying to use mysqldump to create a backup. However here is what happens:
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_dbbpw_db_backup.sql
bpw_db_backup.sql: Permission denied.
I have no
Hi.
On Fri 2003-01-31 at 10:44:58 -0500, [EMAIL PROTECTED] wrote:
I am trying to get a count of Distinct IP's from my homemade hit-log
database (don't ask). The db is MySQL. I'm trying this:
SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
DayOfMonth(TimeStamp) FROM RedirectLog WHERE
:
: I am trying to get a count of Distinct IP's from my homemade hit-log
: database (don't ask). The db is MySQL. I'm trying this:
:
: SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
: DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN
:
That is one bloody complex query :).
As far as I know, MySQL does not support RIGHT JOIN leyword, so that's where
it's failing. Someone slap me if I'm wrong.
It may be possible to fetch the results you want without such a hairy query.
Just include a partial dump of involved tables and concise
This actually is more tricky than it sounds.
Firstly the table already exists. So create table is
an option only if you were going to recreate a new
table with an auto_increment column, then move the
rest of the data (except for the index column) in to
the new table, drop the old table and
On Fri, 2003-01-31 at 06:39, Stefan Hinz, iConnect (Berlin) wrote:
Hallo Stefan,
Thanks for your kind reply. But anyway, me too,I've solved the problem
as well...:) :)
So, here is what I did in term of commands:
1- $ mount /home/myfiles
[this /home/myfiles is the D:\ partition in my
Hi.
On Fri 2003-01-31 at 15:46:37 -, [EMAIL PROTECTED] wrote:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
Auto_Increment will increment the last_INSERT_ID
(which in your case is 10)... so the num field of the
new entry will be 11.
--- Robert Mena [EMAIL PROTECTED] wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Ex.
:
: - what is the stored character code of the enter key in the
: text field, i am
: figuring out to find that character and replace it with the
: br element,
: for the exact display,
That's what's normally done. Line breaks are usually represented by \n
escape
On Fri, Jan 31, 2003 at 02:07:11PM -, Kevin Smith wrote:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
b.price, b.quantity,
On Fri, Jan 31, 2003 at 06:22:50PM +0200, Tarik Kutluca wrote:
Hi,
From a web form I am collecting information to a table. On the form there is
a textarea element storing to a text field on the mysql table. Since the
textarea can hold the enter key, it's stored in to the field also, but when
Hi.
In which way is this a MySQL related problem? Please choose a more
appropriate forum next time.
On Fri 2003-01-31 at 18:22:50 +0200, [EMAIL PROTECTED] wrote:
Hi,
From a web form I am collecting information to a table. On the form there is
a textarea element storing to a text field on
hi all
I want to know if adding 14 fulltext indexes on 14 columns would be faster , or adding
all the words in the 14 fields to one big text column and then fulltext index it is
better ?
i dont know how mysql keeps the fulltext indexes, but if each index is kept on a file
then 1 big column is
Hi.
On Fri 2003-01-31 at 17:22:37 -, [EMAIL PROTECTED] wrote:
[...]
select count(*) from percentile where criteria;
Work out 95% or this value.
create temporary table percentile (id int unsigned auto_increment
primary key, scantime decimal(20,10));
insert into percentile (scantime)
Hi.
On Fri 2003-01-31 at 18:56:19 +0100, [EMAIL PROTECTED] wrote:
Hi all,
my problem is the following, it's possible to insert an image in a table
with the libmysqlclient ?
Yes.
My language is C
i'm working with GNU/Linux
Bye,
Benjamin.
PS: In explanation: if you want a
Sherzod,
: Now, let's say DATADIR is in /var/lib/mysql/ under Linux, and
under
: Windows this is c:\mysql\data\ (I'm not informed how paths will
look
: like when you share them between OS's).
:
Guys, are you sure you can share files between two absolutely
different file
Tarik,
- what is the stored character code of the enter key in the text
field, i am
figuring out to find that character and replace it with the br
element,
for the exact display,
The character is \n (the new line character).
If you use PHP and have magic_quotes=on in your php.ini, PHP will
Hello sql member,
The fund of the help collects donations for the little girl.
If you know that mercy and compassion means, visit our website please:
http://www.kathelp.boom.ru
--
Best regards,
Ming mailto:[EMAIL PROTECTED]
Hi Benjamin,
Wow, that sure sorted that problem out... I had to rejig it slightly to
get it to work, but this is the final working version:
SELECT
b.id,
p.part_code, p.product_type, p.description,
po.options,
b.price, b.quantity,
b.price*b.quantity AS total
FROM basket_header bh
INNER JOIN
Does anyone have any hints on how to or where to look to find out how
to import a number of tab-delimited text files with some header info
that reside on a ftp server into a MySQL database using PHP?
How about doing this on a daily basis, automagically?
Thanks.
bw
---
Bill Whitacre
[EMAIL
83 matches
Mail list logo