hi,
i have installed on nt 4.0 sp 6 MySQL Version 3.23.43. After starting the
process with mysqld-nt --install, i wanted to start mysql and recived the
following error.
Error 2004: Can't create TCP/IP socket <10044>
what can i do.
gerd
---
Gerd Huber
Eichenweg 23
D-74369 L
Check out the mysqldump command line utility.
It also has its own man page.
Bye,
Neil
On Sun, 31 Mar 2002, kaps wrote:
> hi guys
>
> how can i get a backup of the database using the mySQL Server terminal
> access with my mySQL Sever?
>
> any help?
>
> cheers
>
> kaps
>
>
> -
hi guys
how can i get a backup of the database using the mySQL Server terminal
access with my mySQL Sever?
any help?
cheers
kaps
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
At 0:40 -0600 3/31/02, Alex Behrens wrote:
>Hey Guys,
>
>Is it possible to remove a primary key from a mysql table that has already
>been created without whipping out the table?
I suppose that depends on what "without whipping out the table" means.
I confess I have no idea.
ALTER TABLE might hel
hi guys!!
i m fairly new to mySQL. I have to work on already set up live database
which can be managedwith phpAdmin system.
Now i was wondering how can i take a backup (dump) of the database with that
system?
I have figured out how can i do it if i have to work on mySQL Server
instead.
Any he
Hey Guys,
Is it possible to remove a primary key from a mysql table that has already
been created without whipping out the table?
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-4
At 0:06 -0600 3/31/02, Alex Behrens wrote:
>Hey Guys,
>
>What is the command to display the names of all the columns in a table?
SHOW COLUMNS FROM tbl_name;
DESCRIBE tbl_name;
EXPLAIN tbl_name;
They're described in the manual.
>
>-mysql
>Thanks!
>
>-A
Hey Guys,
What is the command to display the names of all the columns in a table?
-mysql
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-
At 6:23 +0200 3/31/02, pascal barbedor wrote:
>- Original Message -
>From: pascal barbedor
>To: [EMAIL PROTECTED]
>Sent: Sunday, March 31, 2002 6:19 AM
>Subject: sum() autoconvert null to zero
>
>
> Egor,
>
>>Null is an unidentified value, but MySQL will store 0 or ''. You can read
>about
- Original Message -
From: pascal barbedor
To: [EMAIL PROTECTED]
Sent: Sunday, March 31, 2002 6:19 AM
Subject: sum() autoconvert null to zero
Egor,
>Null is an unidentified value, but MySQL will store 0 or ''. You can read
about
>it at:
> http://www.mysql.com/doc/B/u/Bugs.html
hi th
* Barbara Ferrell
> only every other line imported correctly and there was a quote around the
Seems like there is a line ending problem... windows use CRLF as line
endings in text files, but mysql expects LF only... have you tried "LINES
TERMINATED BY '\r\n';"
CR = ascii 13 = \r = return (carrig
mysql version 3.23.41 ...i am having a problem importing simple date and
text data ( 6 fields) (from access 97).
this is what i have tried:
load data local infile 'client.txt'
into table client
fields terminated by '\t';
all 9 records imports correctly except that the quotes are still around the
At 17:15 -0500 3/30/02, Michael Stassen wrote:
>On Sat, 30 Mar 2002, Paul DuBois wrote:
>
>> At 21:25 +0100 3/30/02, Roger Baklund wrote:
>> >* Son Nguyen
>> >> ==> I tried this query, but... it's not working out:
>> >>SELECT YEAR(now()-birthday) from users where loginName="test";
>> >
>
>Description:
Subject says it all
>How-To-Repeat:
./bin/safe_mysqld
>Fix:
unknown
>Submitter-Id:
>Originator:Kenneth Lerman
>Organization:
Systems Essentials Limited
>MySQL support: none
>Synopsis: Can't find file: 'host.frm' even though it exists
>Severity:
hi,
problem in connecting to server through C API function
mysql_real_connect()
the mysql handle returned by mysql_init() is not null
error message says:
Program received signal SIGSEGV, Segmentation fault.
0x4000807d in _dl_lookup_versioned_symbol (undef_name=0x8048b73 "sprintf",
ref=0xbff
On Sat, 30 Mar 2002, Paul DuBois wrote:
> At 21:25 +0100 3/30/02, Roger Baklund wrote:
> >* Son Nguyen
> >> ==> I tried this query, but... it's not working out:
> >>SELECT YEAR(now()-birthday) from users where loginName="test";
> >
> >You are very close:
> >
> >SELECT YEAR(now())-YEAR(birth
At 15:45 -0500 3/30/02, [EMAIL PROTECTED] wrote:
>Hi all,
>
>Begging for help.
>
>Newbie so please keep solutions as simple as possible please.
>
>I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine
>running mysql version 3.23.44.
>
>What steps do I take ?
>
>Unfortuna
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 30, 2002 12:40 PM
> To: [EMAIL PROTECTED]
> Subject: Begging for help.
>
>
> Hi all,
>
> Begging for help.
>
> Newbie so please keep solutions as simple as possible please.
>
> I wish to
Hi all,
Begging for help.
Newbie so please keep solutions as simple as possible please.
I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine
running mysql version 3.23.44.
What steps do I take ?
Unfortunately do not know enough about linux and Mysql to understand
Hi all,
Begging for help.
Newbie so please keep solutions as simple as possible please.
I wish to have an ODBC connection from my win98 machine to my RH 6.1 machine
running mysql version 3.23.44.
What steps do I take ?
Unfortunately do not know enough about linux and Mysql to understand
At 21:25 +0100 3/30/02, Roger Baklund wrote:
>* Son Nguyen
>> ==> I tried this query, but... it's not working out:
>>SELECT YEAR(now()-birthday) from users where loginName="test";
>
>You are very close:
>
>SELECT YEAR(now())-YEAR(birthday) as age from users where loginName="test";
That won't
Thanks guys I got it to work.
Also, thanksPaul for the PHP reference as well, I'm going to tool around
with both as a learning experience.
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Pho
* Son Nguyen
> ==> I tried this query, but... it's not working out:
> SELECT YEAR(now()-birthday) from users where loginName="test";
You are very close:
SELECT YEAR(now())-YEAR(birthday) as age from users where loginName="test";
--
Roger
query
---
How can I calculate current age with given birthday?
create table users (
loginName char(30) NOT NULL,
first_name char(30) NOT NULL,
last_name char(30) NOT NULL,
birthday date NOT NULL,
primary key (loginName)
);
==> How can I use the function now() ?
==> I trie
Nicklaus,
Now that we've got you warmed up: are you able to recommend any online
tutorials/references which cover the interfacing of VB/M$ Office
products (macros/VBA) to MySQL?
Please advise,
=dn
> Absolutely. I must tell you that we have MUCH fewer problems using VB
with
> MySQL than we do
| > Does that even make sense? "records 30 - 45" has no meaning, given
| > that the server is free to return records in any order it pleases.
|
| a select query issued on a table with an autoincremented field and no
ORDER
| clause seems to default to having it's results returned in order of
the
|
At 20:48 +0100 3/30/02, Roger Baklund wrote:
>* Paul DuBois
>> At 13:06 -0800 3/30/02, destr0 wrote:
>> >a select query issued on a table with an autoincremented field
>> and no ORDER
>> >clause seems to default to having it's results returned in order of the
>> >autoincremented field, ASC.
Hey, I'm having MySQL exhibit some really weird behavior. I am running
3.23.41 on OS X. I'm trying to implement a simple queue using MySQL and PHP.
Basically, I have a table with some data and a status field. The status
field tells the script the status of the queue entry (queued, paused,
executi
* Paul DuBois
> At 13:06 -0800 3/30/02, destr0 wrote:
> >a select query issued on a table with an autoincremented field
> and no ORDER
> >clause seems to default to having it's results returned in order of the
> >autoincremented field, ASC. I was saying "records 30 - 45" in terms of
> >that.
>
At 13:06 -0800 3/30/02, destr0 wrote:
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "destr0" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, March 30, 2002 10:36 AM
>Subject: Re: LIMIT, ORDER Dilema
>
>
>> Does that even make sense? "records 30 - 45" has n
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "destr0" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 10:36 AM
Subject: Re: LIMIT, ORDER Dilema
> Does that even make sense? "records 30 - 45" has no meaning, given
> that the server is free to r
Absolutely. I must tell you that we have MUCH fewer problems using VB with
MySQL than we do VB with Oracle. And it is obviously much faster, leaner,
and easier to maintain. I find that my biggest headache is convincing IT
people that open source products are worthy of their attention. Your
At 12:22 -0800 3/30/02, destr0 wrote:
>- Original Message -
>From: "Tyler Longren" <[EMAIL PROTECTED]>
>To: "destr0" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, March 30, 2002 9:38 AM
>Subject: Re: LIMIT, ORDER Dilema
>
>
>> You have to have the LIMIT clause after the ORDER
- Original Message -
From: "Tyler Longren" <[EMAIL PROTECTED]>
To: "destr0" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 9:38 AM
Subject: Re: LIMIT, ORDER Dilema
> You have to have the LIMIT clause after the ORDER clause.
If this is the case than can someone g
At 11:32 -0800 3/30/02, destr0 wrote:
>Can you not have the LIMIT clause before the ORDER Clause in a select query?
>
>SELECT * FROM myTable LIMIT 30, 45 ORDER BY someField ASC;
>
>This query ^ fails with the error:
>
>Error 1064: You have an error in your SQL syntax near ' ORDER BY someField
>AS
This is my first crack at mysql. I am already connecting easily to parallel
mysql databases on Windows98 and on my ISP's server. I have linked to both
from Access97 via ODBC and I can connect to both from command lines. I
have also installed perl DBI and DBD::mysql at home. The ISP did not yet
h
You have to have the LIMIT clause after the ORDER clause.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "destr0" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 1:32 PM
Subject: LIMIT, ORDER Dilema
Can you not have the LIMIT clause before the ORDER Clause in a select query?
SELECT * FROM myTable LIMIT 30, 45 ORDER BY someField ASC;
This query ^ fails with the error:
Error 1064: You have an error in your SQL syntax near ' ORDER BY someField
ASC' at line 1
I just want to make sure that th
On 3/30/02 4:50 PM Paul DuBois wrote:
> At 9:50 -0600 3/30/02, Alex Behrens wrote:
>> Hey guys,
>>
>> quick question, I'm setting up a script that does headlines for my site and
>> I need to pull some information from a table with my review info from it but
>> I only want to view the 7 latest re
Hello Adriano,
Friday, March 29, 2002, 11:38:32 PM, you wrote:
As I remember there are max_allowed_packet options exists both for
client and server. You may wish to try to raise both of them.
AM> I've been using a perl script to insert a very large blob (up to about 8
AM> MB) into a DB succes
Hello Jeremy,
Friday, March 29, 2002, 3:10:35 AM, you wrote:
>> Also a good thing with DRBD you will not have to store and track
>> replication log files and the setup will not require to take MySQL
>> down to copy the snapshot of database.
JZ> Why would you need to take down MySQL for a back
At 9:50 -0600 3/30/02, Alex Behrens wrote:
>Hey guys,
>
>quick question, I'm setting up a script that does headlines for my site and
>I need to pull some information from a table with my review info from it but
>I only want to view the 7 latest reviews, how do I make it so I can only
>view like 7
At 17:24 +0200 3/30/02, Okan CIMEN wrote:
>Dear Paul,
>
>I have full privileges on the database.
FILE is a global privilege, not a database-specific privilege.
>
>mysql> show grants for username-> ;
>+---
>--
* Alex Behrens
> quick question, I'm setting up a script that does headlines for
> my site and I need to pull some information from a table with
> my review info from it but I only want to view the 7 latest
> reviews, how do I make it so I can only view like 7 highest
> values for the "num" co
Hey guys,
quick question, I'm setting up a script that does headlines for my site and
I need to pull some information from a table with my review info from it but
I only want to view the 7 latest reviews, how do I make it so I can only
view like 7 highest values for the "num" column?
my query is
Dear Paul,
I have full privileges on the database.
mysql> show grants for username-> ;
+---
--+
| Grants for username@%
|
+-
At 16:21 +0200 3/30/02, Okan CIMEN wrote:
>Hello,
>
>When I try to get the remote dump of a database, I get the table structure
>without any failure but it is not able to get the table data. Has anyone of
>you came over to this problem before?
>Here is what I have tried:
-T requires that you have
I am about to undertake a major project and I would
like to know if you are able to link MySQL to Visual
Basic and whether this is a safe solution.
Thanks.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Pa
Hi.
This is the documented behaviour. For details, see
http://www.mysql.com/doc/G/r/Group_by_functions.html
How to deal with this is discussed in the tutorial section:
http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
Bye,
Benjamin.
On Sat, Mar 30, 2002 at 09:24:26PM
Hello,
When I try to get the remote dump of a database, I get the table structure
without any failure but it is not able to get the table data. Has anyone of
you came over to this problem before?
Here is what I have tried:
H:\>c:\mysql\bin\mysqldump -T "c:\mysql\batch\dump\new_dump" -f -l -v -u
Hi All,
I tried to find when myODBC 3.51.03 was to be released on www.mysql.com but I couldn't
find it anywhere!
Anyone that knows either when it is up for release or where I can read this?
Thanks in advance,
___
Jens A. Collin
Envox Technical System Developer
Everyone,
Is this a bug or somethingi am using the latest version of MySQL server
and it works fine and convincing...but I observe that if I use the MAX()
functioni got this
I include max() function to my select query
Ex..
select max(A),B,C from table_name group by A;
the result i
Dave,
Thanks for your response. The problem with that, while it is technically one
insert statement, mySQL still builds the primary key record-by-record
(keycache), rather than sorting the keys and creating the index in one shot,
like myisamshk can do. "INSERT..." would take upwards of 24 ho
Javier,
Friday, March 29, 2002, 8:22:26 PM, you wrote:
JG> i have the next question.
JG> how can i add a user to mysql with the console or shell ?
JG> how can i do the same posses from a php script or application from the
JG> Internet?
It's covered in the manual, look at:
http://www.mys
G'day rory
> it is possible to link his filemaker database to the MySQL database
Perhaps this php class would be of use to you. From the Read Me:
FX.php is a PHP class for accessing FileMaker Pro data. FX is free and
open-source. Thanks to FX.php, FileMaker enthusiasts can now access thei
55 matches
Mail list logo
