> From: Jan Steinman
>To: mysql@lists.mysql.com
>Sent: Thursday, 4 September 2014, 16:40
>Subject: RE: converting numeric to date-time?
>
>
>> From: "Ed Mierzwa (emierzwa)"
>>
>>
>> FROM_UNIXTIME(1409304102.153)/*your epoch column here*/
>
>I don't think the OP has a Unix timestamp.
Re
> From: Christophe
> To: mysql@lists.mysql.com
> Cc:
> Sent: Tuesday, 18 March 2014, 19:10
> Subject: Precedence in WHERE clauses.
>
> Hi list,
>
> I'd like to get your advice about precedence in where clauses in MySQL
> (5.0.51, and 5.1.66 in this case / from lenny and squeeze Debian
> packa
I've no idea of the status of dtrace on linux, as I've never tried, but failing
that you could run it through gdb to get some insight into the issue.
--- On Thu, 23/12/10, Johan De Meersman wrote:
> From: Johan De Meersman
> Subject: Re: Error while running Mysql
> To: "Adarsh Sharma"
> Cc: m
--- On Mon, 25/10/10, Daevid Vincent wrote:
> From: Daevid Vincent
> Subject: RE: Is SSD suitable for mysql server?
> To: "'mysql'"
> Date: Monday, 25 October, 2010, 21:52
> > I guess it depends on how
> important your data is too. Quite
> > a few of the SSDs on the market have been proven to
--- On Mon, 25/10/10, Johan De Meersman wrote:
> From: Johan De Meersman
> Subject: Re: Is SSD suitable for mysql server?
> To: "wroxdb"
> Cc: "mysql"
> Date: Monday, 25 October, 2010, 10:03
> On Mon, Oct 25, 2010 at 7:56 AM,
> wroxdb
> wrote:
>
> > Hello,
> >
> > We are a company for gaming
--- On Wed, 14/4/10, Dan Nelson wrote:
> Hammerman said:
> > My organization has a dedicated MySQL server. The
> system has 32Gb of
> > memory, and is running CentOS 5.3. The default
> engine will be InnoDB.
> > Does anyone know how much space should be dedicated to
> swap?
>
> I say zero swap
--- On Mon, 29/3/10, Brown, Charles wrote:
> Hello All. when I issued this
> command: ps -e | grep, I noticed that mysqld_safe was
> up running in my system.
> My question is: what is mysqld_safe and why was it
> running. Please help.
>
>
> [sp...@naxbmisq03 ~]$ ps -e | grep -i mysql
> 11989
--- On Wed, 10/3/10, John G. Heim wrote:
> Hi,
>
> I am working on configuring a new hardware database server.
> I'm a little confused as to what to do about disk. We have
> several mysql databases but by far the 2 most active are
> spamassassin bayesian rules and horde3/imp web mail. Both do
>
--- On Mon, 15/2/10, Prathima Rao wrote:
> From: Prathima Rao
> Subject: Re: version 5 to 4
> To: mysql@lists.mysql.com
> Date: Monday, 15 February, 2010, 7:09
> hi mysql tem,
>
> i have a version 5 on which i have developed a database
> now one of the systmem has 4
> i tried to migrate fro
> From: Glyn Astill
>
> Doesn't look crazy to me, and it works in 5.0.32
>
> http://www.privatepaste.com/50RvhihKKm
>
> Perhaps time to patch that server ...
>
I've guessed at the table def there, obviously your def may be different and
that would surely af
> From: Matt Neimeyer
>
> Generic code to draw a SELECT element on the screen
> sometimes it ends
> up like such...
>
> SELECT DISTINCT name AS myvalue,name AS mydisp FROM names
> WHERE
> name!="" ORDER BY myvalue
>
> On 4.1.22 this returns
>
> A A
> B B
> C C
> D D
>
> On 5.0.22 this returns
You could use some regex to do it...
In fact, a google brings up this
(http://forums.mysql.com/read.php?60,1907,241284#msg-241284)
CREATE FUNCTION ISNUMERIC(myVal VARCHAR(1024))
RETURNS TINYINT(1) DETERMINISTIC
RETURN myVal REGEXP '^(-|\\+)?([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$';
G
- Original Message
> From: Laurence Meyer
> To: mysql@lists.mysql.com
> Sent: Sunday, 16 August, 2009 7:09:25
> Subject: show tables is slow/uncached
>
> We have a production database that has 4,000+ tables. For a variety of
> reasons,
> our CGIs always
> have to run "show tables"
--- On Fri, 24/4/09, David Sparks wrote:
> Mysql is getting better at a pace that is making the other
> open source DB
> servers irrelevant.
>
lol. Is that a typo? Surely you wanted to say "Mysql's bug fix list is
gathering pace..."
--
MySQL General Mailing List
For list archives: http:/
--- On Fri, 24/4/09, David Sparks wrote:
> From: David Sparks
> Subject: Re: Oracle , what else ?
> To: "j...@commandprompt.com"
> Cc: "mysql@lists.mysql.com"
> Date: Friday, 24 April, 2009, 6:42 PM
> Joshua D. Drake wrote:
> > I would expect that MySQL in two years likely
> won't exist excep
--- On Wed, 22/4/09, Joshua D. Drake wrote:
> From: Joshua D. Drake
> Subject: Re: Oracle , what else ?
> To: "Martijn Tonies"
> Cc: mysql@lists.mysql.com
> Date: Wednesday, 22 April, 2009, 10:45 PM
> On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote:
> > Hey Gilles,
> >
> >
> > >After
I can't help you directly, however I find the silence deafening, you'd expect a
little more participation from the mysql devs - it's not exactly a high volume
list.
I recall getting a sigbus from postgres on netbsd a few months back and that
turned out to be a bad build due to the combination
Where does the pid file usually live? Does it exist?
I guess you need to do some digging, but as a punt you could always try firing
off the stop part of the init script and then try to start it again
/etc/init.d/mysql top
/etc/init.d/mysql start
Assuming you're running some linux flavour, othe
--- On Fri, 12/12/08, Craig Dunn wrote:
> I'm currently spec'ing out a design plan for a large
> scale MySQL infrastructure to support a high-read large
> scale web environment for a client. I've got the
> overall MySQL set up planned out (which I'll post here
> later to get peoples inputs/advic
Sometimes people need a good kick up the arse, and take Widenius's post as just
that; a good thing. Rather that than loads of bugs, denial and silence, that we
always see from the closed source databases.
--- On Tue, 9/12/08, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> From: Daevid Vincent <[E
> Part of the problem is that I can't stop the server.
Oh, so it does start? I thought it also wasn't starting, if it's not starting
then stopping it will fail.
> Is there anything else I can do to get a clean install of
> MySQL running
> again?
>
Can you list what appears in the process lis
> The mysqld.pid file is in /var/run/mysqld.
>
> The mysql.sock file is in /tmp
>
> > What symlink did you make?
> None right now. I removed any that I had made before so
> that I wouldn't
> confuse the situation.
>
To start with, check that the .pid file doesn't exist if the server is stoppe
--- On Wed, 17/9/08, Dave M G <[EMAIL PROTECTED]> wrote:
> From: Dave M G <[EMAIL PROTECTED]>
> Subject: Re: MySQL not running on fresh LAMP install
> To: mysql@lists.mysql.com
> Date: Wednesday, 17 September, 2008, 12:51 PM
> TLUG,
>
> Thanks for the helpful advice.
>
> Unfortunately I've hi
Does mysql have any form of public cvs or svn repository?
__
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at
Yahoo! http://uk.docs.yahoo.com/ymail/new.html
--
MySQL G
Sutput the table definitions and cut and paste the new columns into a ALTER
TABLE table_name ADD column_name column-definition statement.
--- On Wed, 6/8/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> From: Jerry Schwartz <[EMAIL PROTECTED]>
> Subject: Transplanting table structure changes
> T
I think you're after the SUBSTRING_INDEX(str,delim,count) function, so (I've
not tried this):
select substring_index(ip,'.',3) from ipslimit 10;
--- On Wed, 23/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Subject: Re: a question...
> To: "D
make sure to FLUSH PRIVILAGES;
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Sent: Monday, 14 July, 2008 10:59:35 AM
> Subject: RE: Problem - "Host 'abc.def.com' is not allowed to connect to th
int(10) will pad with zeros on return, i.e. if value = 59
int(10) 59
int59
- Original Message
> From: Krishna Chandra Prajapati <[EMAIL PROTECTED]>
> To: MYSQL General List
> Sent: Thursday, 22 May, 2008 9:34:55 AM
> Subject: integer
>
> Hi,
>
> I would to know
another option is to do a mysqldump and pipe it over to the new server, e.g:
mysqldump --opt 32bitserver | mysql --host=64bithost -C 64bitserver
> - Original Message
> > From: Mike
> > To: B. Keith Murphy
> > Cc: mysql list
> > Sent: Friday, 25 April, 2008 5:33:49 PM
> > Subject
roductions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mys
ith normal prompt i.e.
c:\mysql\bin>
but any mysql command entered, i.e. mysql test is responded with:
ERROR 2003:Cant connect to MySQL server on localhost (10061)
Ive obviously missed something basic, please help
Thanks in advance
Glyn
---
Outgoing mail is certified Virus Free.
Checked
nd up with either NULL in all the fields except the primary key
field or if I use ENCLOSED BY '', I end up with the data enclosed by
quotes.
How do I do this
"properly", please?
TIA
Glyn
<><><><><><><><>Gl
32 matches
Mail list logo
