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 sep
Aha! You are precisely correct. Thank you!
On 3 October 2010 21:16, Dan Nelson 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
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 aff
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
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
Johan De Meersman wrote:
> On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent 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 multi-jump, t
Carlos Mennens wrote:
> On Tue, Sep 14, 2010 at 2:24 PM, 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.
>
> I can't use any graphical or 3rd party add-on's. I was hoping MySQL
> had this native /
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
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
&
file, when it
> does not exist, since you just 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
Uwe Brauer wrote:
>>>>>> On Thu, 09 Sep 2010 18:02:09 -0400, George Larson
>>>>>> wrote:
>
>> We do nightly backups at work just by taring the mysql directory. In
>> my environment, that is /var/lib/mysql.
>
>> Lik
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 se
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 wit
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 DDdet
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams 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
>> localhost. I can't seem to find the
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
>> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>>> All user information is stored in the mysql database. If you want to
>>> see a list of users that have been created, que
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 got
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 wrote:
> Sun only worth 6.5 billions?
>
> --
> -
> Lin Chun
>
18 matches
Mail list logo
