When should I use the autoextend option for the InnoDB file...Even after emptying the
tables the files keeps its size and for new insertions it gets even bigger instead of
using the already allocated space(which I suppose should be available after emptyibg
the tables).
thank you friends
aik_b
Hi MySQL Fans ;-),
I have a question regarding the MySQL feaures.
From Version 4.1 Full subselect support was/is announced.
However if I understood correctly then already from Version3.23-41 (or
earlier) there are some subselect functions already included. For xample if I
try this:
CREATE TAB
I don't know if this apply when using GRANT but have you tried afterwards:
> flush privileges;
HTH,
Lian
> -Original Message-
> From: Riaan Oberholzer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 9:19 AM
> To: [EMAIL PROTECTED]
> Subject: Problem setting/activating passwo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, David Griffiths wrote:
> I'm surprised there is not more interest in this; is it that not many
> work with large-ish (10+ gig) databases that need high-end performance?
Many of our customers do.
> A 64-bit CPU won't have th
Hi all,
Is there any way to do a mysql dump in which each table is dumped into a
separate file. I know I can use the --tables option to specify a table,
but this means I have to type out each table name (and there are a lot
of them). Is there any way to get mysql to automatically iterate
through
I.-A.,
- Original Message -
From: ""I-A.Kotopoulos"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 25, 2003 10:05 AM
Subject: InnoDB file...
> --=_NextPart_000_00B5_01C33B01.642AD2C0
> Content-Type: text/plain;
> charset="Windows-1252"
> Content-Transf
Hi all,
I have a question about MyISAM, during an UPDATE for a row, is it a row
locking or a table locking?
--
Cedric Gavage <[EMAIL PROTECTED]>
http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
What do you mean when you say, in this case, "does not return the NULL
(Brecord"?
(B
(BI have no records that are completely "NULL" though some records do
(Bhave a NULL field or two?
(B
(BThanks,
(BTed
(B
(B
(BOn Wednesday, June 25, 2003, at 02:42 AM, Nils Valentin wrote:
(B
(B> Hi t
Hi to all,
I will have to do with a very big file (approx 600 millions of records).
Which is the best table handler for this king of table : InnoDB or MyISAM
(many INSERT and MANY SELECT, no UPDATE - statistics file).
Best regards.
--
MySQL General Mailing List
For list archives: http://lists.m
On 25-Jun-2003 MaFai wrote:
> Hello, mysql,
>
> After create a table,it can use desc tablename to describe the table
> scheme.
> But it can not demonstrate that the column is unique or not.It just
> simplely show the column is MUL type.
> How can I get more information from the tabl
On 25-Jun-2003 Ralph wrote:
> I am getting a list of all countries from database, and then I am
> sorting by country name. However since most orders will be from US I
> want the US to appear first over the rest of the countries. How can I go
> about doing this?
>
> Currently, this is my query:
>
Installed MySQL v4.0.13 on RH8, with phpMyAdmin-2.5.1 and PHP v4. The phpMyadmin is
installed on another server (gateway) while MySQL and PHP is installed on a separate
server. When the programmer tries to access MySQL he gets the following message:
Error 2003 Cannot connect to MySQL server 203
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, Dyego Souza do Carmo wrote:
> try to bk pull the mysql 4.0 from CVS tree...
>
> after I run:
>
> aclocal; autoheader; autoconf; automake
>
> inside dir...
>
>
> the error is:
>
> autoconf: Undefined macros:
> configure.in:8:A
# [EMAIL PROTECTED] / 2003-06-25 12:05:49 +0800:
> //Wrong sql statement
> alter table p_asset add mydate datetime default now();
> alter table p_asset add mydate datetime default time();
> alter table p_asset add mydate datetime default now;
> alter table p_asset add myda
alter table p_asset add mydate datetime default 'now()';
- you need the '' around now(); apparently
http://www.mysql.com/doc/en/DATETIME.html
and scroll down to the comment made by
Lazy Soul on Tuesday May 27 2003, @8:15am
Jan
Janice Wright
Ingenta plc
[EMAIL PROTECTED]
http://www.ingentase
Hi !
Just wanted to know if there is any installation procedure available on =
UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which =
I have downloaded but Iam not able to initialize ./Configure script. =
Any help/support will be appreciated.
Thanks In Advance
Regards
Sudhipan
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > please don't piggyback on other people's threads. you can start your
> > own for free.
>
> Although it was the first time for me to send the post on this list, I was
> sure that I did not foll
>>> SELECT * FROM machines INNER JOIN people ON
> >>> machines.peopleID=people.peopleID;
> >>
> >> Inludes NULL records
I meant the first statement returns also empty record fields or should I say
incomplete data records ?
> >>
> >>> Is not producing the same results as this:
> >>>
> >>> SELECT
insert one space before US ;)
in recieving do trim if not HTML output
-Original Message-
From: Ralph [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:32 AM
To: mySQL Mailing List
Subject: Sorting Countries
I am getting a list of all countries from database, and then I am
sorti
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 24 Jun 2003, Daevid Vincent wrote:
> It would be really nice if ANY of these kinds of configuration options
> were settable via the /etc/my.cnf file. I use RPM's almost exclusively
> for their ease of maintenance, compatibility and stabil
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> Sometime recently MaFai said:
> > A table contains a column named "mydate".
> >
> > //Wrong sql statement
> > alter table p_asset add mydate datetime default now();
> > alter table p_asset add mydate datetime default time();
>
You're right, just tested it myself on 3.23.41; and I get exactly
the same result as you. We should post an amendment to the docs
on the website.
However, (still with 3.23.41):
mysql> create table autotime2 (foo int, bar timestamp default now());
ERROR 1064: You have an error in your SQL syntax
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> I have some questions about temporary tables. I would appreciate any replies:
>
> I created a temporary table f.e. like this:
>
> mysql> create temporary table temp SELECT * FROM relations;
> Query OK, 4 rows affected (2.35 sec)
> Records: 4 Duplicate
Hi
My server www has Suse 8.2, apache-1.3.27, mod_php4-4.3.1,
and my server mysql has Suse 8.2, and mysql.4.0.12-Max-log
Sometimes, not always, it appears an error in www.
Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost,
unable to reconnect in db_mysql.inc on line 73
# [EMAIL PROTECTED] / 2003-06-25 07:10:46 +0100:
> Sometime recently Roman Neuhauser said:
> > # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> > > alter table p_asset add mydate datetime default 'now()';
> > >
> > > - you need the '' around now(); apparently
> > >
> > > http://www.mysql.com/d
any one can tell me how can i use the MySQL ++ function in CBuilder 6??
i include it in my project but i got linker error
"Javan B." <[EMAIL PROTECTED]> wrote:
>
> Just a quick question: How do I set the auto increment
> for a field to start from an integer other than 1.
>
> For example, I would like to be able to have the auto
> increment counter start from 1000.
>
Use AUTO_INCREMENT option of CREATE TABLE statem
Compiler errormessage ver 1.3
C:\mysql\bin>comp-err.exe -I
comp-err.exe (Compile errormessage) Ver 1.3
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: comp-err.exe [-?] [-I] [-V]
# [EMAIL PROTECTED] / 2003-06-25 02:11:05 -0400:
> I needed to add a new, autoincrementing, primary key column
> to a table and have been struggling to figure out how to
> assign an initial, unique value to each row.
>
> I finally accomplished my task, but feel sure there's an
> easier way.
>
Cedric Gavage <[EMAIL PROTECTED]> wrote:
>
> I have a question about MyISAM, during an UPDATE for a row, is it a row
> locking or a table locking?
MySQL locks the whole MyISAM table.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
> Compiler errormessage ver 1.3
>
> C:\mysql\bin>comp-err.exe -I
> comp-err.exe (Compile errormessage) Ver 1.3
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it u
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
>
> I have a question regarding the MySQL feaures.
>
> From Version 4.1 Full subselect support was/is announced.
>
> However if I understood correctly then already from Version3.23-41 (or
> earlier) there are some subselect functions already included.
Also doesnt work in 4.1 alpha.
Best regards
Nils Valentin
Tokyo/Japan
(As requested I took Roman of , as he doesnt like direct e-mails ;-)
2003年 6月 25日 水曜日 19:12、Roman Neuhauser さんは書きました:
> # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> > Sometime recently MaFai said:
> > > A table contai
At 12:54 25/6/2003 +0200, Morten Gulbrandsen wrote:
Hi,
for which purpose is this file included in the file
C:\mysql\bin directory ?
For to build the errmsg.sys files:
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
c:\mysql\bin>comp-err c:\mysql\share\english\er
I use unicode to store farsi data in mysql database but I have problems sorting it
using ORDERBY command...(ORDER BY does'nt work properly)
I don't know what to do .
1---)pleases help me if there is any solution for me to define a charset in the order
that I want .
2---) how can I replace th
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint
Hi Egor,
Thank you for the reply. Do you mind to go abit mor into details ? It seems
that I got domething wrong here.
If nested queries are not only subselects, which other nested queries exist
there ?
Do you mind just writing a few samples, please ?
Sorry if this seems a simple question - fr
Hi,
Try mysqldump -T:
-T| --tab=...
Creates tab separated textfile for each table to given path.
(creates .sql and .txt files). NOTE: This only works if mysql‐
dump is run on the same machine as the mysqld daemon.
This was taken from the man page.
On Wed, 2003-06-25 at 08:56, Rob
Todd Burke wrote:
Hello
1/ I have a search engine which crawls auction sites and returns
information which is inserted into a mysql database. This activity
represents on average about 3 inserts per second with a combined payload
of 450 bytes per second added to the database. This updating occurs
This follows on a previous mail from me:
When using
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
password
I could not get the password authentication to kick
in. Only supplying no password (empty string)
succeeded. Even after doing SET PASSWORD
and FLUSH
PRIVILEGES.
Then I tried
WOW Victoria,
thats a good explanation. That makes many things clearer now.
Thank you very much.
However, when not having the set the tmpdir variable were are the temporary
tables stored ? (I searched the whole harddisc) I assume in this case that
they must be stored in the memory, is that r
Note: forwarded message attached.
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!--- Begin Message ---
I use unicode to store farsi data in mysql database but I have problems sorting it
using ORDERBY command...(ORDER BY does'nt work properly)
I don't know what to do .
1---)pleases
hi!! i wrote a simple function that returns a string in C
the function fetches values from a table and stores all the value in a string variable
and then returns it ...This is small part inside the function i wrote!
while((row = mysql_fetch_row(res)))
{
unsigned long *length
Hello,
I currently am
struggling to get the permissions and table restrictions to
work.
Description of the
case:
--
For a database
"examp", where table "foobar" which contains colums "A", "B" and C ,only a
restricted access is allowed.
Lets say that us
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700:
> insert into table1 select * from table2;
>
> Table2 has some 10,000 records while table1 has around
> 11,00,000 records. The time reqd. to execute the above
> query is round about 80- 90 secs.
>
> The table1 has 7 columns out of which 5 are comp
Prem Soman wrote:
hi!! i wrote a simple function that returns a string in C
the function fetches values from a table and stores all the value in a string variable
and then returns it ...This is small part inside the function i wrote!
while((row = mysql_fetch_row(res)))
{
unsign
Alternatively you can create a priority column defaulting to one number (99)
this will allow you to easily change the country sequence as needed.
SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY
priority,countries_name;
I hope this helps...
Pat...
[EMAIL PROTECTED]
CocoNet Corpo
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hi All,
Im altering a number of table from MyISAM to innoDb and adding foreign keys.
The alteration of the table type works.
Adding the row as an index works.
Adding the foreign key fails, generating the error:
alter table project add FOREIGN KEY (company_id) references company (id)
[mySQL] E
Nils Valentin wrote:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Inludes NULL records
I meant the first statement returns also empty record fields or should I say
incomplete data records ?
Is not producing the same results as this
I think we need more info: Table definition, MySQL version etc..
Med venlig hilsen
Lars Geisler
>
> -Original Message-
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> To: "Amit Lonkar" <[EMAIL PROTECTED]>
> CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: Re: Query Execution Time
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100:
> Im altering a number of table from MyISAM to innoDb and adding foreign
> keys.
>
> The alteration of the table type works.
> Adding the row as an index works.
> Adding the foreign key fails, generating the error:
>
> alter table project add FORE
your MUA doesn't properly represent quotation marks, breaking them
in other MUAs.
# [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the passwor
In the second query, the server may switch the order of the join,
producing the same output in different order.
Try adding an ORDER BY to both and see what happens.
[EMAIL PROTECTED] wrote:
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
To also add priviliges on the local machine
GRANT ALL ON *.* TO username@"localhost" IDENTIFIED BY
"password"
Riaan Oberholzer wrote:
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@"%" IDENTIFIED BY
"password"
I did this from the mysql command line tool, logged in
as root. Th
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> WOW Victoria,
>
> thats a good explanation. That makes many things clearer now.
> Thank you very much.
>
> However, when not having the set the tmpdir variable were are the temporary
> tables stored ? (I searched the whole harddisc) I assume in thi
"mohammad kh.tajer" <[EMAIL PROTECTED]> wrote:
>
> I use unicode to store farsi data in mysql database but I have problems sorting it
> using ORDERBY command...(ORDER BY does'nt work properly)
> I don't know what to do .
> 1---)pleases help me if there is any solution for me to define a char
PAUL MENARD <[EMAIL PROTECTED]> wrote:
>
> I'm having an intermittent problem with a MySQL server that I have running on a
> Windows 2000 Advance server systems. This issue occurs every few days depending on
> the load of the system.
>
> Here are the details.
>
> MySQL version 3.23.42-nt (I k
> I believe "%" doesn't include "localhost", but I could be wrong.
"%" Does indeed include localhost. At least it does on 4.0.13.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Maybe it does, or maybe it doesn't; but if you're connecting to your
server on the localhost, you're probably connecting through a pipe/UNIX
type socket instead of over the network. This might be the distinction
that matters in this case; does @localhost in this context mean through a
non-network
On Wed, 25 Jun 2003, Sudhipan Sharma wrote:
> Hi !
> Just wanted to know if there is any installation procedure available on =
> UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which =
> I have downloaded but Iam not able to initialize ./Configure script. =
> Any help/support wi
I simply followed the directions listed here:
http://www.mysql.com/doc/en/SCO_UnixWare.html
And I had no problems.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Sudhipan Sharma [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 3:08 AM
> To: [EMAIL PROTECTED
And what would that be?
Phil Dowson wrote:
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives: http://lists.m
In a situation with many concurrent reads and writes an InnoDB table
would be preferable.
See http://www.mysql.com/doc/en/Table_types.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 2:
Riaan Oberholzer <[EMAIL PROTECTED]> wrote:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the password authentication to kick
> in. Only supplying no password (empty string)
> succeeded. Even after
"Phil Dowson" <[EMAIL PROTECTED]> wrote:
>
> I am running two identical systems, the only difference between the two are
> the database name and username. The problem I am getting only occurs on one
> of the systems. I am running
What exactly problem do you have?
--
For technical support cont
MyISAM tables do not support row-level locking, only table locking.
See http://www.mysql.com/doc/en/Table_locking.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Cedric Gavage [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 2:14 AM
> To: [EMAIL PROTEC
I am attempting to modify the GRANT table using the syntax specified in the
MySQL 4.0.13 documentation, and am getting error messages claiming the
syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
mysqlc with root access.
mysql> USE mysql;
Database changed
mysql> GRANT SEL
yesterday i had same problem on 4.0.13 for win
added [EMAIL PROTECTED] - and was rejected
added [EMAIL PROTECTED] - then accepted
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:54 PM
To: Roman Neuhauser; Riaan Oberholzer
Cc: [EMAIL PROTE
I think you need the -T option, which will break out table data to
separate files. Here's a description from the manual:
-T, --tab=path-to-some-directory
Creates a table_name.sql file, that contains the SQL CREATE commands,
and a table_name.txt file, that contains the data, for each give table.
I am not sure that could be viewed as a subselect, as it in not a SELECT
within an SELECT, but is instead a SELECT within a CREATE. I would
imagine that the SELECT within the CREATE is easier to implement that
the actual SELECT within a SELECT.
Regards,
Mike Hillyer
www.vbmysql.com
> -Origin
Thanks you Nils .
(B
(B I truly appreciate how helpful you have been !! I have now got the
(Berror sorted out now.
(B
(BI re-installed MySQL on my Mac OS Jaguar 3 times. Finally the third
(Btime I got it to run. Somehow I had corrupted my User.MYI file
(BI did have to delete the /usr/loca
You need simply add the column predefined as AUTO_INCREMENT and PRIMARY
KEY:
CREATE TABLE incrtest (
name varchar(100) NOT NULL
) TYPE=MyISAM;
INSERT INTO incrtest VALUES("ben");
INSERT INTO incrtest VALUES("bob");
INSERT INTO incrtest VALUES("bom");
INSERT INTO incrtest VALUES("gddo");
INSERT
What about using the username only instead of username@"%" ?
According to manual (section 7.34) it should be identic in behaviour:
[...]
The simple form user is a synonym for user@"%".
[...]
Does it do the same?
Lian
P.S. Andy, sorry for posting by mistake to you. ;-|
> -Original Message-
The TIMESTAMP column type does this for you:
See: http://www.mysql.com/doc/en/DATETIME.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: MaFai [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 11:01 AM
> To: [EMAIL PROTECTED]
> Subject: datetime column dumm
You can change your charset by adding a line in your mysql configuration
file like this.
default-character-set = cp1256
Here cp1256 means that mysql will use Windows Arabic character set. I
don't know the difference between farsi and arabic charsets. And also I
don't know if mysql has a far
You may want to try disabling the index during the insert:
ALTER TABLE table1 DISABLE KEYS;
insert into table1 select * from table2;
ALTER TABLE table1 ENABLE KEYS;
And see what that does.
See: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original
> -Original Message-
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
> Actually, you can create larger files on 32bit Linux systems
> as well. It's
> just that the file system and the C library must have support for LFS
> (Large File Support):
>
> http://www.suse.de/~aj/linux_lfs.html
The problem is that when I only define the "%" host,
then no password is required to log in... (not a
wanted feature!). I CAN log in, i just have to specify
no password.
The password checking is only done for localhost
--- [EMAIL PROTECTED] wrote:
> What about using the username only instea
On Wed, Jun 25, 2003 at 10:09:58AM -0400, Adam Lawrence wrote:
> I am attempting to modify the GRANT table using the syntax specified in the
> MySQL 4.0.13 documentation, and am getting error messages claiming the
> syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
> mysqlc
Does enclosing the username and host in single quotes help?
I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update';
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Adam Lawrence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 8:10 AM
> To:
Sorry the problem fixed itself, and I mistakenly sent this email
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 9:01 am
Subject: Re: CREATE TEMPORARY TABLE
> And what would that b
I'm not sure what errors are being reported to the server. I'm not sure how
to get those. I am not local to the box.
Is there a way to look at the log files without being at the box?
Karl
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Karl J. Stubsjoen'" <[EMAIL
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0
When it installed, it started up mysql, no problems, I could do all mysql functions
I recently rebooted the box, and mysql did not start automatically. I can start it if
I run /etc/rc.d/init.d/mysql start
Is there any know problems why
update is a reserved word in MySQL. Choose another username.
Lian Sebe
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Adam Lawrence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 5:10 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.0.13 GRANT syntax
Something interesting that may be my problem
This is a known working install
# mysql --version
mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
# find /etc/rc.d -name *mysql
/etc/rc.d/init.d/mysql
/etc/rc.d/rc0.d/K90mysql
/etc/rc.d/rc1.d/K90mysql
/etc/rc.d/rc2.d/S90mysql
/etc/rc.d/rc3.d/S
Hi All,
Im a member of a similar PHP email list and posed the question to community about
issues anyone has experienced with being able to connect to MySQL 4.1. Below are my
email and a response. Is this reply statement correct? Why would MySQL break an
interface to clients? Read his com
At 10:55 -0400 6/25/03, Luc Foisy wrote:
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0
When it installed, it started up mysql, no problems, I could do all
mysql functions
I recently rebooted the box, and mysql did not start automatically.
I can start it if I run /etc/rc.d/init.d/mys
Hello,
I have a MySQL server running with some users besides root, that I want to grant all
privileges for their own databases, but no rights for anything else.
So to say, I have a user web01 that shall be able to do whatever he wants with the
database db01. There are more databases, like db02 et
On 25-Jun-2003 Rob wrote:
> Hi all,
>
> Is there any way to do a mysql dump in which each table is dumped into a
> separate file. I know I can use the --tables option to specify a table,
> but this means I have to type out each table name (and there are a lot
> of them). Is there any way to get
Do you have any sort of `shell` access to the box? SSH? Telnet?
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange "Mull" in show fields and table keeps crashing
I'm not sure what errors a
Yes, I turned those runlevels on already and now it works.
The problem is that it was a practically default install, that is the way the
runlevels were set "out of the box"
3.23.56 was this way after install
mysql 0:off 1:off 2:on3:off4:on5:off6:off
3.23.52 was this
I'm attempting to write one SQL statement to retrieve data in a
particular way, and don't seem to be able to do it despite dozens of
attempts (indeed maybe it cannot be done), but wondered if anyone could
suggest anything, such as a function I may have missed that can do it,
or that it simply isn't
Kevin H. Phillips wrote:
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log
Im needing help in installing the fuse server and stuff
email me please if u can help
Hello everyone,
I am new to using MySQL and have installed a copy on my laptop which is
running Windows 2000. I am having an issue with setting up the root user
account. When I ran MySQL for the first time I was prompted to give a
generic user id and password. I did that, but when I run this SQ
At 12:41 -0400 6/25/03, Luc Foisy wrote:
Yes, I turned those runlevels on already and now it works.
The problem is that it was a practically default install, that is
the way the runlevels were set "out of the box"
3.23.56 was this way after install
mysql 0:off 1:off 2:on3:off
I have odd characters in my database that appeared after updating from a
previous database. Most often the characters appear as simple squares where
spaces should be. I've been trying to make a query that will find where all
these characters appear in my table. The SQL looks like this:
SELECT * FR
Hello, all.
As of Friday the 20th, I'm running MySQL 3.23.56-1.72 on Red Hat 7.2, at
which time a consultant overwrote the existing MySQL-3.23.49a /
MySQL-Max-3.23.53a installation.
The server won't start up, and the mysqld.log file reports:
030624 17:24:25 mysqld started
/usr/libexec/mysqld:
Hi,
Since i don't know what is "played for Sussex in two separate spells" --
what's a spell ? (sorry) -- i assume it's a different period of time,
but don't know how to calculate it.
Ignoring the "spell", i did this:
SELECT A.Playerid, A.Teamid, sum(if (A.Substitute=1,0,1))
not_a_substitute, sum(
1 - 100 of 149 matches
Mail list logo
