Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
On Thu, May 7, 2015 at 4:11 PM, shawn l.green
wrote:
> Hi Paul,
>
> On 5/7/2015 10:17 AM, Paul Halliday wrote:
>
>> Fighting a bit with this one...
>>
&
apart.
What is happening behind the scenes?
Thanks!
--
Paul Halliday
http://www.pintumbler.org/
;
> this should come close:
>
> 10[.]\d{1,3}[.](224|225|226|227|228|229|23\d))[.]\d{1.3}
>
> On Thu, Mar 19, 2015 at 9:39 AM, Paul Halliday
> wrote:
>
>> I am trying to pick out a range of IP addresses using REGEXP but
>> failing miserably :)
>>
>> The p
I am trying to pick out a range of IP addresses using REGEXP but
failing miserably :)
The pattern I want to match is:
10.%.224-239.%.%
The regex I have looks like this:
AND INET_NTOA(src_ip) REGEXP '\d{1,3}\\.\d{1,3}\.(22[4-9]|23[0-9])\\.\d{1,3}'
but, go fish. Thoughts?
Thanks!
27;read'
returned OS error 105.
2013-11-21 08:47:26 802808c00 InnoDB: Cannot continue operation.
I followed that link but it doesn't tell me anything outside of what
is above. Can I fix this?
Thanks.
--
Paul Halliday
http://www.pintumbler.org/
--
MySQL General Mailing List
For list ar
at 9:46 AM, Manuel Arostegui wrote:
> 2013/11/21 Reindl Harald
>
>>
>> Am 21.11.2013 13:51, schrieb Paul Halliday:
>> > Had a system crash this morning and I can't seem to get mysql back up
>> > and running. This is the error:
>> >
>> >
I am so, so glad that someone finally said what I think each time I see a
message from you Mr. James.
Original message
From: Rick James
Date: 06-12-2013 8:45 PM (GMT-04:00)
To: Daevid Vincent ,mysql@lists.mysql.com
Subject: RE: How do I select all rows of table that have
Hi,
I'm running mysql 5.6.10 on Fedora.
when I try and boot mysql I get this:
# /etc/init.d/mysql start
Starting MySQL.The server quit without updating PID file
(/[FAILED]xt/mysql/veritian.pid).
Any ideas?
Thank you,
Paul
--
MySQL General Mailing List
For list archives:
d | varchar(16) | YES | | NULL
||
++-+--+-+---++
17 rows in set (0.00 sec)
Any ideas as to why the wuery is taking so long??
With kind regards,
Paul
--
MySQL General Mailing
U can remove the type field it will work
On Nov 22, 2012 8:21 PM, "Neil Tompkins"
wrote:
> Basically I only what to return the IDs that have both types.
>
>
> On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski >wrote:
>
> > SELECT DISTINCT id FROM table WHERE type IN ('2','5')
> >
> > should work
>
ED' OR VAL='GREEN'
> and more
>
> So which one is good in terms of optimization. I guess, 1 and 3 are
> similar in term of formation.
>
>
> --Anupam
>
--
Thanks & Regards,
P.Benaya Paul
http://www.codeasearch.com
http://www.iwannasearch.com
er by the_ids DESC LIMIT 1
>
> Is there a way to pull this off without going thru this step?
Would substring work?
SELECT SUBSTRING(recid, 13, ) AS numbers FROM table ORDER
BY numbers DESC
--
Paul Halliday
http://www.pintumbler.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
If you own the code, you can license it under multiple licenses.
Kind of like if you own a TV Show, you can license it in the US under one
contract, and in other geographies under other more or less restrictive
contracts.
This is a painful reality to those of us in Canada, as we can't watch South
On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson wrote:
> In the last episode (Mar 27), Paul Halliday said:
>> Say I have:
>>
>> SELECT COUNT(name), name, COUNT(DISTINCT(status)) FROM table GROUP BY name
>>
>> and it returns:
>>
>> 20 paul 5
>> 19
-- prepare statement, execute it, discard it
prepare s from @s;
execute s;
deallocate prepare s;
Note: I added a '.' before 'txt' and a closing quote to the file name.
http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-prepared-statements.html
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
able A
>
> are there any differences in performance when selecting, inserting, updating,
> and deleting data.
Sure. For example, with table A, you can select only those blob columns you're
interested in. With B, you have to select all of them if you want *any* of them.
--
P
Is it possible to wrap a DELETE statement in an ON DUPLICATE KEY UPDATE?
Something like: ON DUPLICATE KEY UPDATE host="b1" (DELETE FROM
another_table WHERE host="b1") ?
Thanks.
--
Paul Halliday
http://www.squertproject.org/
--
MySQL General Mailing List
For
rtcent19.summitnjhome.com |
> | repl | virtcent23.summitnjhome.com |
> | repl | virtcent30.summitnjhome.com |
> +--+-+
>
>
> I know I can delete them individually and this is what I am going to do. But
> I would like to use this as a learning
rhsoft:~]$ telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> N
> 5.5.19-logs+%b?QYO]g��ke8'Xg~e\}!(mysql_native_password
>
>
>
>
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin
OAD DATA. You can use STR_TO_DATE() to reformat the values
on the fly.
LOAD DATA LOCAL INFILE 'data.txt'
INTO TABLE t (name,@date,value)
SET date = STR_TO_DATE(@date,'%m/%d/%y');
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, US
10 years, independent of the storage engine
>>>
>>>> much less a not particularly commonly used feature.
>>>
>>> mmap is not rocket science, so i do not understnd why this
>>> is not properly debugged and DEFAULT on
>
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
how to optimize mysql in easy way step, i know indexing, mapping other than
that is any way.
--
Thanks & Regards,
P.Benaya Paul
http://www.codeasearch.com
http://www.iwannasearch.com
On Tue, Oct 11, 2011 at 10:37 AM, Peter Brawley
wrote:
> On 10/11/2011 8:11 AM, Paul Halliday wrote:
>>
>> I have the following query:
>>
>> SELECT COUNT(signature) AS count, MAX(timestamp) AS maxTime,
>> INET_NTOA(src_ip), map1.cc as src_cc, INET_NTOA(dst_ip)
' depending on user input so
I check both table fields against their input.
On my system (fbsd 5.1.48) 'US' is not shown, on another system (linux
5.1.54), 'US' appears in the results.
Is there a better way to write this?
Thanks.
--
Paul Halliday
http://www.squertprojec
e
using the following commands:
shell> mv host_name.err host_name.err-old
shell> mysqladmin flush-logs
shell> mv host_name.err-old backup-directory
(Bug #29751)
See also Bug #56821.
"
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
| 4 03:00 |
| 6 | 4 03:01 |
| 1 | 4 03:02 |
| 2 | 4 03:03 |
+---+-+
Why is this?
Thanks.
--
Paul Halliday
http://www.squertproject.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the redo log on a raid disk, I
assume that would allow the system to continue running in these
scenarios. I would prefer a solution that does not add this cost to the
system.
Thanks for your help
Paul
PLE leads ALL
idx_del_user,phone_home,phone_mobile,phone_work,phone_other,phone_fax,date_entered
NULL NULL NULL 636433 Using where
Any thoughts?
Thank you,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ist1|list2|list9|list20
and then just breaking it out in the code. The entire table would of
course need to be scanned each day to check whether or not an address
had been taken off a list. (efficiency?)
Any comments/suggestions would be greatly appreciated.
Thanks.
--
Paul Halliday
http://www.pint
ourse, but I am just curious if I
can pull it off with a single query.
Thanks!
--
Paul Halliday
http://www.pintumbler.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Fri, Dec 3, 2010 at 12:50 PM, Mark Goodge wrote:
> Given a table containing a range of INT values, is there any easy way to
> select from it the lowest non-zero number?
>
SELECT number FROM table WHERE number > 0 ORDER BY number ASC LIMIT 1;
?
--
Paul Halliday
Ideation | Indiv
ng players_bids.users_id_from
> within the UNION I get back the following error :
>
> Error Code: 1054
> Unknown column 'players_bids.users_id_from' in 'where clause'
>
> Any ideas how to overcome this problem ?
>
> Cheers
> Neil
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
l
port = 3306
socket = /var/lib/mysql/mysql.sock
ssl-ca=/etc/mysql/ssl/ca-cert.pem
ssl-key=/etc/mysql/ssl/client-key.pem
ssl-cert=/etc/mysql/ssl/client-cert.pem
ssl-cipher=DHE-RSA-AES256-SHA
Anyone see any issues with this?
Thank you,
Paul
--
MySQL General Mailing List
For list a
-+
| Variable_name | Value |
+---++
| Ssl_cipher| DHE-RSA-AES256-SHA |
+---++
1 row in set (0.00 sec)
Thank you,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql
> Presumably those records were absorbed into your 'group by' clause, since
> there was an entry, from a later time, which had the same values for all the
> group by fields.
>
>
> --
> Simcha Younger
>
Geez, how obvious. I was thinking on a completely different plane. I
feel pretty silly now. :
2010-11-03 13:18:37
Where did 13:41:46, 13:19:20 and 13:22:39 go?
Thanks!
--
Paul Halliday
Ideation | Individualization | Learner | Achiever | Analytical
http://www.pintumbler.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ysql/ssl/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /etc/mysql/ssl/client-key.pem
Seconds_Behind_Master: 0
1 row in set (0.00 sec)
Can any tell me if SSL is functioning or not please?
Thank you,
Paul
--
MySQL General Mailing List
For list archives: http://
@ucl.ac.uk /"\
> Media Services\ /
> University College London X ASCII Ribbon Campaign
> Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
> London, W1T 4JF
> +44 (0)20 7679 9259 (direct), 09259 (internal)
--
Paul Du
nd m2.ip).
>
>
>
> -Travis
>
>
>
> From: Paul Halliday [mailto:paul.halli...@gmail.com]
> Sent: Tuesday, October 12, 2010 11:37 AM
> To: Travis Ard
> Cc: mysql@lists.mysql.com
> Subject: Re: Can this query be done w/o adding another column?
>
>
>
> On
On Tue, Oct 12, 2010 at 1:59 PM, Travis Ard wrote:
> You could join your mappings table twice, once on src_ip and again on
> dst_ip:
>
> SELECT COUNT(signature) AS count,
>MAX(timestamp) AS maxTime,
> INET_NTOA(src_ip),
>m.cc as src_cc,
> INET_NTOA(dst_ip),
> m2.
mappings table to have src_ip and dst_ip just duplicating the
ip column but I have a nagging feeling that that probably isn't necessary.
Thanks.
--
Paul Halliday
Ideation | Individualization | Learner | Achiever | Analytical
http://www.pintumbler.org
On Tue, Oct 12, 2010 at 11:14 AM, Johnny Withers wrote:
> I would try:
>
> SELECT DISTINCT(e.src_ip)
> FROM event AS e
> LEFT JOIN mappings AS m ON e.src_ip=m.src_ip
> WHERE e.timestamp BETWEEN '2010-10-11 00:00:00' AND '2010-10-12 00:00:00'
> AND INET_NTOA(e.src_ip) NOT LIKE '10.%.%.%'
> AND INE
2.16.%.%' AND INET_NTOA(src_ip)
NOT LIKE '192.168.%.%';
but, within that somewhere also check to see if src_ip exists in mappings.
If it does, do not return it.
Is this possible?
Thanks.
--
Paul Halliday
Ideation | Individualization | Learner | Achiever | Analytical
http://www.pintumbler.org
On Sep 29, 2010, at 5:15 PM, Paul Halliday wrote:
> I just converted (reinstalled) a FreeBSD system from i386 to amd64. Of
> course; I missed the memo. I have been struggling to get everything back
> online. I just finished exporting a few Gigs of RRD's to XML so that I co
mysql to a
partition (i386) and reinstalled. Can I just copy this back or does some
magic need to happen first?
Thanks!
--
Paul Halliday
Ideation | Individualization | Learner | Achiever | Analytical
http://www.pintumbler.org
3, these functions return binary strings. The same change was made for
SHA2() in MySQL 5.5.6.
"
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
he same session
(within the same connection), they should execute in the same order you issue
them. Particularly since you are waiting for the result of the first before you
proceed to the second.
I suggest that when you observe an out of order entry in your journal, you
compare it with the M
this time using mysqldump --complete-insert
so that the INSERT statements include the column names.
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
announcement), so
that you can filter it out if you don't want to see it.
Best regards,
Paul
On Jul 16, 2010, at 4:41 PM, Johan De Meersman wrote:
Can I somehow unsubscribe (that is opt-out , as opposed to the more
civilised opt-in) from the myriad of commercial announcements on
this
reported here: https://bugs.launchpad.net/pbxt.
If you have any questions or comments, please let me know.
Best regards,
Paul
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
--
MySQL General Mailing List
For list archives: http
ted to a slave.
"
--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ding. This promise makes UTF-8 code easier to write and easier
> to future-proof without bad performance penalties.
Supplemental Unicode characters (4-byte) are supported as of MySQL 5.5.3:
http://dev.mysql.com/doc/refman/5.5/en/charset-unicode.html
http://dev.mysql.com/doc/refman/5.5/en/ch
lush-logs --master-data=2 >
> /bk01/all_databases_`date +%a`.sql 2> /tmp/test.log
>
> i follow the above syntax for logging the errors in my script.
>
> Thanks
> Anand
>
> On Fri, May 28, 2010 at 5:44 PM, Angelina Paul wrote:
>
>> Could you please inform me how
Could you please inform me how to test the mysql databases backup failure by
using the mysqldump utility. I written a unix script for sending status
notification against ten mysql databases. I need to test the nine databases
backups have completed successfully and one failed due some reason.
Than
org/wiki/Main_Page) to provide
the service level you require.
Best regards,
Paul
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Please help me to understand more about the mysql transaction log (
mysqlbinlog) file and its contents. Will it support only the innodb or all
the storage engine types like MyISAM, InnoDB?
Thanks,
Arsh Paul
How can I remove old mysql-bin log file in log directory? A mysql full
backup will clear the old mysql bin log file or not?
Thanks,
Arshu Paul
have to take if I encounter a page corruption in innodb tables. why
I am getting a message "*Error*: *No query specified*" when I run a show
engines\g commands -version (5.0.45)
Thanks,
Arsh Paul
M
> To: mysql@lists.mysql.com
> Subject: declare multiple 'Definer'
>
> Good morning!
>
> I have been struggleing with creating a store procedure, that will allow 2
> users
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
ww
--+
1 row in set (0.06 sec)
>
> Can you suggest me how set this value to higher one. By default it is 1 MB.
>
> Thank you
>
> VIKRAM A
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list arc
Just like to mention that http://www.blobstreaming.org was created to
solve this problem in MySQL.
The Launchpad project is here: https://launchpad.net/pbxt
On Feb 16, 2010, at 3:23 PM, Johan De Meersman wrote:
On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies
wrote:
databases are made
'll see an entry for the world database. Direct links are:
http://downloads.mysql.com/docs/world.sql.gz
http://downloads.mysql.com/docs/world.sql.zip
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
Fo
2010-01-30'
> ORDER BY order_date;
No "=" after BETWEEN.
>
> or
>
> SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30'
> ORDER BY order_date;
Need "order_date <=", not just "<=".
>
Shawn Green wrote:
> 23. There are fewer and less sophisticated tools for administration.
>
> MySQL doesn't need them. That alone should tell you something about
> our reliability.
>
This speaks to simplicity-- both in terms of easy to use and in terms of
more limited features. It says nothing
p://lists.mysql.com/mysql?unsub=...@thefsb.org
>>
>>
>>
>>
>
>
>
> --
> Yang Zhang
> http://www.mit.edu/~y_z/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=paul.dub...@sun.com
>
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello,
Would appreciate if any you post the steps to upgrade MySQL 5.0 to
higher versions (5.1, 5.4)on Solaris 10 ,X_64 box.
Thanks & Regards,
S Paul
sults with multi-byte character
sets. In addition, these operators compare characters by their byte values and
accented characters may not compare as equal even if a given collation treats
them as equal.
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
d
>>>>> slave dump file under 5.1 server.
>>>>> 7. After loading is complete, test then start binary logging on master
>>>>> while still preventing updates to updates.
>>>>> 8. After loading slave, test then start slave (get configs in plac
STER. See:
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-17.html
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.m
://bugs.launchpad.net/pbxt.
You can ask questions on Launchpad at https://answers.launchpad.net/
pbxt, or post to the PBXT mailing list: https://launchpad.net/~pbxt-
discuss.
I wish all a HAPPY NEW YEAR!! :)
Best regards,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Wed, Dec 9, 2009 at 2:24 PM, Joerg Bruehe wrote:
> Hi everybody!
>
>
> Neil Aggarwal wrote:
>> Paul:
>>
>>> SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip),
>>> mappings.cc FROM event, mappings WHERE event.timestamp BETWEEN
>>&g
I have 2 tables:
1) Event Data
2) Mappings
The query should return something like this:
Hits IP Country Code
20213.136.52.29 SE
I am trying this:
SELECT COUNT(event.src_ip) AS count, INET_NTOA(event.src_ip),
mappings.cc FROM event, mappings WHERE event.tim
that are located in two different databases. Would a single START
TRANSACTION be sufficient ?
Any help would be appreciated.
TIA
Mos
--
- michael dykman
- mdyk...@gmail.com
"May you live every day of your life."
Jonathan Swift
--
Paul DuBois
S
-discuss.
I look forward to hearing from you! :)
Best regards,
Paul
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
p://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
You need to set the field format to a non binary one, and case
insensitive will be the default.
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: htt
ly find the new instance.
If you have InnoDB tables, there will be a problem. InnoDB maintains
the database name in the shared tablespace, and it will no longer be
able to find those tables.
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
I have a database that I am (will) be using to track URL's. The table
structure looks like this:
CREATE TABLE event
(
eid INT UNSIGNED NOT NULL AUTO_INCREMENT,
timestamp INT(10) UNSIGNED NOT NULL DEFAULT 0,
ipINT(10) UNSIGNED NOT NULL DEFAULT 0,
fqdn VARC
, MVCC-based, transactional storage engine
for MySQL. The project is open source (GPL) and hosted on Launchpad.
PBXT supports referential integrity, row-level locking and is fully
ACID compliant.
For more information please go to the PBXT home at: http://
primebase.org.
Best regards,
Paul
/tmp? Can/should I make the server use a different
location
instead of /tmp?
Thanks,
Mike Spreitzer
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
a large table.
Once mysqlupgrade runs without a hitch, you should be back in business.
-Paul
Webmaster Studio Informatica wrote:
Hi,
I need to upgrade Mysql 4 to Mysql 5 on Linux.
I will uninstall version 4 and install version 5.
With uninstallation usually database files rem
deadlocking problems with them before.
All "good" reasons not to serialize all transactions, and therefore a
good reason to use the method that continues to support deadlock
detection.
Best regards,
Paul
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.bl
p://www.percona.com/services.html
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://list
ual.
Whew! I was about to panic. :-)
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ar
to get the latest ERROR NUMBER and latest ERROR MESSAGE,
SHOW WARNINGS might help.
http://dev.mysql.com/doc/refman/5.1/en/show-warnings.html
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: ht
.1/en/server-options.html#option_mysqld_pid-file
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
eas a source tarball is created from the result of these tools.
The manual should cover that, but I don't have a specific URL handy.
It's http://dev.mysql.com/doc/refman/5.1/en/installing-source-tree.html
The development tree contains a file "BUILD/autorun.sh" which runs
th
a
speed advantage of switching the dates to integer?
Dates are stored numerically. See:
http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html
Beginning with "The storage requirements shown in the table arise from
the way that MySQL represents temporal values ..."
/local/bin/pico
export EDITOR
I get no error messages when mysql starts up, but the value of the
EDITOR variable does not change.
Is there any way I can achieve that from the cnf file?
No. MySQL option files are for setting MySQL program options, not
environment variables.
--
Paul DuBois
should work the same
way with LVM.
-Paul Choi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Recent books that I've looked at have 2 ISBN's - one the older 10 digit, and
also the newer 13 digit version. Both printed on the same book (both on the
back cover at the bottom and inside).
Of course, a hard cover will have a different ISBN again.
Hooker
--
" If ignorance is bliss, politicians
tried out
the engine yet, please do!
Best regards,
Paul
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
And you may also try:
Ronald Bradford: http://42sql.com
Another frequent conference speaker that really knows his stuff!
Ask him about mentoring program...
On Dec 12, 2008, at 8:21 PM, Ewen Fortune wrote:
As an alternative you also have
www.percona.com
www.pythian.com
www.openquery.com.au
ww
This seems to do it:
SELECT phone_work FROM leads WHERE phone_work REGEXP '[(]{1}([0-9]){3}[)]{1}[
]?([^0-1]){1}([0-9]){2}[ ]?[-]?[ ]?([0-9]){4}'
- Original Message ----
From: Paul Nowosielski <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, December 3,
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?'
I've been trying to lick this for hours now with
no avail.
Thank you,
Paul
Hi,
Seems to work! But the number is a zero you have to add an extra escape:
(\\0+\3+\\0+\9+)
or you get ERROR 1139 (42000): Got error 'parentheses not balanced' from regexp
Thank you!!
Paul
- Original Message
From: "Bartis, Robert M (Bob)" <[EMA
merics stripped and
will
be in the format of nn.
Any help would be appreciated.
Thank you,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ere: https://code.launchpad.net/
~drizzle-pbxt/drizzle/pbxt.
Please e-mail me if you have any questions or if you need help with
PBXT. Bugs reports can be submitted on Launchpad: https://bugs.launchpad.net/pbxt
.
Best regards,
Paul
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstr
Anybody know if there's a way to change a primary key field
that is not auto-incremented, turning on auto-increment but
preserving the values that are currently in it?
TIA,
Paul W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The book MySQL, Fourth Edition (aka "Doorstop IV") has been published.
More information is available at the book's Web site:
http://www.kitebird.com/mysql-book/
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General M
This
functionality is provided by the "BLOB Streaming" engine from: www.blobstreaming.org
.
Best regards,
Paul
On Sep 2, 2008, at 9:12 PM, mos wrote:
Paul McCullagh,
What's the advantage of using PBXT over InnoDb or the new Falcon
transactional engine? TIA
Mike
Hi A
1 - 100 of 3565 matches
Mail list logo
