We're talking about a Windows machine, right? I don't have any of
those these days but it sounds to me like it didn't thoroughly
uninstall.
If that much is correct, I'd first be suspicious of junk left in the
registry or data directories. Even if it meant I had to install it
again, I'd use a
Aha! You are precisely correct. Thank you!
On 3 October 2010 21:16, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Oct 03), George Larson said:
I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free'
of '3896508416'. If I'm correctly understanding what I've
Hello all.
I have an InnoDB table with a 'Data_length' of 114688 and 'Data_free'
of '3896508416'. If I'm correctly understanding what I've been
reading, those are good conditions to optimize the table. I
understand the part where it maps to 'ALTER' for InnoDB. However,
nothing I do seems to
Willy Mularto wrote:
Hi,
I got this result on InnoDB Buffer Pool Status:
Free pages1
Dirty pages 2,040
Pages containing data 31,359
Pages to be flushed 457,083,205
Busy pages1,408
Read requests 31,348,288,497
Write requests7,913,407,934
Read misses
Uwe Brauer wrote:
What I had to do in addition was to copy the ibdata1
*then* I recovered the content of the db.
Thanks a lot
Uwe Brauer
Uwe,
Congratulations! That's great news! Sorry I didn't know to mention
that step. Where is your 'ibdata1'? Mine is in '/var/lib/mysql' so,
for
Johan De Meersman wrote:
On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent dae...@daevid.com wrote:
You do know you can use ssh tunnels and such to connect to your server from
your desktop right? I do it all day long. It's pretty easy to do and built
in to these programs.
You can't
Daevid Vincent wrote:
Get this tool: http://sqlyog.com/ it rocks.
There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
Alternatively, there is MySQL WorkBench. Some of the guys around here
use SQLYog but, since it is a LAMP environment, I like that WorkBench is
Carlos Mennens wrote:
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote:
Get this tool: http://sqlyog.com/ it rocks.
There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
I can't use any graphical or 3rd party add-on's. I was hoping MySQL
had this
Hi all. I've got a greenhorn question but I didn't find the right
keywords to get Google to answer it for me.
Is it more efficient to put conditions in a JOIN instead of sticking
them all at the end in the WHERE clause, or is that just a matter of
preference? Putting conditions in the JOIN It
Uwe Brauer wrote:
On Thu, 09 Sep 2010 18:02:09 -0400, George Larson
george.g.lar...@gmail.com wrote:
We do nightly backups at work just by taring the mysql directory. In
my environment, that is /var/lib/mysql.
Like this:
service mysql stop
cd /var/lib/mysql
deleted everything?
anyway, I hope I missed the joke here, or missed something...
Steve.
On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote:
We do nightly backups at work just by taring the mysql directory. In
my environment, that is /var/lib/mysql.
Like this:
service mysql stop
Shawn Green (MySQL) wrote:
On 9/10/2010 10:01 AM, george larson wrote:
Uwe Brauer wrote:
...
The only one I know of, for my environment, is /etc/my.cnf. I believe
that it can be located elsewhere but you could just use 'find' to find
it. I've broken my dev. MySQL many, many times
We do nightly backups at work just by taring the mysql directory. In
my environment, that is /var/lib/mysql.
Like this:
service mysql stop
cd /var/lib/mysql
rm -rf *
tar zxvf file.tar
rm -rf ib_logfile*
chown -R mysql.mysql
service mysql start
Something similar might work for you. Somebody
I hope I've come to right place, and I'm asking in the right way -- please
accept my apologies if not.
We have some dates missing and I need to populate those fields with dates
from the record just before them. I've gotten this far:
SELECT UUid, MIN(DDenteredDate) minDate FROM UUtable JOIN
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote:
All user information is stored in the mysql database. If you want
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams carlosw...@gmail.com wrote:
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote:
Now I did create that new database called 'forums' and would like to
create a new user who has access only to that specific database from
I'm quite a distance from the best person to answer this question but MySQL
has weekly webinars and there are a ton of good tutorials on the web.
I started with WAMP (LAMP, MAMP and XAMP are suitable alternatives) and just
started reading tutorials. Then I went to the local discount store and
Yeah! No kidding. If IBM doesn't pick it up then maybe I will. ;-p
On Wed, Mar 18, 2009 at 12:30 PM, Lin Chun franks1...@gmail.com wrote:
Sun only worth 6.5 billions?
--
-
Lin Chun
18 matches
Mail list logo