Oh this isn't good. Because the database in on a shared server and I don't
think I've got console access ?
On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote:
I have had this problem with PHPMyAdmin many times, and the only way I
know around it, is to go in and do your
Based on my reply below, do you recommend I continue to have these indexes ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Oct 13, 2010 at 8:22 PM
Subject: Re: Primary key not unique on InnoDB table
To: Travis Ard travis_...@hotmail.com
Cc:
I managed to use the older version of MySQL Administrator 1.2.15 and it
appears to back up find using InnoDB online backup.
On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote:
I have had this problem with PHPMyAdmin many times, and the only way I
know around it, is to go
Hello List,
how do i install mysql COMPLETLY in a diffrent directory?
Right now i am using:
./configure --prefix=/usr/local/mysql-5.1.42
--sysconfdir=/usr/local/mysql-5.1.42/etc
BUT, mysql still looks for /etc/my.cnf and for
/var/log/mysql/mysql-bin.index ...
So what configure options do i
hi,
do you want to compile or you can use binaries?
Claudio
2010/10/15 ml ml mliebher...@googlemail.com
Hello List,
how do i install mysql COMPLETLY in a diffrent directory?
Right now i am using:
./configure --prefix=/usr/local/mysql-5.1.42
--sysconfdir=/usr/local/mysql-5.1.42/etc
BUT,
Hi Claudio,
i would like to compile it from source.
Mario
On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni claudio.na...@gmail.com wrote:
hi,
do you want to compile or you can use binaries?
Claudio
2010/10/15 ml ml mliebher...@googlemail.com
Hello List,
how do i install mysql COMPLETLY
Hi Mario,
While installing a new instance you don't exactly need to mention
anything except for the --prefix option. While starting the new instance
you can provide all config parameters like config file, datadir etc.
On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
Hello List,
how do i
Hi Mario,
MySQL search my.cnf in this order(if I remember well):
1. /etc/my.cnf
2. /basedir/my.cnf
3. /datadir/my.cnf
4. $userhome/my.cnf
you have to make sure that you REMOVE ate least /etc/my.cnf from the system
try and let me know
Claudio
2010/10/15 ml ml
Hello,
i installed mysql with:
./configure --prefix=/usr/local/myprefix/mysql/ make make install
(at the point mysql is not running yet)
Next i would like to initialize the DB but get the follwoing error:
--
You can pass the following variables as well
--defaults-extra-file=path-to-my.cnf
--socket=path-to-socket-file
--port=port-no
On Fri, 2010-10-15 at 18:50 +0530, ml ml wrote:
Hello,
i installed mysql with:
./configure --prefix=/usr/local/myprefix/mysql/ make make install
(at the point
I think this is one of those times you would update the mysql.user table
directly, then flush privileges.
JW
On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent dae...@daevid.com wrote:
I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for
the very specific
Hey Daevid,
As this time zone table won't change once it is set up. Do a copy of the
table data into another database and give grants to it.
On Fri, Oct 15, 2010 at 7:57 PM, Johnny Withers joh...@pixelated.netwrote:
I think this is one of those times you would update the mysql.user table
did you remove /etc/my.cnf?
2010/10/15 ml ml mliebher...@googlemail.com
Hello,
i installed mysql with:
./configure --prefix=/usr/local/myprefix/mysql/ make make install
(at the point mysql is not running yet)
Next i would like to initialize the DB but get the follwoing error:
you can use mysqld_multi
On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni claudio.na...@gmail.comwrote:
did you remove /etc/my.cnf?
2010/10/15 ml ml mliebher...@googlemail.com
Hello,
i installed mysql with:
./configure --prefix=/usr/local/myprefix/mysql/ make make install
(at the
We have a PSE05 Master and PSE06 Slave (PRODUCTION servers) both
are
Ubuntu 32-bit.
We have a third slave PSE07 which is Ubuntu 64-bit. This is our 'live
backup' so to speak. We take mysqld down daily on there and tarball the
/var/lib/mysql and /var/log/mysql as snapshots (since mysqldump
Hi
On 16/10/2010, at 1:47 AM, Suresh Kuna wrote:
Hey Daevid,
As this time zone table won't change once it is set up. Do a copy
of the
table data into another database and give grants to it.
Copy the data is not a good solution. First of all, time zone data
does change. Secondly if you
-Original Message-
From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
Sent: Friday, October 15, 2010 2:33 PM
To: MY SQL Mailing list
Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
for ANYONE?!
Hi
On 16/10/2010, at 1:47 AM, Suresh Kuna wrote:
Hey
You obviously know best how your application will query your database, and
you may have already thought through your indexing strategy. If so, please
disregard my comments.
In my experience, it is not often you need separate indexes on most or all
the columns in a table (excepting very narrow
Hi,
On 16/10/2010, at 8:50 AM, Daevid Vincent wrote:
Thanks for the reply Jesper, but either there isn't a solution in your
response, or I'm missing it?
What I mean is that you have to explicitly give the grant to each
user that should be allowed to query the table. You can't run one
-Original Message-
From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
Sent: Friday, October 15, 2010 5:54 PM
To: MY SQL Mailing list
Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
for ANYONE?!
Any user can get into mysql, it's what they can do after that's
20 matches
Mail list logo
