As mentioned in the original email, I know about forcing it, but I can't do
that in my case.
DÆVID
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 24, 2006 6:27 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: How do I turn
Wow, if I read that right, it means someone on the East coast submits
answers to a test, it's somehow adjusted to be the same as someone who
submits answers to a test from the west coast 3 hours later (time zone
wise)? I can't possibly imagine how that works, but if it does that solves
huge problem
There may be a clue at the bottom of every message ;-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Phil Robbins wrote:
Perhaps you should read the notice at the bottom of each post that you
receive from the list !!!
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
ema
++
Phil Robbins
Auckland
New Zealand
++
_
Discover fun and games at @ http://xtramsn.co.nz/kids
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote:
>
> No ideas?
>
> I tried playing around with read/writ
If you run a script with
mysql < script.sql
then if there's an error, the script dies.
If you run a script with
mysql -e "source script.sql"
Then the script will just spit out an error and move on to the next command.
Hopefully that will help.
-Sheeri
On 5/24/06, Daevid Vincent <[EMAIL PRO
I don't think MySQL can do thatmaybe with some kind of stored procedure
If you're using 5.0 or higher, use the INFORMATION SCHEMA to find out
if the column exists. If not, use the "show create table" statement
and parse it.
Why is this a problem, though? (just curious, I'm not sure thi
Rich
for what? is
SELECT host,user,password FROM mysql.user;
showing you cleartext passwords? It shouldn't.
-Sheeri
On 5/23/06, Rich <[EMAIL PROTECTED]> wrote:
Hi folks. Me again.
I finally got this all up and running under crypt of 'cleartext'.
So, even though I am going to be o
Moritz Möller wrote:
Hi Dan,
there are about 2GB free, so the net size would still be 32 GB.
The queries are really optimized, >99.9% of all queries can be satisfied
without table scans.
Well, I guess I have to give NDB a chance, I hope it will help. The only
alternative I come to is to cluste
Hi Dan,
there are about 2GB free, so the net size would still be 32 GB.
The queries are really optimized, >99.9% of all queries can be satisfied
without table scans.
Well, I guess I have to give NDB a chance, I hope it will help. The only
alternative I come to is to cluster the database on appli
Whil Hentzen wrote:
Hi folks,
Brand new Fedora Core 5 box running MySQL 5. I can get into the monitor
and connect, work with databases, etc. I can't get the MySQL
Administrator to run - get lots of errors:
1. I downloaded mysql-administrator-1.1.10-1.i386.rpm.
2. As root, in /usr/bin, did
r
A big "Thank you" goes to you! That was it!
Looks like I tried with too many parentheses i.e.
/this is wrong/
SELECT FROM ...
(
(SELECT FROM ...)
UNION
(SELECT FROM ...)
) AS abc
Regards,
Luke
- Original Message -
From: "Neeraj" <[EMAIL PROTECTED]>
To: "'Luke'" <[EMAIL P
Moritz Möller wrote:
Hi list,
we're running some large high-traffic mysql servers, and are currently
reaching the limit of our machines.
We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is
quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is
CPU.
The
Brian,
CURRENT_TIMESTAMP gives you time in your server's timezone.
UTC_TIMESTAMP gives GM (universal) time, so dispenses with all timezone
adjustments. Trouble is, you cannot use it as a defalt. You have to
pass it as an INSERT value.
PB
-
Brian Menke wrote:
Brian,
Somehow the server ate my response...
Re your schema,
--it's redundant to define PRIMARY and UNIQUE keys on the same column,
--why not an INT student id?
--what if two (eg married) students share an email account?
--comparing datetimes across multiple time zones will be simpler if you
Semi related to this, as it appears in my searching that this is
unfortunately not a supported feature. Is there a flag or something that I
can put in my .sql file that will turn OFF any error checking, execute my
statements (so that even if one fails, the next one will be tried), then
turn it back
Hi list,
we're running some large high-traffic mysql servers, and are currently
reaching the limit of our machines.
We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is
quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is
CPU.
The queries run very fast (
Peter, thanks for the detailed info. I will figure out how to get rid of the
UNIQUE key. Somehow that got added. Thanks for the catch. As far as INT for
student id goes, I'm using email because it will be unique, and offers an
easy way to track a user through the app I'm building (user name, passwo
Hi folks,
Brand new Fedora Core 5 box running MySQL 5. I can get into the monitor
and connect, work with databases, etc. I can't get the MySQL
Administrator to run - get lots of errors:
1. I downloaded mysql-administrator-1.1.10-1.i386.rpm.
2. As root, in /usr/bin, did
rpm -Uivh /home/zips/m
Brian
Re your schema,
--it's redundant to define PRIMARY and UNIQUE keys on the same column,
--why not an INT student id?
--what if two (eg married) students share an email account?
--comparing datetimes across multiple time zones will be simpler if
you
set completed_modules.tim
I think doing a sort by date with limit 10 should get you the first
ten. I believe the now() function uses the server time, so no need to
do date/time calcs really.
Good luck,
Jason
Brian Menke wrote:
I'm hoping for some general advice on an approach for the following
scenario:
I have a
>Surely the column name has to exist in both tables?
Indeed.
>Graham is using page.category_id and category.id, content.page_id and
page.id
His column specs weren't complete. If you're right on this, though...
>, so I think ON (as I posted earlier) is the only way to do this.
...you're right on
nigel wood wrote:
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was t
Hi, I'm having problems with a trigger that I'm working on, I want to create
a trigger that after inserting a row in table A will copy the row to table B
and once there will delete the row from table A.
I'm using two triggers for this one goes on table A and does the copy of the
information to ta
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was thinking about this m
I want to do something like this:
if not exists `hotel_page_templates`.`hpt_custom_fields`
alter table `hotel_page_templates` add column `hpt_custom_fields` text after
`hpt_alternate_username`;
ÐÆ5ÏÐ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able
Bgs wrote:
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I played
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able to fine-tune the new
Hi -
It's been a short while since I've seen any discussion on this subject,
and I'm wondering what's happened in this arena since then.
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a fancy new server,
compared to
Brian,
Just my 2 cents :)
I always try to use an epoch time stamp for anything time related. its
easier to compare times and all the functions are built into mysql to
convert to/from a unix epoch timestamp
select unix_timestamp(NOW());
+---+
| unix_timestamp(NOW()) |
+--
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id = page.id
>Are there any advantages to converting this 'working' query below to
>use INNER JOIN ?
>If so, what would the correct syntax be ?
>
>SELECT category.name, page.name, content.title, content.body
>FROM category, page, content
>WHERE content.page_id = page.id
>AND page.category_id = category.id
>AND
I'm hoping for some general advice on an approach for the following
scenario:
I have a customer who wants to put an incentive program in place for
students taking learning modules and then completing tests. The concept is
simple. Award the first 10 people who complete a test with a score of
100
On 5/24/06, Christopher Korn <[EMAIL PROTECTED]> wrote:
Hello everyone,
Today a script killed a few InnoDB tables in my database. Although I have backups (2 days
old) I want to recover - if possible - a more current state of my database. Is it
possible to recover tables via the "ib_logfileX" f
many thanks Chris :)
g
On May 24, 2006, at 1:19 AM, Chris Sansom wrote:
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below
to use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.na
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I played around with
Check this out, it works a treat for me:
http://www.tmda.net
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Wed, 24 May 2006, Jørn Dahl-Stamnes wrote:
> To: mysql@lists.mysql.com
> From: Jørn Dahl-Stamnes <[EMAIL PROTECTED]>
> Subject: Re: SPAMs
>
> O
On Wednesday 24 May 2006 14:48, George Law wrote:
> more than likely someone is harvesting emails off groups.google.com
>
> http://groups.google.com/group/mailing.database.myodbc
>
> Your posting shows top of the list :)
Yet another reason for not using google. It seems like they help the spammers
战芳 wrote:
>Hi! gerald_clark,
>But when I call mysql_pconnect("localhost:3306","root","root_password"),it
>return the same error. How can I get the permission to open
>/var/mysql/lib/mysql.sock?
> Fang
>
>
>
what do you get when you do
ls -l /var/mysql/lib/m
more than likely someone is harvesting emails off groups.google.com
http://groups.google.com/group/mailing.database.myodbc
Your posting shows top of the list :)
George Law
> -Original Message-
> From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 24, 2006 7:38 AM
Thanks everybody for attention!
I make some changes in hardare and in my table, and obtain a average response
times of 0.09 second.
Now i have a good time ! :-)
Show you my changes:
1-Update MySql 4.1.18 -> 5.0.21.
2-Upgrade my memory to 3 Gb.
3-Severance of temporary/logs files and data file
Hello everyone,
Today a script killed a few InnoDB tables in my database. Although I have
backups (2 days old) I want to recover - if possible - a more current state of
my database. Is it possible to recover tables via the "ib_logfileX" files?
If i simply open the files with VIm I can see that
On Wednesday 24 May 2006 13:36, Logan, David (SST - Adelaide) wrote:
> Hi Jørn,
>
> I myself haven't had too many spams, I get a few anyway from various places
> my email address is placed. I would suggest try unsubscribing using this
> alias and just re-subscribe with your new (known only to you)
Hi Jørn,
I myself haven't had too many spams, I get a few anyway from various places my
email address is placed. I would suggest try unsubscribing using this alias and
just re-subscribe with your new (known only to you) alias.
Regards
---
Seems like someone has got their hand of my e-mail alias which I use for this
list only. It started last friday and I get about 10-15 messages every day.
Does someone else has this problem?
What's the procedure to change my subscribtion e-mail addresse?
--
Jørn Dahl-Stamnes
homepage: http://ww
There is no reason why you cannot use diffeent package
managers for your system. The only thing is do not run two
managers at the same time, as they require exclusive access
to the rpm database.
Trying to use more than one package manager, or multiple
instances of the same one is not a good id
Hi!
> "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes:
Peter> Best group member,
Peter> My computer stopped working. And I was able to install Windows on another
Peter> partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter> I have all C: working, and can acces
Hi!
We have that huge query against a mysql 4.1 (myisam) to retrieve rows.
The query is built dynamically using a loop, as we are searching in an
external database built to store a tree with the nested tree model.
When we do this search with a "normal" world, it's fine: the query is around
4
It was just to copy the files from the DATA folder in the installation
directory. That was easier then I thought.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 6:52 AM
To: mysql@lists.mysql.com
Subject: Urgent problem
Best group member,
My
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.pa
1 - while your current select query is reasonably fast, it likely could
be faster. It may be that it's taking 0.9 seconds and feels fast, but
perhaps it could be 0.09 seconds instead - and that's not something a
human can really tell the difference on. It's using an indexed column
(status), bu
53 matches
Mail list logo