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: http://lists.mysql.
Hi,
I'm running this query:
mysql> SELECT email FROM promoters where id NOT IN (SELECT promoter_id
FROM credits WHERE success = 1 ) and active = 1;
Empty set (31.89 sec)
its returning an empty set and take over 30 seconds to return.
mysql> describe promoters;
+---+--
Dear all,
I have a query that takes a rather long time and was wondering if there is
anyway to optimize it.
Normally we removing duplicate records by phone number. This query takes about
a
second and
it really slows down the process when we are importing several 1000 records a
day.
Here is
Dear All,
I'm trying to get SSL connections
for all mysql slave and masters.
I have one box that will not use SSL for some reason.
When I start this slave it can not connect because
it's not using SSL.
show slave status\G
*** 1. row ***
Hey can anyone tell me is my slave is utilizing SSL?
I am unsure why the Master SSL Cipher is not
listed under show slave status.
Here's some info:
mysql> show slave status\G
*** 1. row ***
Slave_IO_State: Waiting for master to send eve
Dear All,
I just want to verify my rep slave is using ssl.
When I run this command mysql> \s
I get:
mysql> \s
--
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline
5.1
Connection id: 5
Current database:
Current user: r...@localhost
SS
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
--
MySQL Gen
d+\d+).*(\d+\d+\d+\d+)
Robert M. Bartis
EMAIL: [EMAIL PROTECTED]
-Original Message-
From: Paul Nowosielski [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2008 3:32 AM
To: mysql@lists.mysql.com
Subject: regular expressions matching only numeric characters in order
Dear All,
Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.
(333)333-
333-333-
33
So I am wa
Dear All,
I am interested in performing a sub query that removes duplicate records from
a temporary table prior to pushing the data to the main table.
I am not sure if it is possible and thought I would ask prior to the endeavor.
I currently use php to perform this operation but is really bogs
Dear All,
I'm trying to pull percentages from a query and really don't understand how to
initiate this.
Here is the low down:
I have a list of venues with the number of acts who performed catoragized by
genre.
For example:
venue_id: 23 blues: 117 rock: 34 world_music:57 ( and so on, there a
Its working fine for me:
mysql> SELECT DISTINCT email_address FROM mailing_list WHERE marketing_list
LIKE 'Y' AND last_name >= 'm' AND last_name <= 'z';
26371 rows in set (1.00 sec)
Thank You,
--
Paul Nowosielski
Webmaster
On Friday 21 July 2
I have the solution:
SELECT DISTINCT email_address FROM mailing_list WHERE last_name >= 'm' AND
last_name <= 'z'
Thank you,
--
Paul Nowosielski
Webmaster
On Friday 21 July 2006 11:03, Paul Nowosielski wrote:
> Dear All,
>
> I need to write a query t
Dear All,
I need to write a query that searches last names between the ranges of m
through z.
Is there a way to do this in the query?
Thank You,
--
Paul Nowosielski
Webmaster
office: 303.440.0666 ext 219
cel: 303.827.4257
--
MySQL General Mailing List
For list archives: http
tv.ID=tvc.VENUE_ID)
LEFT JOIN tbl_VENUE_AGE_XREF ON (tv.ID=tvax.VENUE_ID)
LEFT JOIN tbl_VENUE_AGES ON (tvax.VENUE_ID = tvage.PKEY)
WHERE
td_date > NOW()
AND
(td.td_id = artd.td_id AND artd.artist_id = art.PKEY AND td.venue_id=tv.ID)
45929 rows in set (3 min 11.75 sec)
Best Regards,
--
Paul Now
run the full query on a daily basis without killing the
DB engine.
The query needs to pull in about 50,000 results.
Does anyone see a way to optimize this query or rewrite it so it doesn't cause
a huge system load?
Thank you,
--
Paul Nowosielski
Webmaster
--
MySQL General Mailing
VENUE_ID = tv.ID and tv.id =tvtx.VENUE_ID AND tvtx.TYPE_ID = vtp.PKEY
and vax.VENUE_ID =tv.ID AND vax.AGE_ID = vage.PKEY AND
UNIX_TIMESTAMP(t.td_date) >$time GROUP BY t.td_id
Thanks for the help!
--
Paul Nowosielski
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
ql_current/share/mysql/charsets/?.conf' not found
(Errcode: 2))
Any ideas?
Thank you,
--
Paul Nowosielski
Webmaster
office: 303.440.0666 ext 219
cel: 303.827.4257
On Thursday 25 May 2006 13:24, gerald_clark wrote:
> Paul Nowosielski wrote:
> >On Thursday 25 May 2006 1
On Thursday 25 May 2006 12:09, you wrote:
> Paul Nowosielski wrote:
> >Dear all,
> >
> >I've been testing our backup and recovery strategies here at work.
> >When dumping all the databases I'm using this command:
> >
> >mysqldump --all-datab
ind file:
'./mysql/time_zone_transition_type.frm' (errno: 13) (1017)
When I recover the databases using this command:
mysql --force -u root -p -h localhost < all.sql
Tables are missing (and not the ones the dump is complaining about) and
relations are broken.
I'm assu
cle.
In encore,articles is the data 43,44,45,46.
These are article IDs. If I manually place 43,44,45,46 into the query
like so:
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (43,44,45,46)
All 4 articles are returned. Any ideas why this is not
22 matches
Mail list logo
