Hi;
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
n't Connect Localhost
To: mysql@lists.mysql.com
Cc: "John Smith"
Date: Sunday, 1 September, 2013, 3:33 AM
Hi John,
Starting over….
What is the "error message"?
Terry
___
Terry J Fundak
Systems Engineer
Network Design and
On Sun, 1/9/13, Reindl Harald wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 1:34 PM
where you can change this? typically
in the config file
of teh software without crystal balls we don't
On Sun, 1/9/13, Reindl Harald wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 2:44 PM
> > I looked in mysql.config.pl and no "localhost" :(
> "mysql.config.pl" from what software damned?
> "
Hi,
i'm currently experimenting with nested sets. To insert a new node,, I
need 1 SELECT, 2 UPDATE and 1 INSERT statement.
Of course all of this wii be packed into a transaction, because the table
could get corrupted if not all of the mentioned queries are executed.
Now here's the question: I nee
Perrin Harkins wrote:
> Assuming you're using InnoDB tables, "SELECT...FOR UPDATE" will lock
> the rows as you describe. It can prevent other inserts and updates to
> neighboring rows as well, depending on what isolation level you're
> running (default is REPEATABLE READ).
Thanks, in fact it eve
nt five roots. That is clean, works great but lacks performance
(especially in mysql).
Is there another way?
Greets, John Smith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
here my table which stores multiple trees with nested sets:
CREATE TABLE `posts` (
`posting_id` int(11) unsigned NOT NULL auto_increment,
`root_id` int(11) unsigned NOT NULL,
`lft` int(11) unsigned NOT NULL,
`rgt` int(11) unsigned NOT NULL,
`subject` varchar(400) collate latin1_germ
Hi!
I have redhat 7.3 with the mysql packages that came with it.
Since RHSA-2003:093-14 came out I upgraded mysql with
mysql-3.23.56-1.73.i386.rpm
mysql-devel-3.23.56-1.73.i386.rpm
mysql-server-3.23.56-1.73.i386.rpm
When I try to start mysqld I get the following error message
in the log:
Table 'my
I'm getting this error in my log:
--
030618 15:08:24 mysqld started
030618 15:08:24 InnoDB: Started
030618 15:08:24 /usr/sbin/mysqld: Can't create/write
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
/usr/sbin/mysqld: ready for connections.
Version: '4.0.12'
Hi All,
I have built a search application in php/libcurl and I store its results in MySQL.
The problem is that I am not used to dealing with the sizes of tables my search
application produces, roughly around 400,000 rows in a table the last time I got ran
it correctly.
Right to my problem.
I
Right, I upgraded my version of MySQL last night after a lot of digging about, found a
few bugs to do with table coruption that possibly could have been the problem.
I am re-runing my script and its seems to be going fine this time.
I am now using 4.0.28, I was using an early version of 4 can't
Afternoon All,
I have the following table structure:
CREATE TABLE properties (
id int(11) NOT NULL auto_increment,
propid varchar(14) NOT NULL default '0',
townid varchar(255) NOT NULL default '',
countyid mediumint(5) NOT NULL default '0',
address text NOT NULL,
price int(14) NOT NUL
On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
> What does the explain plan look like?
>
id select_type table type possible_keys key key_len ref rows
Extra
1 SIMPLE properties ref old,price,countyid countyid 3 const 9233 Using where;
Using filesort
The filesort I know
On Thu, 2004-11-11 at 14:36, Philippe Poelvoorde wrote:
> Hi,
>
> could you try adding a key with
> ALTER TABLE properties ADD INDEX(countyid,old,price);
> It could maybe help getting less rows at a time.
I dropped the old and price for the where clause and the number of rows
scanned were the sam
On Thu, 2004-11-11 at 14:59, Victor Pendleton wrote:
> If you build the composit indexes as suggested, does your performance
> improve?
Erm, do you think it would? Its just that with such a large table and it
being compressed it takes ages?
--
MySQL General Mailing List
For list archives: htt
I know that having a fulltext index on a table slows inserts and updates
down (or I think I do...might have miss read something)
I have a large table that uses fulltext which I plan to update nearly
90% of the rows (400,00+) and add new ones.
It currently takes around 35 minutes to remove the ind
I've searched manyh places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
>m
I've searched many places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
>my
19 matches
Mail list logo
