Simon Garner wrote:
On 6/05/2005 4:18 p.m., Mark Sargent wrote:
Ok, I just took a punt, and changed the setting in my.cnf to reflect
the config settings, to /tmp/mysql.sock, and all is well. What I
don't un, is, why the default settings were like this, I certainly
made no changes to either the c
On 6/05/2005 4:18 p.m., Mark Sargent wrote:
Ok, I just took a punt, and changed the setting in my.cnf to reflect the
config settings, to /tmp/mysql.sock, and all is well. What I don't un,
is, why the default settings were like this, I certainly made no changes
to either the configs or the my.cnf
Mark Sargent wrote:
Mark Sargent wrote:
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file.
How is this file generated..? I can't connect, keep getting errors.
What about via a port..? What is the argument for that..? Cheers.
Mark Sar
If you are windows then I prefer to use SQLyog at
http://www.webyog.com to do the job.
ITS FREE!
Karam
--- "Homam S.A." <[EMAIL PROTECTED]> wrote:
> NOTE: I sent this message yesterday, but for some
> reason it didn't show up in the list. If you've
> already received it, I apologize for the
> inc
Forgive me if this question has been answer in the past.
How can you record IP address on your first page index.html?
I am using my index.html to be index.lasso, and client_ip tag does not
seem to work.
It is picking up my server IP, and yes I have turned off the setting in
Lasso.
Now it see
Gordon wrote:
>Here is the table structure.
>In this case I tried to change the 4 characters in prod_ID when I get the
>message, but I get the same message when I try to make any changes.
>
>Doing the exact same activity works fine on all of the 3.23/4.0/4.1 versions
>I have installed previouly. T
Victor Pendleton wrote:
From your previous posts I know you are very competent so no disrespect
intended. Was the slave data reloaded from the master, and the master.info
reset? What does the master.info log say?
I copied over all the data from the master to the slave with
rsync, did "LOCK TABLES
>From your previous posts I know you are very competent so no disrespect
intended. Was the slave data reloaded from the master, and the master.info
reset? What does the master.info log say?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 3:16 PM
Victor Pendleton wrote:
Can you see the slave thread on the master when you do a show processlist
from the master?
Yes. It shows up with the command as "Sleep", nothing in the
"State" column, and NULL in the "Info" column. It hangs around
for a while until "Time" reaches a little over 500, and
Can you see the slave thread on the master when you do a show processlist
from the master?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 1:48 PM
To: mysql@lists.mysql.com
Subject: Slave stuck at "registering"
I'm trying to set up replication o
I'm trying to set up replication over the Internet -- something
I've done successfully many times before. But this time I'm
having problems I haven't run into before, and I'm wondering if
they're related to firewall settings or network problems or just
something I'm overlooking.
For the slave
Well... it's part of the SELECT statement, so you could try looking at
the SELECT documentation...
http://dev.mysql.com/doc/mysql/en/select.html
That has a good 9 paragraphs on the 'INTO OUTFILE' part of the SELECT
statement. It also refers you to...
http://dev.mysql.com/doc/mysql/en/load-data.
Actually, I did a full backup, uninstalled everything, installed a clean
4.1.11 and restored the backup
The data seems to be fine. The funny thing is that if i change one of
the inners for a left everything works fine! I think it's a bug, and an
ugly one...
Andrés Villanueva
Gleb Paharenko
NOTE: I sent this message yesterday, but for some
reason it didn't show up in the list. If you've
already received it, I apologize for the
inconvenience.
So here it goes again:
I searched the online manual and all I could find was
a reference to a statement of the form:
SELECT INTO OUTFILE...
I prefder to use a FREE GUI like SQLyog found at
http://www.webyog.com
Karam
--- Gary Richardson <[EMAIL PROTECTED]> wrote:
> try mysqldump -keq SDN > SDN.sql
>
> Then you can import it on another instance using
> mysql -u root
> new_instance < SDN.sql
>
> On 5/5/05, zlf <[EMAIL PROTECTED]> wro
You require SQLyog's Data Sync Tool. Download it from
http://www.webyog.com
You can find an article on it at:
http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent
Karam
--- Scott Purcell <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am developing a web application in which I have
> been work
If testuser signed in the day before the command was executed - i.e.
yesterday - he/she is well within the past 6 months and therefore
*shouldn't* be disabled.
Rhino
- Original Message -
From: "Allan P. Magmanlac" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 05, 2005 12:53 PM
Subject: ra
Hello,
We have radius server and using mysql. I would like to determine
who are the users
who have not login to our dialup server for over six months and then
disable the account
In the example below, I'm just using > 10 days
mysql> SELECT distinct
username,framedipaddress,acctstarttime,acc
Hello,
I am developing a web application in which I have been working between home and
an away office. Anyway, up to lately, most of my efforts have been writing the
queries, etc for the backend. So I have a text file that dumps the database and
repopulates them. And up until now, it has been e
try mysqldump -keq SDN > SDN.sql
Then you can import it on another instance using mysql -u root
new_instance < SDN.sql
On 5/5/05, zlf <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have installed a MySQL5.0 instance on Windows. And then created a
> database( named 'SDN' ). Now I want to move this
Title: The Official Tennessee Hispanic Chamber of Commerce
(Mailing List Information, including unsubscription instructions,
is located at the end of this message.)
Upcoming THCC Networking Mixer
May 19
Mixer in collaboration with CABLE
Jalapeño's Restaur
Thanks, that looks like my problem. I 'll wait until the fix percolates into
the 5. stream.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 10:00 AM
To: mysql@lists.mysql.com
Subject: Re: ACCESS ODBC Interface whit 5.0.4
Hello.
Have you be
Here is the table structure.
In this case I tried to change the 4 characters in prod_ID when I get the
message, but I get the same message when I try to make any changes.
Doing the exact same activity works fine on all of the 3.23/4.0/4.1 versions
I have installed previouly. Tables with unsigned i
Mark Sargent wrote:
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file.
How is this file generated..? I can't connect, keep getting errors.
What about via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably
Found my problem...
Thanks anyways :)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 05, 2005 4:09 PM
No - mysqld-nt-max is not running - I can see in the task manager that only
mysqld-nt is running!!
I also confirmed this by checking in my services - I only have mysqld-nt
present as a service for mysql!
Should I run mysqld-nt-max for this functionality to work??
Also - I need to run only myisa
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How
is this file generated..? I can't connect, keep getting errors. What
about via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably not in /tmp any more
Hi,
I dont think it's needed to go into to much details here but the query:
SELECT CONCAT(Airports.IATA, ' - ', Airports.Name) AS ArrivingFrom,
ADDTIME(FlightData.TimeStamp,
SUBTIME(FlightData.Enroute,DATE_FORMAT(SUBTIME(FlightData.TimeStamp,FlightData.ActDepTime),'%H:%i:%s')))
AS Ar
Hi,
Thank you. I have a doubt, you mentioned one equation as
Memory Used By MySQL = Innodb_buffer_pool_size + key_buffer_size +
max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) +
max_connections*2MB
Is it against mysqld or for each mysql prompt?.
Could you please co
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: "MySql"
Sent: Thursday, May 05, 2005 3:39 AM
Subject: The age old delete duplicates
> I have been researching on how to deal with duplicate data. While I have
a
> case where there can be duplicate data, and I want to ge
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How is
this file generated..? I can't connect, keep getting errors. What about
via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably not in /tmp any more. Try /var/lib/mysql
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How is
this file generated..? I can't connect, keep getting errors. What about
via a port..? What is the argument for that..? Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Hi all,
I have installed a MySQL5.0 instance on Windows. And then created a
database( named 'SDN' ). Now I want to move this database to another
MySQL5.0 envirnment on Linux.
How can I make it. Thx
zlf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Is it possible your data was changed during upgrade? How
have you performed it?
Andr$s Villanueva <[EMAIL PROTECTED]> wrote:
> Hi! thanks for your response.
>
> This are the values of the variables you asked for:
>
> collation_connection: utf8_general_ci
> collation_database: utf8
Hello.
Have you been here?
http://bugs.mysql.com/bug.php?id=9211
>I have been using ACCESS to do simpe data editing on our MySQL tables
>for 3
>years.
> I recently installed 5.0.4 on my machine to evaluate it. I linked the
> tables
> into ACCESS through my old ODBC driver and g
Hello.
There could be a lot of reasons for such a delay. First, you
should switch to bulk inserts and perform all operation as a single
transaction. Avoid usage of the autoextended or per-table tablespaces.
Are you able to upgrade? There could be some performance improvements
in the newer ve
Hello.
mysql.exe is a client utility, I've meant the server process. Check that
you're running mysqld-max-nt.exe.
>I am not sure about max - but I am running mysql.exe (I think it is the
>same as mysqld-nt).
>
>No - when I do a select * from on a table in the moved database - I get
>th
Hello.
> I see default unix socket file is /tmp/mysql.sock
> which could be removed by someone accidently.
> Is it normal to keep it that way or keep in a
> protected directory ?
See:
http://dev.mysql.com/doc/mysql/en/problems-with-mysql-sock.html
"V. Agarwal" <[EMAIL PROTECTED]
- Original Message -
From: "Scott Haneda"
> on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
> > Error strings do change format sometimes.
> > And they won't necessarily be in English. :-)
>
> I had a feeling, what is the general method most use to deal with the
above
> scenario?
> From: "Dennis Fogg"
> > I'm getting lots of duplicate rows even though I have a
> > unique index defined over multiple columns.
> > The issue is that multiple NULL values are allowed,
> > even when some values are not null.
> > This could be as specified by the SQL standard,
> > but it's certai
on 5/5/05 2:52 AM, Jigal van Hemert at [EMAIL PROTECTED] wrote:
> - Original Message -
> From: "Scott Haneda"
>> on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote:
>> Basically, I have a chopping cart, this one is a little weird, for reasons
>> not worth explaining, you have a car
- Original Message -
From: "Scott Haneda"
> on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote:
> Basically, I have a chopping cart, this one is a little weird, for reasons
> not worth explaining, you have a cart when a user is not logged in, and
they
> *may* have one they made at s
From: "Dennis Fogg"
> I'm getting lots of duplicate rows even though I have a
> unique index defined over multiple columns.
> The issue is that multiple NULL values are allowed,
> even when some values are not null.
> This could be as specified by the SQL standard,
> but it's certainly confusing fo
Mark Sargent wrote:
Hi All,
if this script is in scripts by default, why does it have the
following code,
test -z "$ldata" && ldata=./data
if test -z "$basedir"
then
basedir=.
bindir=./bin
execdir=./bin
pkgdatadir=./support-files
else
bindir="$basedir/bin"
if test -x "$basedir/libexec/mysql
Hi Shawn,
Thanks for your reply. The query you suggested seems to return all practices
that have bookings where the day type does not equal '1' - I changed your
query so it searches on the day_type rather than work_type as this is what
is required:
SELECT p.Practice_ID
,p.Practice_Name
on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote:
> Hi Scott, all!
>
> Scott Haneda wrote:
>> I have been researching on how to deal with duplicate data. [[...]]
>>
>> I am not in a situation where I can test for duplicates on insert, so the on
>> duplicate key update deal does me no
Hi Scott, all!
Scott Haneda wrote:
I have been researching on how to deal with duplicate data. [[...]]
I am not in a situation where I can test for duplicates on insert, so the on
duplicate key update deal does me no good here.
Most data points to selecting distinct records to a temp table, deleti
I have been researching on how to deal with duplicate data. While I have a
case where there can be duplicate data, and I want to get rid of it, the
general ideas I seem to find are as follows, plus my own, which I would like
opinions on since I have not seen it mentioned.
I am not in a situation
48 matches
Mail list logo
