Hi list,
I have a few questions. I have to start a new project and I have to choose
the db. The most difficult choice of all. My question is : could mySQL be used as a
enterprise database with approx. 50 users connecting to db ? The db is financial
critical, so everything should
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this thread.
At 18:55 -0700 10/6/03, Don Cohen wrote:
Paul DuBois writes:
> >Perhaps I misunderstood the doc but I thought by using _use_result
> >I was asking for the server not to send the next tuple until I as
At 18:09 -0700 10/6/03, Don Cohen wrote:
Paul DuBois writes:
> At 17:26 -0700 10/6/03, Don Cohen wrote:
> >http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
> >says
> >
> > you must retrieve all the rows even if you determine in
> > mid-retrieval that you've found the
Paul DuBois writes:
> At 17:26 -0700 10/6/03, Don Cohen wrote:
> >http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
> >says
> >
> > you must retrieve all the rows even if you determine in
> > mid-retrieval that you've found the information you were looking
> > for.
Adam Clauss wrote:
I am going to possibly have to transfer a MySQL database that is currently
running on Windows to a Linux/Unix box (not sure exactly what version it is
running yet). Any pitfalls to avoid here?
Thanks
Adam Clauss
[EMAIL PROTECTED]
I would use 'mysqldump' to backup the databas
At 17:26 -0700 10/6/03, Don Cohen wrote:
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
says
you must retrieve all the rows even if you determine in
mid-retrieval that you've found the information you were looking
for.
My question is: why?
Because there is no provision
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
says
you must retrieve all the rows even if you determine in
mid-retrieval that you've found the information you were looking
for.
My question is: why?
In fact I thought that the normal interface for a database would sho
I am going to possibly have to transfer a MySQL database that is currently
running on Windows to a Linux/Unix box (not sure exactly what version it is
running yet). Any pitfalls to avoid here?
Thanks
Adam Clauss
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.my
Hi, I am moving a myself database from one hosting company to another for a website.
I have statements like:
INSERT INTO mpn_shopping_4nstats_datecnt VALUES ( '22022002', '79');
But MySQL comes back with:
INSERT INTO mpn_shopping_4nstats_datecnt VALUES ( \'22022002\', \'79\');
MySQL said:
Y
I am using MySQL (4.1.0-alpha-max-nt) on Windows 2000.
I'm trying to read a text file that looks a bit like this:
40 3 10 M000 ... 1000... ACBB... ...
where the ... indicate more characters. I've created the
following table to store this data
(
id int NOT NULL,
year INT NOT NULL
If I have a database with various dates in it, how can I search for all
instances of the same date. Note that I do not know what the dates are
(or how many there will be) so the search can't be hardcoded. These
dates will be added based on user input from a website.
Is there some kind of comparis
So then Paul DuBois says...
> One way to set the path would be to place your mysqldump command in
> a helper script:
>
> #! /bin/sh
> export PATH=your-path-setting-here
> mysqldump
>
> Then invoke the helper script from the crontab, rather than invoking
> mysqldump directly.
You can set the P
At 17:09 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote:
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM, Paul
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote:
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote:
Does the PATH setting for jobs
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote:
Does the PATH setting for jobs run by cron include the directory where
mysqldump is located
At 16:33 -0400 10/6/03, Patrick Larkin wrote:
Hello -
I have the following command to back up a MySQL database on a remote
machine. Works beautifully from the command line when run manually
as root:
mysqldump -h 192.227.20.50 -u root --password=yourmama --opt my_database >
/Dumps/my_database.d
Hello -
I have the following command to back up a MySQL database on a remote
machine. Works beautifully from the command line when run manually as
root:
mysqldump -h 192.227.20.50 -u root --password=yourmama --opt
my_database >
/Dumps/my_database.dump
This results is a nifty SQL file with da
On Mon, Oct 06, 2003 at 12:43:37PM -0700, David L. Sifry wrote:
> An update to the problem, and a workaround (bug report?):
>
> Jeremy Zawodny wrote:
>
> >While the tables are locked, be sure to also copy the slave's
> >master.info file, relay log(s), and relay index file. Transfer all of
> >tha
Hope I am posting to the right list. I am new here.
I have a sun system:
SunOS spot 5.6 Generic_105181-05 sun4u sparc SUNW,Ultra-4
With gcc installed:
# gcc -v
Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs
gcc version 2.7.2.3
I am trying to compile:
mysql-4.1.0-a
Hey all,
I sent this a few days ago, but it may have gotten lost in the weekend
for many of you. Don't worry, I won't keep re-posting it. :)
I'm hoping someone out there is doing some sort of high-availability
replication and can give me a few pointers.
Thanks in advance!
Don
Orig
An update to the problem, and a workaround (bug report?):
Jeremy Zawodny wrote:
While the tables are locked, be sure to also copy the slave's
master.info file, relay log(s), and relay index file. Transfer all of
that to the other slave and you should be good to go.
Does that make sense?
Actu
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
Hi folks,
The following is copied exactly from my machine, except for the munged
password. Setting the root password can't be completed, because the host
apparently can't connect the mysql server. What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done
This may seem like a strange problem but I have unwittingly managed to install two
instances of MySQL on RedHat 8. One is the compiled binary version (which is what
starts when the system is booted) and the other was from an RPM. I 'thought' I have
removed the binary flavor before installing the
Richard,
If you want to protect against hard drive failures then a RAID setup is
probably the best option. A RAID will ensure that you always have an
up-to-the-instant backup of all of your data in case a drive goes bad;
however, a RAID won'tstop a bug, virus, or error from screwing up you
On Sun, Oct 05, 2003 at 11:55:03PM -0700, David L. Sifry wrote:
> I've got a somewhat advanced mysql administration question for y'all.
> Here's my situation:
>
> I've got a master database that is doing lots of inserts, deletes, and
> updates. It has a number of slaves hanging off of it. One
Hi Stanley,
You also have the options to indicates mysqld to checks and repairs tables
automatically as it detects corruption or crash.
Put in the section mysqld of your my.cnf file these 2 variables :
first:
set-variable = myisam-recover=BACKUP,FORCE
(it will try to do 'safe' repair, otherwise mak
On Mon, 2003-10-06 at 14:21, Richard Reina wrote:
> I am wanting to protect myself against future potential hard drive
> failures on my DB server running version 3.23.49a. Should I try and set
> up a RAID, a mirror or would the best solution be to set up MySQL
> replication. Any suggestions wo
Thank you, even if I checked a lot the syntax, couldn't see it (too obvious).
Sorry for the time...
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 13:06 -0400 10/6/03, Franck Babin
wrote:
> >It's a syntax error. Even when I try without DATE_FORMAT:
> >
> >UDPATE activity SET activity_date = '20
Execute in shell myisamchk --help
This will list a serie of options to repair your tables. Obviously, this only
works to MyISAM tables.
;)
Alexis
Quoting Stanley Joseph <[EMAIL PROTECTED]>:
> Dear All ,
> A few tables of my database crashed and are not getting repaired .What is
> the best way
I am wanting to protect myself against future potential hard drive
failures on my database server running version 3.23.49a. Should I try
and set up a RAID, a mirror or would the best solution be to set up
MySQL replication. Any suggestions would be greatly appreciated.
Richard
--
MySQL Gener
At 13:06 -0400 10/6/03, Franck Babin wrote:
It's a syntax error. Even when I try without DATE_FORMAT:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no =
1 WHERE activity_date =
'2003-06-10 11:15:00' AND type_no = 1;
Ah.
Perhaps spelling UDPATE as UPDATE will fix the problem. :-
Hi Jacco,
Perhaps the manual needs to be enhanced, but it is only a guide,
perhaps the language should be softened or 'error 136' modified that
it could be either problem. Either way I hope this fixes you problem,
my guess would be you have very large rows of data, which is why you
did not hit
I am wanting to protect myself against future potential hard drive
failures on my DB server running version 3.23.49a. Should I try and set
up a RAID, a mirror or would the best solution be to set up MySQL
replication. Any suggestions would be greatly appreciated.
Richard
--
MySQL General Mai
At 11:40 -0500 10/6/03, Steve Buehler wrote:
I am using PHP & MySQL for a program that I am writing. I have a
table in my database that has a column with dates in it in the form
-mm-dd. Sometimes there is nothing in the table with the search
date that I am using. Other times there might b
It's a syntax error. Even when I try without DATE_FORMAT:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no = 1 WHERE
activity_date =
'2003-06-10 11:15:00' AND type_no = 1;
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 12:55 -0400 10/6/03, Franck Babin
wrote:
> >I have made
At 12:55 -0400 10/6/03, Franck Babin wrote:
I have made some changed but it still doesn't work:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no = 1 WHERE
DATE_FORMAT(activity_date,'%Y-%m-%d %H:%i:%s') = '2003-06-10
11:15:00' AND type_no = 1;
I want to update only rows where e
I think you want just "ORDER BY commentid DESC" .The previous answer orders
by commentref first, which is not what I think you want. Maybe you want
"ORDER BY commentid, commentref DESC"
This doesn't seem to be making sure that the "newest" com
I think this is OK.
But if you want to get a recordset with data and know how much records you
have with only ONE query,
you may use:
$date=2003-02-16;
SELECT col1, col2, coln FROM `games` WHERE `date`='$date'
$num_rows=0;
$num_rows=mysql_num_rows($rs_resource_identifier);
I don't remember exact
I have MS Access front end with MySQL back end working in my office. MSAccess
via CrossOver office on Mandrake is horrible. So, I am looking now to probably
go with ERP (or ERP/CRM) software that I can get freely out there. I have no IT
budget, I am the IT budget, so I have to do something. Any id
I have made some changed but it still doesn't work:
UDPATE activity SET activity_date = '2003-10-06 11:00:00', type_no = 1 WHERE
DATE_FORMAT(activity_date,'%Y-%m-%d %H:%i:%s') = '2003-06-10 11:15:00' AND type_no =
1;
I want to update only rows where equals '2003-06-10 11:15:00'
Is this formula
I am using PHP & MySQL for a program that I am writing. I have a table in
my database that has a column with dates in it in the form
-mm-dd. Sometimes there is nothing in the table with the search date
that I am using. Other times there might be 1000's of rows with that in
the date colum
I think this is not implemented.
But Logically, I also think it is not easy to implement since rows get added
dynamically. So, it is not easy to predict what will be in the table.
Since I needed such a feature in my application, I created an ACL (access
control list) table that allows me to contr
At 12:09 -0400 10/6/03, Cummings, Shawn (GNAPs) wrote:
For instance;
mysql> select commentid, commentref from comments GROUP BY
commentref ORDER by commentref DESC, commentid;
+---++
| commentid | commentref |
+---++
|80 |188 |
|73 |
At 12:01 -0400 10/6/03, Cummings, Shawn (GNAPs) wrote:
This doesn't seem to be making sure that the "newest" commentid is
the result... Seems to be random.
Your requirements are unclear.
If you want output sorted by descending order of commentid, then
your original query should produce that. In
Hi,
Does MySQL support row-level access privileges?
Regards,
Madhavi
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Have you tried:
select commentref,max(commentid)
from comments
group by commentref
Regards,
Joseph Bueno
Cummings, Shawn (GNAPs) wrote:
This doesn't seem to be making sure that the "newest" commentid is the
result... Seems to be random.
At 09:11 AM 10/6/2003 -0400, you wrote:
try
select co
For instance;
mysql> select commentid, commentref from comments GROUP BY commentref ORDER
by commentref DESC, commentid;
+---++
| commentid | commentref |
+---++
|80 |188 |
|73 |187 |
|76 |185 |
|56
Jeremy Zawodny writes:
> On Fri, Oct 03, 2003 at 08:29:17AM -0400, John Murtari wrote:
> > Folks,
> >
> > I've done a lot of searches, tried out the tools I could
> > find (like phpMyAdmin/mtop). We have a server with about 30 DB's
> > and we would LOVE to get a report that gives u
At 11:28 -0400 10/6/03, Franck Babin wrote:
I have this simple sql statement:
UDPATE activity
SET activity_date = '9.10.2003 10:00:00', type_no = 1
WHERE DATE_FORMAT(activity_date,'%d.%m.%Y %H:%i') = '09.10.2003 10:00'
AND type_no = 1;
I'm not able to execute the query. It seems that the
portion
This doesn't seem to be making sure that the "newest" commentid is the
result... Seems to be random.
At 09:11 AM 10/6/2003 -0400, you wrote:
try
select commentid, commentref
from comments
ORDER by
commentref ,commentid DESC;
> -Original Message-
> From: Cummings, Shawn (GNAPs) [mailt
So then Ken Menzel says...
> Check out
> MAX_ROWS = #
> and
> AVG_ROW_LENGTH = #
> options in http://www.mysql.com/doc/en/CREATE_TABLE.html
>
> Set MAX_ROWS to a very very large number
> You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE
> Syntax using table options at the end.
>
> Y
your date format is not correct. It should be activity_date = '2003-9-10
10:00:00'.
-Original Message-
From: Franck Babin [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: Dummy problem with UPDATE for DATETIME field
I have this simple sql st
Check out
MAX_ROWS = #
and
AVG_ROW_LENGTH = #
options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large number
You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE
Syntax using table options at the end.
You can verify your changes by running SHOW TABL
I have this simple sql statement:
UDPATE activity
SET activity_date = '9.10.2003 10:00:00', type_no = 1
WHERE DATE_FORMAT(activity_date,'%d.%m.%Y %H:%i') = '09.10.2003 10:00'
AND type_no = 1;
I'm not able to execute the query. It seems that the
portion is not valid. is a DATETIME field.
Any
I recently had my DB stuck, probably because they were too many connexions.
Even as root I couldn't connect (which is contradictory to
http://www.mysql.com/doc/en/Too_many_connections.html). I had to manually
"kill -9" the processes...
How can I avoid this? how can I know what happened?
TIA
Greg
All,
Yo gang! Having a problem with the MySQL ODBC 3.51 driver.
I've got a MySQL volume which has a user table (tbl_usr). I'm linking this
table to an Access database on my workstation (via ODBC link). The account
being used for the connection has select, update, and insert rights to all
tables i
Dear All ,
A few tables of my database crashed and are not getting repaired .What is
the best way to recover the data .
Any suggestion will be of great help .
Regards
Stanley Joseph
+44 (0) 208 665 4291 (W)
+44 (0) 777 621 0132 (M)
http://www.themobilerepublic.com
The Price, The Choice, The Serv
How would one join multiple table and selected all
records from a joined table whether they exist OR not?
I can get the records if they exist in a second table
and I can get the records if they don't exist, but is
there a way to combine the two?
I have, for example, a statement like this (selects
I'm using linux, Red Hat 7.3 Linux version 2.4.22,
and 3.23.55-Max-log. Is This information ok?, or I'm missing
something.
Greetings
Mikel
_
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
http://photos.msn.es/suppor
try
select commentid, commentref
from comments
ORDER by
commentref ,commentid DESC;
> -Original Message-
> From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 02, 2003 2:37 PM
> To: [EMAIL PROTECTED]
> Subject: sorting/grouping
>
>
>
>
> I have a v
I have a very simple table.
commentid, commentref (each field is an INT)
Each record is a comment... commentid is the ID (each new record is a
higher #).. and the commentref field if the "story" the comment refers to.
I want to be able to list the stories in order from "most recent comment"
Adam,
please Cc: [EMAIL PROTECTED], so that others can follow this discussion.
If the innodb_table_monitor does not show those #sql... tables in InnoDB's
own data dictionary at all, then you can simply delete the .frm files. They
are simply orphaned .frm files. You do not need to shut down mysqld
Hi,
We have a database with a table whose data file (.MYD) has grown to 42
GB and an associated index (.MYI) file that's grown to 17 GB, at which
point MySQL gave us an error 136 (No more room in index file).
The MySQL manual says (in paragraph 4.4.6.9 "How to Repair Tables") that
this type of
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they h
Maybe like:
SELECT something FROM tablename
WHERE date_column >
DATE_SUB(CONCAT(YEAR(NOW()),'-',MONTH(NOW()),'-','01'), INTERVAL @n
MONTH)
@n is the number of months you want. If you want data from the current
month, @n would be 0.
--
Diana Soares
On Mon, 2003-10-06 at 07:23, [EMAIL PROTECTED
Hi!
It depends, what language use you to include SQL commands. I use Java and if
I use scrollable result set I can resolv the problem inside a class.
Best regards
On Mon, 6 Oct 2003 10:00:37 +0200, Director General: NEFACOMP wrote
> Hi Group,
>
> I want to use a UNION in order to SELECT column
Hi Group,
I want to use a UNION in order to SELECT columns from several tables but I wish MySQL
could use the following syntax:
SELECT {several fields} FROM (Table1 UNION Table2 UNION Table3 . ) WHERE condition
Currently I think MySQL only supports the following:
(SELECT {several fields} F
Hi group,
I have two questions about error messages in MySQL.
1. Section 4.6.2 talks about Non-English error messages. It says that for recompiling
the errmsg.sys file, one will issue a comp_err command at the SHELL prompt.
Does such a utility exist for Windows? I mean can someone tell me when t
Adam,
I am sorry, I tested the procedure below and noticed that there was an
assertion that fails. I have now fixed the assertion to 4.0.16 and 4.1.1.
You have to wait for those versions. Meanwhile, you can use the
innodb_table_monitor to check what those #sql... tables are.
If mysqld crashed in
70 matches
Mail list logo
