Daniel Kasak wrote:
Greetings.
I have a script which seems to be bringing our server to its knees.
I've isolated one query which is doing it:
delete from TelecomAccountPosting where LocID = 19014 and InvDate =
'20080115';
I have an index which covers both LocID and InvDate:
CREATE TABLE
mos wrote:
I tried :
select SQL_NO_CACHE * from table where col1='abc';
which took 800ms the first time it was executed. The second time it was
executed it took 0ms. How is that possible if the query is not put into
the query cache? Should the query take roughly the same amount of time?
Mauricio Tellez wrote:
Hi, I'm developing a PHP/MySQL app, and I use load data infile to feed
data to MySQL. At the develop server I haven't any error, the app works
great, but when I upload to the production server, all the load data
infile statements fails with an error like this: can't stat
Krishna Chandra Prajapati wrote:
Hi all,
Mysql on debian operating system has debian-sys-maint user. What is the role
of this user debian-sys-maint.
Read the /etc/mysql/debian-start file to see everything that debian does
when mysql starts up. It uses the debian-sys-maint user for all of
Xuekun Hu wrote:
Hi, guys
I am behind a firewall, and have to use http proxy. However seems like
the free bitkeeper client (http://www.bitmover.com/bk-client2.0.shar)
doesn't support HTTP proxy.
export http_proxy=http://xxx:xx/
./bkf clone http://mysql.bkbits.net/mysql-5.1 mysql-5.1
Bad URL
jekillen wrote:
Hello:
The saga of this machine continues:
FreeBSD v6.2
latest mysql version installed from ports:
mysql51 client, serve, and scripts.
There is no /usr/local/mysql
it did not create this dir.
No idea where it should put the files, a freebsd list might be able to
point you in
, albeit an extremely low budget one! I'll go for the
free options first, I think.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Half this game is ninety percent mental.
-- Philadelphia Phillies manager, Danny Ozark
--
MySQL General Mailing List
For list archives
!
It does all seem a little unsatisfactory, doesn't it?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Anyone who is disturbed by the idea of newts in a
nightclub is potentially dangerous.
-- Frank Zappa
--
MySQL General Mailing List
For list archives: http
miniBB
phpBB
PunBB
SEO-Board
Simple Machines Forum (SMF)
Vanilla
Any recommendations from among these or others?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Anyone who is disturbed by the idea of newts in a
nightclub is potentially dangerous.
-- Frank Zappa
--
MySQL
),
(3,NULL),
(3,NULL);
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
David T. Ashley wrote:
Hi Chris,
OK, I will try that. Thanks for the help.
My assumption in reading your original post was that you didn't understand
what I wanted to do (but you did).
In order for me to use the solution you have proposed, in addition to
working, this behavior would have
TABLE `t` (
`p` int(10) unsigned NOT NULL default '0',
`q` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`p`,`q`)
) ;
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database
I installed mysql server 5.0.22 from source . Also I ran rpm -qa | grep -i
mysql , but no output . as the above I 've already checked to make sure i
did
not install any mysql rpm package in my system . maybe i wiill reinstall
these stuff later :-((
So that all looks good.
Basically php
vc wrote:
the mysql still reports 5.0.22 as the attched pic . maybe phpmyadmin is
not smart enough to detect the correcrt version ?
I guess it's possible but I'd either dig into the code or ask the
phpmyadmin guys to find out for sure.
--
MySQL General Mailing List
For list archives:
vc wrote:
Thanks Ananda ,
I tried , i tried to uninstall the maybe-preinstalled mysql, but rpm tells me
that there is no mysql installed in my system .
I listed all the rpm packages in my system . I am quite sure there is no rpm
mysql package .
I installed the php 5.2.0, mysql 5.0.22,
mos wrote:
I have a merge table that is a union of 20 1 million row tables. Select
rows from it is quite fast. However if I want to delete all the rows as in:
delete from MyMergeTable;
it takes just over 3 minutes. I could execute 20 separate delete
statements for each of the 20 tables and
Ian M. Evans wrote:
Bad news: I have a slow query that doesn't appear to be using an index
even if I force it.
Good news: the forehead shaped dent in my desk is really progressing well.
Here's the query:
SELECT DISTINCT poster_data.*
FROM poster_data, poster_prodcat, poster_categories
WHERE
happened with in say 10 seconds. So my group by would be more like..
GROUP BY CreateDate +- 10 SECOND
Is there a way to do this?
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater
.FName AND u1.LName = u2.LName
LEFT OUTER JOIN userprofile p ON u1.UserID = p.UserID
GROUP BY u1.UserID
HAVING `Count` 1
ORDER BY u1.LName, u1.FName
However that returns rows that are not duplicate names and I'm not sure why.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM
to match of FName and
LName. I tried to use concat to build the full name and do the not in
based on the new field MySQL didn't like that query at all.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm
Scott Haneda wrote:
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a good idea, as it
Scott Haneda wrote:
Scott Haneda wrote:
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http
to that
connection. There is no reason to replicate these to a slave at all,
as no client connecting to that slave would ever be able to see them.
- michael dykman
On 9/20/07, Chris Scheller [EMAIL PROTECTED] wrote:
according to
http://dev.mysql.com/doc/refman/4.1/en/internal
replicating cleanly.
--
++---+---+
| Chris Scheller | http://www.pobox.com/~schelcj | JID: [EMAIL PROTECTED] |
++---+---+
| Ubuntu -- an African word, meaning
according to
http://dev.mysql.com/doc/refman/4.1/en/internal-temporary-tables.html
temporary tables can sometimes be written to disk as myisam. in
replication are these myisam temp tables sent to the slaves as myisam
tables or in memory tables?
--
MySQL General Mailing List
For list
more than one table involved),
so try:
SELECT id FROM friends WHERE firstname LIKE '%johnie%' ORDER BY
firstname LIMIT 0,
... and unless you've really got more than friends that limit
clause is redundant too. :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk
different, but it might be worth a shot - always works for me anyway.
:-)
But also: are you confident there's more than one row to be fetched?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
He who slings mud, usually loses ground.
-- Adlai Stevenson
--
MySQL
variable.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http
indexed that way (fore, sur and
topic) to fulltext and bingo! Not only that, but it all happens fully
FOUR TIMES as quickly!
So many thanks, Baron - mainly due to you, yesterday was a very good
MySQL day for me. It's not often I get two 'lightbulb moments' on the
same day!
--
Cheers... Chris
Chris Hemmings wrote:
Baron Schwartz wrote:
Hi Chris,
Chris Hemmings wrote:
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time)
since
all the values are the same. You may already know that, but thought
I'd
mention
Baron Schwartz wrote:
Chris Hemmings wrote:
Chris Hemmings wrote:
Baron Schwartz wrote:
Hi Chris,
Chris Hemmings wrote:
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this
time) since
all the values are the same. You may
Hailiang Ji wrote:
Folks,
A help needed. My manager's pushed me to optimize the tables that I
created in distributed in several DBs. I have tried best to explain to him
that I have followed the strict formula design to do the Join, Search and
so on. However, the system performance is not good
query, perhaps with
subqueries?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Revolution: an abrupt change in the form of misgovernment.
-- Ambrose Bierce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
for instance.
Can you perhaps go into a little more detail?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
The nice thing about standards is that there are so
many of them to choose from.
-- Andrew S. Tanenbaum
--
MySQL General Mailing List
For list archives: http
off on this thread, can you see any way I could improve this?
Naturally, I haven't yet incorporated the treatment of more than one
search term, but I'll try and work that out for myself. :-)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Justice is incidental to law
the difference in time?
Hope you can shed some light onto this :-)
Ta!
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jeremy Cole wrote:
Hi Chris,
Chris Hemmings wrote:
Hello,
I have a table, currently holding 128,978 rows... In this table, I
have a section column (int) and a price column (int). Every row has
a section of 1 currently, every row has a price, ranging from 1 to
10,000.
I have an index
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time) since
all the values are the same. You may already know that, but thought I'd
mention it.
Second, my theory on why query #1 is faster - if all your prices range from
1 up
Baron Schwartz wrote:
Hi Chris,
Chris Hemmings wrote:
Dan Buettner wrote:
Chris, a couple of thoughts -
First, your index on the section is doing you no good (at this time)
since
all the values are the same. You may already know that, but thought I'd
mention it.
Second, my theory on why
entries. All inserts into the table are fairly slow, and
get slower the more things are inserted - with it eventually becoming
unbearably slow to add data. Thanks for any help,
Chris Portka
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Those functions concern dotted quad IP addresses, not packed binaries.
Anybody know of some obscure MySQL functions to do bit logic on strings
or get MySQL to recognize a char sequence as an integer?
Gerald L. Clark wrote:
Wagner, Chris (GEAE, CBTS) wrote:
Hi. I've got IP addresses stored
I don't think this is a bug. I think what's happening is that your
timestamp column can't hold that date, it's max value is somewhere in 2038.
So I guess either change your timestamp column to a datetime column, or
prevent users from putting invalid data in.
Daevid Vincent wrote:
using
on the
string or convert/cast the string as an integer? Thanks.
--
Chris Wagner
CBTS
GE Aircraft Engines
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
alone?
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the system to do caching of
the table data. That works reasonably well on Linux and NetBSD
(at least), but joins and sorts will be slow above a certain
size, and there seems to be nothing that can be done about it.
Good luck.
Best,
chris
--
MySQL General Mailing List
For list archives: http
table.
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1. Get rid of the offending $hostname.index file that keeps track of
binlogs (Thanks, Olaf!).
2. Fix permissions (Thanks, Gerald Clark!).
Have a nice day!
Chris
On Jul 18, 2007, at 2:19 PM, Olaf Stein wrote:
You have bin log enabled and it might be looking for the last bin
log
that if there is no default database it
will not get written if you have a single binlog-ignore-db statement. I
tested this out, and it seemed to work (contradicting the doumentation)
Is there something I'm missing here, or is the documentation wrong perhaps?
Thanks,
Chris
--
MySQL General Mailing List
For list
, it didn't seem to be a
problem until I screwed up the passwords.
I'm just setting up a new server, so the tables and data are not dear
to me. Right now, I just want MySQL to work -- with logging!!
--
Chris Africa
Web Project Manager
Department of Mechanical Engineering
University
Hi Gerald.
Actually, mysql should have access, as it owns the entire directory.
drwxr-xr-x 19 mysql wheel 646 May 30 09:41 mysql-5.0.41-osx10.4-
i686
and nested inside that is
drwxr-x--- 27 mysql wheel918 Jul 18 12:53 data
Thanks!
--
Chris Africa
Web Project Manager
'
AND
ItemTag.ItemID = Item.ProductID
);
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Folks,
I'm wondering is someone could help us in trying to resolve the above error,
we have read through what threads we could find and tried all the
suggestions, but have had no luck.
There are no memory problems, in fact when this happens if there is still a
localhost client connection
if this can be accomplished within the
actual query itself.
Wouldn't this work
SELECT FLOOR((TO_DAYS(CURDATE()) - TO_DAYS('1952-10-06')) / 365 ) AS age
? What version of mysql are you using?
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
mos wrote:
Chris,
You probably want to know the specific table, so I wonder if it
shows up in the MySQL error logs? Of course you can dump the database
structure and look for key x by doing:
mysqldump --no-data --skip-opt --skip-comments --compact
and redirect it out to a text file
may be able
to rewrite this just using joins.
Chris W
David T. Ashley wrote:
Hi,
I'm implementing a software release database. Users may aribtrarily be
members of groups (a many-to-many mapping), and each software release may
contain multiple files.
I'd like to allow users the maximum
?
SELECT ( field1 - field2 ) AS difference FROM MyTable
You should add in some checking to ensure that field1 and field2 values
are actually numbers but that's basically it...
Thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Any help on how to do this in mysql
On 5/30/07, Chris Hoover [EMAIL PROTECTED] wrote:
I have the following trigger in Postgresql, how can we do this in Mysql?
CREATE TRIGGER tr_encounter_lab_order_upd
AFTER UPDATE ON encounter_lab_order
FOR EACH ROW
EXECUTE PROCEDURE
the manual that corresponds to
your MySQL server version for the right syntax to use near 'update
encounter_order
set dx_code = new.dx_code
' at line 5
Chris
Mysql 5.0.41
Does Mysql support groups of users? I am working on porting an application
from Sybase to Mysql and it relies heavily on using groups to control access
to the data. I am not seeing this mentioned in Mysql, but I might be
overlooking something. So does it support groups?
Thanks,
Chris
and
order_id = new.order_id;
end if;
return new;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Can Mysql handle this if logic needed by this trigger, or only fire if a
specific column is updated?
Thanks,
Chris
24 HOUR)
AND '2007-03-23 23:59:59';
Chris
Rob Desbois wrote:
I am having issues with type conversion not working as expected per the
documentation.
I am using in MySQL 5.0.27 for x86/Windows.
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states
have looked in the documentation, and everything
seems to be fine. Please advise on what is wrong.
Thanks,
Chris
Here is the offending statement:
ALTER TABLE clinic_consent_form
ADD CONSTRAINT fk_clinic_c_ref_782_system_t
FOREIGN KEY (tab_id, class) REFERENCES system_tabs(tab_id, class
/refman/5.0/en/innodb-foreign-key-constraints.html
for correct foreign key definition.
I don't understand this since the primary key for system_tabs is tab_id,
class and clinic_consent_form has the index fk_idx on tab_id, class. What
is mysql complaining about?
Chris
On 5/23/07, Baron Schwartz
( 'Y-m-d', strtotime( $UKDate ));
echo 'Before: ' . $UKDate . 'br';
echo 'After: ' . $USDate . 'br';
thnx,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on this ?
Thanks very much in advance !
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Take a look at the following:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#func
tion_unix-timestamp
That looks like exactly what you need...
thnx,
Chris
-Original Message-
From: Bryan Cantwell [mailto:[EMAIL PROTECTED]
Sent: Monday, May 21, 2007 4:45 PM
wang shuming wrote:
Hi,
SQL like
select *,(select f1 from (select f1,date from table1 t1 where
t1.f1=table1.f1 order by date desc limit 1 ) t2 ) lastf1
from table1
shows table1.f1 not found, mysql 5.0.37 .
Break up your query and work out which table1 it's talking about,
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the database.
And this information should not be visible/accessible to any other person but
the owner of the data.
Whilst I know that encryption/decryption is the solution for this, are there
any
Ratheesh K J wrote:
Ok.. Will it be secure if the data is encrypted. mysqldump will show
encrypted data right.
mysqldump will show whatever the database table does - it just grabs
that info and puts it into a file. If it's encrypted in the table,
that's what mysqldump will show.
Actually I
thing I can guess is that there's an obvious error that is not
obvious to me. :)
Thanks,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday, April 24, 2007 10:12 AM Jim Winstead mailto:[EMAIL PROTECTED]
said:
AND `type` = 0
AND `manager_id` = 0
AND `modified` = NOW()
WHERE `id` = 5
you can't use 'AND' to connect your updates, you need to use commas:
UPDATE users SET name = 'First Last', email =
Now, would someone please explain *why* this worked and all my other attempts
didn't? Was it because of file permissions? or the linux user id? or that I
put a passwork on the mysql root account? or that I changed the ownership of the
data file? or that I took out some spaces on the data
I think I fixed it, at least as best I could. still same result:
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ su - mysql
Password:
-bash-3.1$
-bash-3.1$ mysql -u root -p
snip
mysql quit
Bye
-bash-3.1$ exit
logout
No no no.
AS the MYSQL user:
cat /tmp/abc.txt
Thufir wrote:
I'm at total loss. apparently, error 13 relates to file permissions? what
could possibly be preventing the import?
Change to the mysql user (you might have to go to root and then mysql):
# su - mysql
then try it:
cat /tmp/abc.txt
what happens?
--
MySQL General Mailing
mysql LOAD DATA INFILE '/home/thufir/abc.txt' INTO TABLE delta.abc;
ERROR 13 (HY000): Can't get stat of '/home/thufir/abc.txt' (Errcode: 13)
'13' means permission denied.
That is - mysql (which is running as user 'mysql' most likely), can't
read the /path/to/abc.txt file.
Place the file
satimis wrote:
Typing either mypassword or YES prompted;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
* end *
That is asking for your *old* password.
[/quote]
I did not create password before. This is a new
[EMAIL PROTECTED] ~]# mysqladmin -u root password xyz
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
* end *
So you *have* set the root password before.
From your previous emails:
# mysqladmin -u root password
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either mypassword or YES prompted;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
* end *
That is asking
appreciated.
In my experience it is safe and fast to do this sort of thing:
RENAME TABLE live_table TO old_table, new_table TO live_table;
As far as I know doing the 2 renames in one command (as above)
is the only way to do them atomically in MySQL.
Hope that helps,
-Chris
--
MySQL General
Brent,
Thanks for your response.
Enabling journaling isn't going to halve your performance.
I was careful to say write speed, not performance.
I already have my data and index files on separate drives (raid
volumes, actually, each made up of complete drives). What I see
is that the index
to crashes, at the limit.
You can also turn off indexing when loading the data, then turn it back on
when the data is loaded (if you haven't already).
We need INSERT IGNORE, so this isn't really an option for us,
unfortunately.
I'm going to mount them as ext2fs for the time being.
Best,
chris
.
Best,
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Wanted to thank everyone for the insights for some of this date/time issues!
Pretty much what I was looking at, just wanted a little confirmation!
I will also need to research that PHP function -
Thanks - Chris
On 3/6/07, Marcus Bointon [EMAIL PROTECTED] wrote:
On 6 Mar 2007, at 17:12, David
to phpMyAdmin's stats anyway). I've upped the open files limit on
MySQL and Apache (PHP runs as a module).
At this stage I'm completely out of ideas as to what I can do to fix my problem.
Any ideas? What extra information can I provide that could help?
Many thanks,
Chris
--
Chris Boot
[EMAIL
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've hardly ever got
anywhere near my connection limit.
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Chris Boot [EMAIL PROTECTED]
Cc: mysql
Jay Pipes wrote:
Chris Boot wrote:
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've
hardly ever got anywhere near my connection limit.
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED
of open files.
I'm still scratching my head about those failed connections. I just
don't get it.
Thanks,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 3/1/07, Brian Dunning [EMAIL PROTECTED] wrote:
Is there such a thing as a PHP script that I can put on a cron job to
run every minute and make a test query, and upon failure, restart the
service and maybe send an email to Rackspace support? I don't know
how you'd check that the query was
Does anyone have any resources, guides, insight into the best practice
for storing date/time information when developing a custom web app?
I am mainly concerned with how the TZ should be stored? Should it go
in as UTC and the code accounts for the user TZ? How does one handle
tracking the
storage engine not a
good choice.
Can someone here give some insight and suggest other options I could
look into?
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving Made Easy
Get the gifts you want
On 2/26/07, Chris W [EMAIL PROTECTED] wrote:
Can someone here give some insight and suggest other options I could
look into?
you could replicate all the data between web/application servers, and
use the local store as a read-only database, and push all your
updates to a central update
On 2/22/07, Istvan Hubay Cebrian [EMAIL PROTECTED] wrote:
Hi everyone,
Say I have a DB named... well... database1, this db has the following
tables:
What I want to do is copy each of the tables (exactly as they are, including
primary keys, data, etc) but at the same time change the
I am trying to get a few instances of mysql running at boot time - and
I have come across the command mysqld_multi. Seems to have a lot of
documentation about kicking those off via command line - but not much
on setting it up to start at boot. anyone have any insight into this?
Either using
Sun, Jennifer wrote:
Any answers for the question below ?
Is there a DST patch for MySql 4.0.20? Thanks.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 9:30 AM
To: mysql@lists.mysql.com
Subject: MySQL Daylight Savings Time
Jay Paulson wrote:
I really donĀ¹t know what to do because I keep getting this error. Any
ideas?
SQL query:
ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region )
REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE
MySQL said: Documentation
#1005 - Can't create table
Jay Paulson wrote:
2) both tables have data in them.
This is most likely your issue then, depending on the table size, go
through and make sure that anything in the referenced column matches the
referencing column. You should also be able to use SHOW INNODB STATUS
to see what's possibly
Brian Mansell wrote:
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str
Jesse wrote:
Is there a way to export results of a query to a file? In other
words, if I do a select * from somefile, is there a phrase like
send output to somefile.txt, or something? I've searched the help
file, and I guess I don't know what I'm looking for, if it even
exists. I'm using
I'm wondering if there is a way to do a numeric sort when the number
exists in a string. More clearly, take for example:
Radius 1200
Radius 1500
Radius 1800
Radius 300
Radius 600
Radius 900
Being that character wise 1 is before 3, I'm wondering if there's a way
through the database to
101 - 200 of 2034 matches
Mail list logo