As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location=/Volumes/foo/sql_dumps/
# set db_list to the list of databases
db_list=`echo show databases | /usr/local/mysql/bin/mysql -N -u
-p`
for db
Soni, Sanjay K [EMAIL PROTECTED] wrote:
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
John Heitmann [EMAIL PROTECTED] wrote:
Description:
When a temp table is included twice in a query mysql fails with the
error:
ERROR 1137 at line 9: Can't reopen table: 'foo'
This happens on both 4.0.17 and 4.0.18. It did not happen on 4.0.14.
How-To-Repeat:
create temporary
Fredrik Carlsson [EMAIL PROTECTED] wrote:
Hi,
I have a question regarding to search with fulltext on table and fetch
the data from another.
Table one:
id, textid, name, number, url
Table two:
id, text
On table two there is a fulltext index.
These two tables recently was one
Bing Du [EMAIL PROTECTED] wrote:
Our MySQL server (4.0.13) is currently running with the option
--skip-networking. We want the server to accept TCP/IP connections. If
this option were specified in the config file, perhaps I could just modify
the config file and HUP the server process. So
Hi!
You should know the meaning of next SQL statements :
SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday')
FROM table_name
(This should mean : if field_name = '0', return 'Sunday', if field_name =
'1', returns 'Monday', ...)
I try to use this with mysql (in EasyPHP: Apache
Duncan Hill [EMAIL PROTECTED] wrote:
Mysql version: 4.1.1
Platform: Linux, pre-compiled RPMs from mysql.com
My problem:
Right now, I use a routine that selects the IDs that haven't been seen, and
promptly does an insert into notifications_seen to flag that it has been
seen. This works
Hi,
thanks for your answer.
I tried what you suggested:
select table1.id,table1.name from table1,table2 where
table1.textid=table2.id AND match(table2.text)
AGAINST('$searchString' IN BOOLEAN MODE);
But that query takes for ever to run and uses 100% cpu. Is there a
faster way to do this query?
Mahefa Randimbisoa\\DS-ETU [EMAIL PROTECTED] wrote:
You should know the meaning of next SQL statements :
SELECT DECODE(field_name, '0', 'Sunday', '1', 'Monday', '2', 'Tuesday')
FROM table_name
(This should mean : if field_name = '0', return 'Sunday', if field_name =
'1', returns 'Monday',
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: mos
Sent: Friday, February 27, 2004 11:51 AM
Subject: Re: datetime in mysql
sorry , as u said , i did it . it doesn't work for
me .This table i want to view in the Web. So that date and time must fully
Hi,
If You take Your really exellent MySQL Reference Manual, and search for timestamp
or look into chapter 6.2, You fill find what You are looking for.
Best regards
Peter
- Original Message -
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Friday,
Hi!
It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql internal databases(the
ones that carries user and config info), the script is usually in
install_prefix/bin/mysql_install_db
If you have no recently installed mysql, and the server
I don't like your chances of successfully doing this. You could try
pulling the changesets out of the bitkeeper repository by hand but the
fact that 4.1.X was branched from an earlier version of the 4.0.x series
(I think), it might be a bit of a strugle.
Anyways, good luck! :-)
Regards,
Chris
Sanjay,
It seems you didn't run mysql_install_db script which is located in /scripts
directory. This script creates Grant tables for you when you first install mysql.
Basically the error says you missing those grant tables, you can re-run the script and
recreate them.
Hope that helps!!
Raza
Greetings,
I am replicating from 4.0.17 to 4.0.16. I read through the replication
docs, and I didn't see anything relating to what I'm trying.
What I am hoping to do ... is slave the multiple databases ( the whole
thing ), in order to avoid shutting down ( or at least locking ) the
master and
Jennifer Horne [EMAIL PROTECTED] wrote:
We've recently started using MySQL for customers with a large number of
records on their systems.
For the first time, one of our customers has gone over the 4 million
record mark, and we're running into some problems with the MAX_JOIN_SIZE
and the
On Wed, 25 Feb 2004, Sasha Pachev wrote:
where dbh is a global MYSQL structure. This code works fine on the old
system. If I pull it out into it's own little test program on the new
server, it also works fine. But when I put it in with the analog source
code, it compiles fine but
Problem: all the mod_perl pages run a few write queries, so they will require a
connection to the main database server. Since around
80% of our queries are reads, would you recommend that each script has two
connections: one for read queries, and one for write
queries? We can determine which
Philip Mak wrote:
Say I have this query:
SELECT *
FROM topics
ORDER BY lastPostTime DESC;
How would I modify it to answer the question How many rows would be
returned before the row that has topics.id = $x?
I was thinking of something like this:
$xPostTime = SELECT lastPostTime FROM topics WHERE
Chuck Gadd wrote:
I've got a query that I can't seem to get optimized, so I'm
hoping someone here can spot something I've missing!
Table has three columns:
CoordID int unsigned,
Zip_Lo char(9),
Zip_Hi char(9)
Table has 3 million records
indexes:
acg_lo (Zip_Lo)
acg_hi (Zip_Hi)
acg_combined
On Thu, Feb 26, 2004 at 09:50:39AM -0700, Sasha Pachev wrote:
If I understood the problem correctly, the answer to it is actually
undefined. If you order by lastPostTime, the records with the same
lastPostTime value can be returned in any order.
I guess to accomplish your goal you could add
Sp.Raja wrote:
Hi List,
I'm using mysql-4.0.15a. But we need some specific features present in 4.1.X such as
1. INSERT ... ON DUPLICATE KEY UPDATE query support
2. Innodb multi-table space (one ibdata file per table)
Could someone point me to patches for them for 4.0.15a release. so that I can
You can also rerun the scripts/mysql_install_db
This will reinstall the mysql.hosts form and allow you to reconnect to your
server.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Philip Mak wrote:
On Thu, Feb 26, 2004 at 09:50:39AM -0700, Sasha Pachev wrote:
If I understood the problem correctly, the answer to it is actually
undefined. If you order by lastPostTime, the records with the same
lastPostTime value can be returned in any order.
I guess to accomplish your goal
On Thu, Feb 26, 2004 at 10:49:08AM -0700, Sasha Pachev wrote:
SELECT COUNT(*)
FROM topics
WHERE lastPostTime $postTime
OR (lastPostTime = $postTime AND id $id);
Can you just add id $id to the where clause?
No, that won't work because id is only used to disambiguate the order
of two rows
Hi Matt, thanks for shedding light on the version and key_len issues.
Either phpMyAdmin or MySQL is labelling the return of blank results as an
error, thus my use of the term. The output from phpMyAdmin looks like this:
Error
SQL-query:
SELECT subject FROM entry WHERE MATCH (subject) AGAINST
Hello all:
I have 2 machines, Primary and Secondary. The updates
on the Primary are being replicated on the Secondary
via MySQL Replication.
Additionally there are updates to specific tables
(Alarms) that are more important than other updates.
I do not want the Alarm updates to be queued
Hi,
I was just wondering what the valid range for ports is for the MySQL server
in a Windows environment. Obviously, the server won't connect to a port
already in use, but I know some programs disallow ports under 1024.
Thanks,
Matt
--
MySQL General Mailing List
For list archives:
Eric Scuccimarra wrote:
Have one more question - indexing the relevant columns based on the
explain info has made all of our queries immensely faster.
But it appears that new rows are not automatically indexed. Does anyone
know about this and if they are not indexed how do I reindex the tables?
Matt P. Fuller wrote:
Hi,
I was just wondering what the valid range for ports is for the MySQL
server in a Windows environment. Obviously, the server won't connect to
a port already in use, but I know some programs disallow ports under 1024.
MySQL introduces no port restrictions of its own. If
Gowtham Jayaram wrote:
Hello all:
I have 2 machines, Primary and Secondary. The updates
on the Primary are being replicated on the Secondary
via MySQL Replication.
Additionally there are updates to specific tables
(Alarms) that are more important than other updates.
I do not want the Alarm
Since the connection pool needs to load the driver, putting the driver jar
in WEB-INF is too late. One option is to put in the startWeblogic file and
add it to the classpath there. Depending on the version of WLS there are
various way to accomplish this.
Best regards...
-
Answers to J2EE,
Matt:
Read the port specifications enumerated in the services file in
%SystemRoot%\win32\drivers\etc
Contact your net/sys admin to see which ports he is allowing to cross his
firewall.
Some admins shut off everything except 80 (HTTP)
HTH,
-Martin
- Original Message -
From: Matt P. Fuller
Hi =)
How would you approach the design of a database that models the
following information?
- Users
- Invoices
- Purchase Orders
- Sales Orders
- Adjustments
- Products
We were originally working with Users, Purchase Orders, Sales Orders,
and Products. Everything was pretty easy at first...
Hi All,
If I got one table A_table with many columns, and a second table B_table is
the same but with just primary field and unique field...
How much meaningful is the time difference between these queries?
1. SELECT unique_field FROM A_table WHERE prim_field='val';
2. SELECT unique_field FROM
Your business requirement is not quite clear. Here are some questions
that you need to answer before you finalize your design:
1. How often will the invoice be viewed (and I assume the viewers must
be your web site users?)
2. What's the approximate traffic volume?
3. Will each time the users
Does anybody know the product able to serialize multiple similar queries coming from
different sources to the one SQL server? Could
be nice to have something as a SQL proxy with cashing pool, expiration, etc to put the
main server load down and release his
resources.
Thanks in advance for
I am using this:
Statem=MyQueryResults.ConnectionUsed.createStatement(
java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);
Statem.setFetchSize(Integer.MIN_VALUE);
But, it will not allow me to do .first() on the ResultSet...or
Ed
The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar 2004 02:09
An: [EMAIL PROTECTED]
Betreff: Query
--- Sasha Pachev [EMAIL PROTECTED] wrote:
Gowtham Jayaram wrote:
Hello all:
I have 2 machines, Primary and Secondary. The
updates
on the Primary are being replicated on the
Secondary
via MySQL Replication.
Additionally there are updates to specific tables
(Alarms) that are
Your resultSet needs to be scrollable. You have created a streaming
resultSet.
Original Message
On 2/26/04, 12:33:38 PM, Ted Hulick (nVision Software)
[EMAIL PROTECTED] wrote regarding Large
ResultSets/TYPE_SCROLL_INSENSITIVE:
I am using this:
I mentioned that at the end of my original message. I've tried it both
ways and it doesn't solve the problem.
The query is good. For some reason though Access or MySQL is removing
the IF statements in the middle of it.
What next?
Freddie Sorensen [EMAIL PROTECTED] 2/26/04 12:25:03 PM
Ed
It sounds like the following requirement got you thinking about the problem
in the wrong way, though you still came up with a viable solution:
invoices need to list all purchase orders, sales orders, and
adjustments for a given time period. I could display the invoice
and then display
hi, Mike.
What do this using an encrypted loopback-device, on which the
/var/lib/mysql stuff resides.
just check man losetup for instructions.
i'm NOT sure about the preformance issues, though.
and i am very concerned about filesystem-corruptionby my logic,
there's a double risk, since the
Evelyn:
I need help. I have followed your instructions. Here is my problem:
. Installation
...
...
Shell Make Install
Shell scripts/mysql_install_db
bash: scripts/mysql_install_db: No such file or directory
--
Am I following the correct sequence? There is no directory scripts! In
You could use views but they will not be available until version 5 or 5.1
In the doc you can find :
Views are useful for allowing users to access a set of relations (tables) as
if it were a single table, and limiting their access to just that. Views can
also be used to restrict access to rows (a
Hi,
I'm running RedHat Linux 7.2 and I want to install MySQL 4.1. I have downloaded the
following RPM packages to install in the following order:
MySQL-server-4.1.1-1.i386.rpm
MySQL-client-4.1.1-0.i386.rpm
MySQL-devel-4.1.1-0.i386.rpm
MySQL-shared-4.1.1-0.i386.rpm
I try to install the
Ed,
In that case (and I assume your web server and database server are on
the same cluster), your original idea is good: store foreign keys in
your invoice table pointing to all other tables. In other words, once
an order is entered, there is also an entry to the invoice table.
However, you
Hi List,
I need to create a complex Select joining 2 tables.
Table Product, I have these fields:
Code (PK)
Description
Records:
01 Product A
02 Product B
Table Price, I have these fields:
Code (PK/FK)
How can I add an auto-incrementing primary key to an existing table?
MySQL version 4.0
Thank You
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need to do this behind the scenes. The user will need to press a
button for the .mdb file to be imported. I can't use a thrid party
program for this.
Thank you any way.
Karam Chand [EMAIL PROTECTED] 2/26/2004 5:22:51 PM
Hello
I use SQLyog (http://www.webyog.com/sqlyog) to import
data
Hi Paul,
ALTER TABLE table_name ADD id_column_name INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY FIRST;
The FIRST word at the end just makes it the first column in the table if
that's what you want.
Hope that helps.
Matt
- Original Message -
From: Paul Maine
Sent: Thursday,
Lorderon wrote:
Hi All,
If I got one table A_table with many columns, and a second table B_table is
the same but with just primary field and unique field...
How much meaningful is the time difference between these queries?
1. SELECT unique_field FROM A_table WHERE prim_field='val';
2. SELECT
Colin Lawrence wrote:
Hi,
I'm running RedHat Linux 7.2 and I want to install MySQL 4.1. I have downloaded the following RPM packages to install in the following order:
MySQL-server-4.1.1-1.i386.rpm
MySQL-client-4.1.1-0.i386.rpm
MySQL-devel-4.1.1-0.i386.rpm
MySQL-shared-4.1.1-0.i386.rpm
I try to
I have MySQL Server 3.23.xx running on RedHat Linux 9 with 40GB
harddrive and 256 RAM. I'm using MyISAM table type with around 157
tables.
I think i decided to change MyISAM table to InnoDB table. But, I don't
know how to do that for the first step. I have read a section on MySQL
documentation
On Thu, 26 Feb 2004, Lorderon wrote:
Hi All,
If I got one table A_table with many columns, and a second table B_table is
the same but with just primary field and unique field...
How much meaningful is the time difference between these queries?
1. SELECT unique_field FROM A_table WHERE
On Thu, 26 Feb 2004, Keith Thompson wrote:
Given these two tables:
create table t1 (
id int unsigned auto_increment,
a int,
... [other fields]
primary key (id),
index aid (a,id)
) type=innodb;
create table t2 (
id int unsigned,
Asep Andria I.W. wrote:
I have MySQL Server 3.23.xx running on RedHat Linux 9 with 40GB
harddrive and 256 RAM. I'm using MyISAM table type with around 157
tables.
I think i decided to change MyISAM table to InnoDB table. But, I don't
know how to do that for the first step. I have read a section
Using the latest MySQL 4.
I could use some help on performing a join but not retrieving all the
records of the child table. I have a set of tables, the ones involved
in this are related as follows:
members (one) - (many) orders (one) - (many) orderitems
The end result should be a list of
hi ,
i have created datetime field in the field name
"abc".
so i want to get the system date and time
automatically to the abc field for in each records. how can i do that ?can
somebody help me .plz
thanx in advance
curlys
--
MySQL General Mailing List
For list archives:
1) This is mostly an SQL question, although MySQL may have some trick up its
sleeve that would help me.
2) I've searched the archives, and google
3) I've been using SQL for a long time, but can't think of a way to solve this
4) This may not be possible. :)
I am dealing with serial data that is
Hello
I use SQLyog (http://www.webyog.com/sqlyog) to import
data from my access db to MySQL.
Karam
--- Jacque Scott [EMAIL PROTECTED] wrote:
I have a .mdb file which I need to import into
MySQL. This needs to be
done behind the scenes and with code. Can I use
LOAD DATA INFILE where
I use
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location=/Volumes/foo/sql_dumps/
# set db_list to the list of databases
db_list=`echo show databases | /usr/local/mysql/bin/mysql -N -u
-p`
for db
This query was pretty fast avg. 1-3 s / search
SELECT m1.id FROM table1 AS t1 JOIN table AS t2 ON m1.textid=m2.id WHERE
match(t2.text) AGAINST('$searchString' IN BOOLEAN MODE);
I also added an index on table1.textid and table2.id.
Is there a way to optimize this query even more?
// Fredrik
Hello,
I'd like to apologize, I know what I am asking is probably impossibile,
but I would like to know if someone has a way to set up permissions on a row
basis, for example if a certain condition matches (for example, grant select on
row if columnA is NULL).
Anyone has any idea on how to do so?
Hi,
We wanted to keep one of Innodb table on RAM disk in our database design so
that we can get better performance. We were hoping the take adventage of
using MULTIPLE TABLESPACE feature of 4.1.1 but I just found out that InnoDB
stores each table into its own file tablename.ibd in the database
Given these two tables:
create table t1 (
id int unsigned auto_increment,
a int,
... [other fields]
primary key (id),
index aid (a,id)
) type=innodb;
create table t2 (
id int unsigned,
b int,
... [other fields]
index id
Hello All,
Is it possible to define MERGE table on several tables with full-text
indexes?
And to make a select on the MERGE table with MATCH AGAINST?
thanks,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Charles,
Answers:
1. Frequent web viewers
2. Medium... internal website
3. An invoice will get frequent views while it's active, but very few
views after it's completed.
4. About 1200 entries a month.
Are there approaches other than what I described?
-Ed
-Original Message-
I raised tmp_table_size to 1000M and restarted mysql on the slave and still
got the same error. Any other variables I should be looking at?
Thanks,
Brian
I don't need any of that SQL stuff -- I just want a database!
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
You might want to append table to table.. in this case you should use UNION
(not JOIN).. but if you got 2 identical tables of type MyISAM, then you can
define a MERGE table like this:
CREATE TABLE new_table (*table definition of the original tables*)
type=MERGE union=(all_by_Payroll,payinc);
I have a .mdb file which I need to import into MySQL. This needs to be
done behind the scenes and with code. Can I use LOAD DATA INFILE where
I use the .mdb file instead of a .txt file?
An mdb file isn't exactly the same as text, is it?
You might as well use MS Word as the source ;-)
If
Hi,
The comments in the fulltext doc page
(http://www.mysql.com/doc/en/Fulltext_Search.html) discuss the issues of
stopwords and over 50% hits, so I did my best to avoid those particular
bombs in my searches.
The subject column contains subjects for message posts/entries, and as
such they're
I have a .mdb file which I need to import into MySQL. This needs to be
done behind the scenes and with code. Can I use LOAD DATA INFILE where
I use the .mdb file instead of a .txt file?
If not does anyone have any suggestions?
Thanks,
Jacque
Philip Mak wrote:
On Thu, Feb 26, 2004 at 10:49:08AM -0700, Sasha Pachev wrote:
SELECT COUNT(*)
FROM topics
WHERE lastPostTime $postTime
OR (lastPostTime = $postTime AND id $id);
Can you just add id $id to the where clause?
No, that won't work because id is only used to disambiguate the
On 26 Feb 2004 at 13:22, Eric Scuccimarra wrote:
But it appears that new rows are not automatically indexed. Does
anyone know about this and if they are not indexed how do I reindex
the tables?
You're misunderstanding something. When you create an index, all the
rows in the table are
Have one more question - indexing the relevant columns based on the explain
info has made all of our queries immensely faster.
But it appears that new rows are not automatically indexed. Does anyone
know about this and if they are not indexed how do I reindex the tables?
Thanks.
--
MySQL
Cliff Addy wrote:
On Wed, 25 Feb 2004, Sasha Pachev wrote:
where dbh is a global MYSQL structure. This code works fine on the old
system. If I pull it out into it's own little test program on the new
server, it also works fine. But when I put it in with the analog source
code, it compiles
Jochem van Dieten wrote:
Vincent wrote:
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Restore from backup.
If there is no backup, mysql_install_db will re-recreate the default install
version - just make sure to remove all mysql/user.* files from the
Hello!
I'm using a WLS server and MySQL. Where am I supposed to put the
mysql-connector-java-3.0.11-stable-bin.jar to make sure WLS will find it? I've tried
several places ie. under ttk and right under classes. Still WLS doesn't find my
mysql.jar file. It works when I'm compiling it locally
Vincent wrote:
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Restore from backup.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
all my mistake I deleted mysql.user this tablewhat can I do to
recover this ?
Plz help~
Best regards,
Vincent fung
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Andrea Riela wrote:
Hi folks,
my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:
mysql use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't
Keith Thompson wrote:
What is the preferred way of storing a dollar amount in the range
0.00 - 9.99?
double
decimal(11,2)
bigint (storing value*100)
...?
I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.
bigint
Is there a corresponding 'AND' version of the 'UNION' ?
... UNION ALL ...
PB
Without seeing the data I am assuming that you are going over the 30%
threshold with your less/greater equal to where clauses. What sort of
criteria are you asking the database engine to search for?
Original Message
On 2/25/04, 9:44:02 PM, [EMAIL PROTECTED] wrote regarding Re: Query
For anyone who is interested the thing that worked and brought the query
down from 8 minutes to 5 seconds was separating out the JOIN to remove the
OR. I made it into two queries and UNIONed them together and it all works
beautifully now.
Thanks.
At 02:33 PM 2/25/2004 -0800, Daniel Clark
No change. Any other suggestion?
Thanks.
Kirti
-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 7:26 AM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'
Subject: Re: Installation problem!!!
Hi!
try using the one installed in
Hi List,
I'm using mysql-4.0.15a. But we need some specific features present in 4.1.X such as
1. INSERT ... ON DUPLICATE KEY UPDATE query support
2. Innodb multi-table space (one ibdata file per table)
Could someone point me to patches for them for 4.0.15a release. so that I can back
merge
Hi!
try using the one installed in /usr/local/mysql/bin/mysql_install_db
Best Regards!
On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote:
Hello List:
I have installed MySQL Master Server from Binaries 4-5 times without
problem. Now I am installing MySQL CLIENT from source and have run
Please help me understand this:
~ are supposed to adjust the weight of a word to the
relevancy score, but they only work in BOOLEAN MODE
and BOOLEAN MODE doesn't care about relevancy!
I am really confused. Could anyone kindly explain how
they supposed to work to me?
Thanks so much!
Haitao
91 matches
Mail list logo
