At 01:05 AM 11/6/2002 -0600, you wrote:
Paul, the point was to have 'value' be part of the primary key for pure
lookup speed (data file would not need be referenced), but not to have it
effect the uniqueness of the 'id'/'date' key pair so that I could do an
'insert ignore' into the table with a
At 23:31 -0600 11/5/02, D. Walton wrote:
At 10:32 PM 11/5/2002 -0600, you wrote:
At 20:39 -0600 11/5/02, D. Walton wrote:
At 05:18 PM 11/5/2002 -0800, you wrote:
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
I have a table with 3 fields, 'id', 'date', and 'value'. I've created
thanks jeremy for the reply
Jeremy Zawodny wrote:
>
>
> >
> > any idea why is it that the mysqld daemon is not using the CPUs and/or
> > why is this taking so long??
>
> You might benefit from a larger key buffer.
>
> Can you show us the output of "vmstat 1" for 10 or 20 seconds?
>
What woul
At 10:32 PM 11/5/2002 -0600, you wrote:
At 20:39 -0600 11/5/02, D. Walton wrote:
At 05:18 PM 11/5/2002 -0800, you wrote:
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
unique index on 'id' and 'date' in orde
Kylix 3 looks fantastic. It's a huge improvement over Kylix 1 and 2.
It's a bit more of a traditional programming language than Access is,
which means there will be more work involved.
> MySQL provides a replacement for the database component but that still leaves:
>
> A programming environmen
> I would like to create a *.sql file that I can later use the SOURCE
command
> with. I would like to place comments along side the SQL statements for
> documentation purposes. Is this possible and if so - how is it done? I
don't
> want to add comments to a table.
· # marks everything to the right
ooopps! ähm sorry... yes, Rekall, not Kugar!
STIBS
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Brad" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 3:47 AM
Subject: Re: Access replacement...
> Brad wrote:
>
> >I am thinking of a move
I had my own little investigation in this topic and found the following:
> A programming environment;
> A report builder
Kugar is a good choice for building reports and as a programming environment
ala VB. I is programmable via Python. It's not Open Source but relatively
cheap: http://www.thekomp
At 08:36 PM 11/5/2002 -0800, Phil Straw wrote:
> summary VARCHAR NOT NULL,
Need to specify length:
summary VARCHAR(10) NOT NULL,
http://www.mysql.com/doc/en/CREATE_TABLE.html
- Robert
-
Before posting, please check:
htt
At 20:36 -0800 11/5/02, Phil Straw wrote:
OK guys, I am a relative newbie with MySql, but know something at least of
databases. Please can you direct me as to where this CREATE statement is
wrong. I am lost.
I get ERRORCODE 1064 which looks to be near DB_ERROR_SYNTAX in the code.
Before wading th
At 14:38 -0500 11/5/02, Vivian Wang wrote:
The syntac ESCAPED BY of load data infile is wrong in
http://www.mysql.com/doc/en/LOAD_DATA.html.
the [ESCAPED by '\\']
should be:
[ESCAPED BY '\']
Why do you say that?
-
Before post
At 23:26 -0500 11/4/02, Eric Frazier wrote:
Hi,
This is a why questionk, which may be somewhat pointless, but. Why is this
under alter table instead of drop index?
Because DROP INDEX cannot be used to drop a PRIMARY KEY.
Just like CREATE INDEX cannot be used to create a PRIMARY KEY.
Thanks,
OK guys, I am a relative newbie with MySql, but know something at least of
databases. Please can you direct me as to where this CREATE statement is
wrong. I am lost.
I get ERRORCODE 1064 which looks to be near DB_ERROR_SYNTAX in the code.
Before wading through all that I though I might ask the exp
At 22:33 -0600 11/5/02, Paul Maine wrote:
I would like to create a *.sql file that I can later use the SOURCE command
with. I would like to place comments along side the SQL statements for
documentation purposes. Is this possible and if so - how is it done? I don't
want to add comments to a table.
At 20:39 -0600 11/5/02, D. Walton wrote:
At 05:18 PM 11/5/2002 -0800, you wrote:
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
unique index on 'id' and 'date' in order to lookup 'value' quickly. I
would li
At 21:21 -0600 11/5/02, Lewis Watson wrote:
Hey MySQL users!
I have been using amanda as backup software. It seems that it is working
fine as a backup for the MySQL data directory but I am wondering is there a
better way to backup up the databases? They are production Db's so I really
do not want
At 21:36 -0600 11/5/02, Nicholas Gaugler wrote:
I want to alleviate some activity from my drives by changing the
group_home_dir & arch_dir variables for Innodb to a ram disk drive,
/dev/shm/. Other than loosing all transactions that were taking place
during a box crash, are there any problems wit
I would like to create a *.sql file that I can later use the SOURCE command
with. I would like to place comments along side the SQL statements for
documentation purposes. Is this possible and if so - how is it done? I don't
want to add comments to a table.
Thank You
Paul
mysql
--
I was under the impression that hotbackup was only available with innodb
tables
where do you get amanda from?
Alan
> -Original Message-
> From: Lewis Watson [mailto:lists@;visionsix.com]
> Sent: Wednesday, 6 November 2002 14:22
> To: mysql
> Subject: MySQL and amanda
>
>
> Hey MySQL users!
I want to alleviate some activity from my drives by changing the
group_home_dir & arch_dir variables for Innodb to a ram disk drive,
/dev/shm/. Other than loosing all transactions that were taking place
during a box crash, are there any problems with this? If the box crashes
(which shouldn't happ
Hey MySQL users!
I have been using amanda as backup software. It seems that it is working
fine as a backup for the MySQL data directory but I am wondering is there a
better way to backup up the databases? They are production Db's so I really
do not want to stop the server, but isn't this necessary
Brad wrote:
I am thinking of a move from a Windows network to Red Hat Linux at my work. I
am happy with OpenOffice for spreadsheets, word processing etc but the main
problem is replacing MSAccess.
MySQL provides a replacement for the database component but that still leaves:
A programming
Have a look at http://www.phpmyadmin.net/ as a starter.
Quoting Brad <[EMAIL PROTECTED]>:
> I am thinking of a move from a Windows network to Red Hat Linux at my work. I
>
> am happy with OpenOffice for spreadsheets, word processing etc but the main
>
> problem is replacing MSAccess.
>
> My
At 05:18 PM 11/5/2002 -0800, you wrote:
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
>
> I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
> unique index on 'id' and 'date' in order to lookup 'value' quickly. I
> would like to be able to add 'value' to the in
This is an interesting question and I hope you get a lot of responses since
I'm sure that I will only cover a small percentage of what you will actually
need.
The primary thing to remember is that you are moving from what could be
considered a self-contained development environment with a solid GU
oops,
I meant mysql_fetch_array($result,MYSQL_ASSOC);
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Tuesday, November 05, 2002 7:10 PM
To: John Coder; Ben C.
Cc: [EMAIL PROTECTED]
Subject: RE: Using Query Results in a Form
in php
">
-Original Message--
I am thinking of a move from a Windows network to Red Hat Linux at my work. I
am happy with OpenOffice for spreadsheets, word processing etc but the main
problem is replacing MSAccess.
MySQL provides a replacement for the database component but that still leaves:
A programming environment;
A
I am thinking of a move from a Windows network to Red Hat Linux at my work. I
am happy with OpenOffice for spreadsheets, word processing etc but the main
problem is replacing MSAccess.
MySQL provides a replacement for the database component but that still leaves:
A programming environment;
A
in php
">
-Original Message-
From: John Coder [mailto:jcoder@;insightbb.com]
Sent: Tuesday, November 05, 2002 7:04 PM
To: Ben C.
Cc: [EMAIL PROTECTED]
Subject: Re: Using Query Results in a Form
On Tue, 2002-11-05 at 20:23, Ben C. wrote:
> I am using the following query:
>
> $sql ="SELECT
On Tue, 2002-11-05 at 20:23, Ben C. wrote:
> I am using the following query:
>
> $sql ="SELECT company, name, email FROM $table_name
>WHERE email = '$_POST[email]' AND password = password('$_POST[password]')";
>
> Then I am echoing the $email on my form (it works because the person has
On Tue, Nov 05, 2002 at 08:18:57PM -0500, Murad Nayal wrote:
>
>
> Hello,
>
> I am struggling trying to optimize the performance of mysql over rather
> large databases. for now there is one issue I don't understand and I am
> wondering if anybody can help with any hints.
>
> I am trying to cre
Has anybody seen something like this when using show processlist?
Note how they have been killed, their status is null and the have been
running for 171316 seconds. I killed them yesterday.
mysql> show processlist;
+-+-+---+---+-++---+-
> Hi Guys,
>
> I just installed MySQL-3.23.53, Apache 1.3.27 and Jakarta-Tomcat 4.0.6
(All
> from Tarball). Everythings seems to be fine until the user can't login
from
> a web and from the log file, it said Authentication Error, can't connect
to
> db. But when I restarted the MySQL and Apache/Tomc
I am using the following query:
$sql ="SELECT company, name, email FROM $table_name
WHERE email = '$_POST[email]' AND password = password('$_POST[password]')";
Then I am echoing the $email on my form (it works because the person has posted their
e-mail name when logging in). How can I
Hello,
I am struggling trying to optimize the performance of mysql over rather
large databases. for now there is one issue I don't understand and I am
wondering if anybody can help with any hints.
I am trying to create an index for a large table (100,000,000 rows). the
index is for a column of
On Tue, Nov 05, 2002 at 07:14:25PM -0600, D. Walton wrote:
>
> I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
> unique index on 'id' and 'date' in order to lookup 'value' quickly. I
> would like to be able to add 'value' to the index so that the data files
> does not
I have a table with 3 fields, 'id', 'date', and 'value'. I've created a
unique index on 'id' and 'date' in order to lookup 'value' quickly. I
would like to be able to add 'value' to the index so that the data files
does not have to be referenced and will allow faster lookups and groupings
by
Michael,
- Original Message -
From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 05, 2002 6:00 PM
Subject: InnoDB recovery
> I have a table that accidentally had a query run on it that NULL'd a
> certain field of the entire table.
Also see
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
It helped me a lot here...
sql query by the man
~Kelly W. Black
-Original Message-
From: Daniel Kasak [mailto:dkasak@;nusconsulting.com.au]
Sent: Tuesday, November 05, 2002 2:49 PM
To: Alain Motas
Take a look at "meta syntactics".
For example (using perl)
my $dbh = DBI->connect('DBI:mysql:SD2:localhost', 'root','') or die
"Couldn't connect to database $!\n";
my $SQL =<<"EOT";
insert into
table(col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,c
ol14,col15,col16,c
On Tue, 2002-11-05 at 11:21, Ken Arck wrote:
> I'm confused John. Since "--with-mysql=shared,/usr' " appears in the
> "Configure Command" table from phpinfo(), doesn't that mean php *was*
> compiled with mysql support?
Yes it was compiled with mysql support through tje dbx commands look at
the man
Alain Motasim wrote:
Hello,
I would like to load text files containing fixed-length fields into a
MySQL table by specifying position indices like when loading files
into an Oracle database, with a syntax close to this:
LOAD DATA
INFILE'c:\mydata.dat' append INTO MYTABLE
Hello,
I am working on a website for a client which is basically biological
database, and some have pictures, I am not allowed to give more out. It will
be stored in MySQL.
Basically the client says there are about 500 million different items of
data, which each holds about 10 small text f
> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
> but I only get the number 10, when the total should be around 100. So,
> can I get total matched rows without doing a separate query using
> count()?
>
> Here is an example of my current query:
>
> $result = mysql_query("SEL
Hello,
I would like to load text files containing fixed-length fields into a
MySQL table by specifying position indices like when loading files into
an Oracle database, with a syntax close to this:
LOAD DATA
INFILE'c:\mydata.dat' append INTO MYTABLE (
ID POSITION( 1 : 10
> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
> but I only get the number 10, when the total should be around 100. So,
> can I get total matched rows without doing a separate query using
> count()?
You first have to get the whole result set without the limit OR make use
The mysql_num_rows() function returns the number of rows returned in your
record set, which when limited is 10 (not 100). Thus you will have to do
another query.
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
- Original Message -
From: "SED" <[EMAIL PROTECTED]>
To: <[EMAI
I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
but I only get the number 10, when the total should be around 100. So,
can I get total matched rows without doing a separate query using
count()?
Here is an example of my current query:
$result = mysql_query("SELECT * FROM pro
Don Vu wrote:
Hi guys,
I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even
Hi guys,
I have a script in my home directory that i want others to be able to run. I 'chmod
777'ed the file and the folder it lives in and people still can't run it when they are
at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute
that script, even when i log in
not sure if this applies here, its from the c++ api docs (but why switch it around)
Do you have the parameters sent in the right order?
// The full format for the Connection constructor is
// Connection(cchar *db, cchar *host="",
//cchar *user="", cchar *passwd="")
I really k
I am. See the original post:
> > // Here's the remote connection - it connects to
> > the
> > same local machine, not the remote machine.
> > two = db_remote_connect
> > ("remote_machine","remote","remote","dbname");
> > db_do_query(two, "SHOW DATABASES");
--- "Black, Kelly W [PCS]"
<[EM
So use the C syntx instead.
:)
-Original Message-
From: Steven Webb [mailto:scumola@;yahoo.com]
Sent: Tuesday, November 05, 2002 12:21 PM
To: Black, Kelly W [PCS]; Mysql list
Subject: RE: using libmysqld - can't connect to remote DB as client.
Ok, but I'm writing this in C, not perl.
-
Ok, but I'm writing this in C, not perl.
- Steve
--- "Black, Kelly W [PCS]"
<[EMAIL PROTECTED]> wrote:
> I think your problem might be here ->
>
> you have db_connect("my_blah_database");
> Try using something like
>
> my $dbh = DBI->connect("DBI:mysql:$dbname:hostname",
> $dbuser, $dbpasswd) |
you're quite welcome, sir.
i've been doing this for decades, and i still
overlook the simple things.
i recommend that you develop a database naming
convention, since it appears that your
organization does not enforce one. mine helps
overcome my poor memory, so i appear more capable
than i
Hi John,
Thanks for that - I am new to MySQL - but I've found out two things here;
1. Case sensitivty is an issue with Linux/Windows
2. Beware of special keywords (I called a field in my database "date" - that
was also wrong -)
Since I've checked the case and prefixed my field names it works fin
Hi, all. Here's the problem, in short:
$ telnet localhost 3306
Trying 127.0.0.1...
Connected to acheloos.
Escape character is '^]'.
Connection closed by foreign host.
The connection is closed immediately; all 4 lines above are output in an
instant. Nothing's written in the log files.
I
My main problem is that I am unable to run the mysql_install_db file.
Below is what I have tried:
I can start mysql by using the folowing option:
shell> BINDIR/safe_mysqld --skip-grant-tables &
shell> BINDIR/mysql -u root mysql
However, when start mysql and try to perform anything, it errors our
HI!
I hope someone can help me with the following problem.
i have a table A type innoDB
THREAD 1 makes following query's:
SET AUTOCOMMIT=0;
SELECT * from table A where field1='value1' FOR UPDATE;
and now comes a new THREAD 2 while THREAD 1 is still holding the row
lock on Table A
THREAD 2 mak
The syntac ESCAPED BY of load data infile is wrong in
http://www.mysql.com/doc/en/LOAD_DATA.html.
the [ESCAPED by '\\']
should be:
[ESCAPED BY '\']
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
I have had problems with this kind of statement:
date = DATE
Try
date = 'DATE'
or even
date =curdate();
Note you can subtract
date = curdate()-1;
I have encountered no problems with upper/lower case in Linux
and Mysql.
~Kelly W. Black
-Original Message-
From: John Ragan [mailto:j
Luc,
Tuesday, November 05, 2002, 5:11:55 PM, you wrote:
LF> Just looking for confirmation on this one.
LF> If I install the .53a RPM on Red Hat 8.0 ( fresh install ), will it work right (
with the know issues at least )
Yes, 3.23.53a was compiled with statically linked glibc.
--
For technic
Chris,
Monday, November 04, 2002, 11:33:22 PM, you wrote:
CW> Same thing here. Local sockets are working find. Remote connections
CW> segfault. Getting ready to try the *workaround*. I am using mysql from
CW> the stock install of RH8.0
Take a look at this:
https://bugzilla.redhat.com/bu
Silmara,
Tuesday, November 05, 2002, 6:08:00 PM, you wrote:
S> I can't start mysql after the blackout of energy, when I try by
S> services(Win2000), start I get the following error 1067 Can't started the
S> MySQL in local machine
Run MySQL server in standalone mode
mysqld-max --standalone --
Jack,
Tuesday, November 05, 2002, 6:08:58 PM, you wrote:
JC> Thanks, but I still got complains that can't access server:
JC> 'Access denied for user: 'root@localhost' (Using password: YES)
JC> Is it possible that for some reason the password is wrong?
Yup. If you don't remember 'root' password,
Admin-Stress,
Tuesday, November 05, 2002, 12:41:08 AM, you wrote:
AS> After playing around with 'test' database, then I would like to create my own
database.
AS> I logged in into mysql using root account and created a database.
AS> But, when I logged in using regular user, I got his error :
AS
Nikolas,
Tuesday, November 05, 2002, 1:30:50 AM, you wrote:
NG> I was wondering about the following:
NG> I am hosting an application with a web hosting company and the character
NG> set doesn't satisfy me because I am doing some sorting of greek names
NG> and the hosting company uses the defaul
John,
Tuesday, November 05, 2002, 4:23:09 AM, you wrote:
JC> Is it possible to do a insert into blah
JC> (select...)union(select.)
JC> with mysql 4.03?
Yup.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.en
Jack,
Tuesday, November 05, 2002, 4:20:58 AM, you wrote:
JC> After I made mysqld running, I then tried:
JC> >mysql -u root
JC> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
JC> What does this mean?
It means that user 'root'@'localhost' without a password doesn't have
Unidux,
Tuesday, November 05, 2002, 9:38:59 AM, you wrote:
USHL> Where can I find the complete sample configuration include the explanation
USHL> of my.cnf file? I tried mysql.com documentation, but only a bit there.
Some info you can find in the manual:
http://www.mysql.com/doc/en/SHOW_VARI
I think your problem might be here ->
you have db_connect("my_blah_database");
Try using something like
my $dbh = DBI->connect("DBI:mysql:$dbname:hostname", $dbuser, $dbpasswd) ||
die "can't connect: $DBI::errstr\n";
Also make sure you include the || die "can't connect: $DBI::errstr\n";
as in th
Hi
just out of interest,
How can I create unique "data sets", or rather, set a set of data as
unique, to prevent another entry in the table that meets the same
criteria,
for instance:
id namesurname address
1 johndoe 1 street
2 maryjane
you've insured that you're not simply
encountering a problem with case sensitivity ?
windows is not case sensitive.
> Hi all,
>
> I have a problem - I've built some JSP which runs ok on a windows install of
> MySQL, but on a Linux install of MySQL only the update part works.
>
> Here is wha
Still nobody has answered my question.
Has anyone here even tried linking with libmysqld.a
before?
- Steve
--- Steven Webb <[EMAIL PROTECTED]> wrote:
> Nobody answered my question, so I felt like I should
> ask again ...
>
> I'm using libmysqld to embed a mysql server in my C
> app. However, I
On Tue, Nov 05, 2002 at 10:03:22AM -0500, Michael T. Babcock wrote:
> Wiley Jacobs wrote:
>
> >I have a situation where the customer that I have wants to use their current
> >Berkeley DB, although my system needs the SQL and schema definition that
> >MySQL offers. Is there any way to apply these l
Actually, I'm not convinced it would, because I want to be able to
find a string that is *NOT fully contained* within any given field.
In other words, I want a search for
The catcher in%
to match the row:
+-+--+
| article | tit
My problem is resolved. Apparently I was missing a package "php-mysql".
Funny, no docs I found make mention of this.
In any case, I'm up and running. Thanks to all who offered help!
Ken
--
President - Arcom Communicatio
I have one backup (back.sql) of 5 days ago and I don't start my database.
How can I do to recovery my backup in other database and to use old logs to
adjust my dataBase?
After install a new mysql and to create a new tableSpace Innodb, I can do
that?
regards,
Sil
[EMAIL PROTECTED] wrote:
There is a "primary key" which is not the main order to access rows.
What I am emulating is a large memory space and the "primary key" is just
used not to duplicate rows.
Please re-read my post as well as the very manual reference you later
gave; the PRIMARY KEY _i
Paul DuBois wrote:
That makes perfect sense. That value of NULL is unknown, so it's
impossible to say whether or not it matches a pattern. The only
reasonable result is NULL. Even NULL LIKE NULL and NULL REGEXP NULL
return NULL, because you can't tell whether or not one unknown value
is the s
Hi All,
I have messed up my server just a bit, it no longer starts ;) I have 2
servers one on a 98 machine for testing, and another on a 2000 box that is
being set up for intranet applications at my company. I usually do changes
etc on the 98 box then just stop both servers and copy the data folde
Note also there are methods to control loads under MySql.
You can use limits from the environment shell to
keep the load averages down.
People may say this is not in good form, or style,
but it works for me.
There are several methods you can use within the my.cnf
to streamline the MySql server
William R. Mussatto wrote:
From an SQL point of view, shouldn't the existing primary key be replaced
by another so that each row is ALWAYS uniquely addressable.
Unique addressability is something that is not an inate property of all
SQL tables; only ones that have UNIQUE or PRIMARY keys, so
From: http://www.dynamic-webpages.de/php/install.iis.php
-
"If you want to use the CGI binary, do the following:
Under 'Home Directory', 'Virtual Directory', or 'Directory', click on the
'Configuration' button, and then enter the App Mappings tab.
Click Add, and in the Executable box, t
Just a question, did you ever change your password for Mysql? If not
don't use the -p option
mysqladmin -u root create testdb
On Tue, 2002-11-05 at 11:08, Jack Chen wrote:
> Thanks, but I still got complains that can't access server:
>
> 'Access denied for user: 'root@localhost' (Using passwo
On Tue, 5 Nov 2002, Alan McDonald wrote:
> Date: Tue, 5 Nov 2002 18:49:22 +1100
> From: Alan McDonald <[EMAIL PROTECTED]>
> To: Eric Frazier <[EMAIL PROTECTED]>, Paul DuBois <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: RE: Removal of Primary Key in Mysql
>
> Because a primary key is a t
Hi guys, I hope you can show me where I am going wrong.
I have ASP working with MySQL & I have recently tried to install PHP. I am
obviously missing a point.
I am running IIS under win2000.
Initially I tried to install manually from binary distribution and failed.
To get it up and running I went ba
Hi,
How can I display only certain occurences from my database based on a certain
critieria.
In the filed "strSelect" I could have a long string which would contain:
strSelect =
"D:\temp\file.txt,D:\temp\file2.txt,D:\mywork\file.txt,D:\mywork\file.txt,D:\documents\file.txt,D:\documents\file.t
I downloaded MySQL GUI binaries from
http://www.mysql.com/downloads/gui-mysqlgui.html,
for installation under Redhat Linux v 8.0. I gunzipped the downloaded
binaries, but could not untar
them:
$ tar -xvf mysqlgui-linux-semi-static-1.7.5.tar
tar: This does not look like a tar archive
tar: Skip
Hi!
MySQL Control Center 0.8.6 has just been released.
MySQL Control Center will now be known as "MySQL Control Center" and *not*
"MyCC". It's short name will now be "MySQLCC".
0.8.6 is pretty stable and is a recommended update for all users !
Some of the changes for this release are:
*Rename
I'm confused John. Since "--with-mysql=shared,/usr' " appears in the
"Configure Command" table from phpinfo(), doesn't that mean php *was*
compiled with mysql support?
Ken
At 12:03 AM 11/5/2002 -0500, John Coder wrote:
>On Mon, 2002-11-04 at 23:51, Ken Arck wrote:
>>
>> > then it's compiled u
Sorry,
Geocities is run out.
http://www.burbello.hpg.ig.com.br/
Version 1.6 18/09/2002 - Size 650 KB - exe-file only
My Database Manager -Srv1
My Database Manager -Srv2
Thanks, but I still got complains that can't access server:
'Access denied for user: 'root@localhost' (Using password: YES)
Is it possible that for some reason the password is wrong?
You input is greatly appreaciated,
Puzzled newbie,
Jack
Jack
I can't start mysql after the blackout of energy, when I try by
services(Win2000), start I get the following error 1067 Can't started the
MySQL in local machine
Please, help me!
- Original Message -
From: "Silmara" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 05,
Jack Chen wrote:
>> $ mysqladmin -u root password PASSWORD
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> Could you inform me why?
That's why:
$ mysqladmin -uroot -pyourpassword PASSWORD newpassword
--
./ premax
right, sorry, I could have been more specific.
like so: mysqladmin -u root -p command, command...
example: mysqladmin -u root -p create mytestdatabase
On Tue, 2002-11-05 at 10:33, Jack Chen wrote:
> Stangely, it gave me a page of *information* like this: [any idea?
> thanks!]
>
> mysqladmin Ve
I have a table that accidentally had a query run on it that NULL'd a
certain field of the entire table. I have the data on old versions of
the binary table files from backup tapes, but have no idea how to get
this information out of those old binary table files. I unfortunately
don't have the
Mysql 4.0.1+ supports searches IN BOOLEAN MODE
So if mysql 4 is an option, I think that would work
for you.
http://www.mysql.com/doc/en/Fulltext_Search.html
olinux
--- Andy Ingham <[EMAIL PROTECTED]> wrote:
> Folks --
>
> We have built a table with bibliographic information
> that contains a
Stangely, it gave me a page of *information* like this: [any idea?
thanks!]
mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are wel
Ask your question in a Microsoft mailing list. I don't mean to be rude,
but this is a MySQL (Different product) mailing list. try Microsoft's
newsgroups.
On Tue, 2002-11-05 at 10:06, [EMAIL PROTECTED] wrote:
> Hi,
>
> I have just installed SQLServer7 after uninstalling SQL2k, and trying to
> l
1 - 100 of 121 matches
Mail list logo
