hello,
I want to change the varibale "max_connections" from 100 to 250. how can
I do that? I use MySQL 3.23.52 under Windows XP professional
Is the place I take the set-variable = max_connections=300 wrong?
I have the fallowing my.ini:
=== Begin of my.ini ==
Date: Wed, 18 Sep 2002 05:46:39 -0400
From: [EMAIL PROTECTED]
InnoDB table
Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And
Cod>'059336') Or Nom>'a2618' Order by Nom ASC, Cod ASC Limit 50;
Time:0.08 secs.
Ha
hello
I want to move my database from Oracle to MySql, I am new to MySql.
Is there any documentation listing the important issues involved
in the migration?
thanks,
_
MSN Photos is the easiest way to share and print your photos:
I posted this last weekend, but didn't see it arrive on the list. I'm not
sure if this is because the list software doesn't send a copy to posters,
but, as I didn't hear from anyone, I'm trying again, so apologies if it has
been seen.
I'm fairly new to using MySQL, and need some assistance wi
I made UDFs in vC++ and loaded them on windows binary version of mysql..
They are working perfectly fine
.I think you should specify these following arguments while defining a
function
e.g.
double func_test(UDF_INIT *initid, UDF_ARGS *args, char *is_null,
char *error)
{
re
Have you specified any password for the users--- root or shravan ?
> -Original Message-
> From: Shravan Durvasula [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 12:47 AM
> To: MySQL HELP
> Subject: Server shutdown
>
> Hi all,
>
> I am completely new to MySQL. I ins
At 19:51 -0700 9/18/02, z wrote:
>On Wed, 18 Sep 2002 22:45:29 -0400, Rob Hutton wrote:
>>Is there a way to get MYSQL to alias all fields in a select even if
>>there is
>>no naming conflict? For instance, if I do a:
>>
>>select * from table1, table2 where table1.t1c1 = table2.t2c2
>>
>>then I wan
> I'm considering moving a mySQL dbase off an expensive ISP and in-house to
> host ourselves on OSX Server. Has anyone tried this? Any advice or
> warnings?
http://marc.theaimsgroup.com/?l=mysql&w=2&r=1&s=Mac+OS+X&q=b
(Can't find the official MySQL archives today. Probably not enough sleep
At 5:45 +0300 9/19/02, Hytham Shehab wrote:
>hi guys,
> is it possible to write triggers and procedures in mysql?
Not according to the manual.
http://www.mysql.com/doc/en/ANSI_diff_Triggers.html
>
>
>thx
>sql
>--
>Hytham Shehab
-
At 22:45 -0400 9/18/02, Rob Hutton wrote:
>Is there a way to get MYSQL to alias all fields in a select even if there is
>no naming conflict? For instance, if I do a:
>
>select * from table1, table2 where table1.t1c1 = table2.t2c2
>
>then I want
>
>table1.t1c1 | table1.t1c2 | table1.t1c3 | table2.
On Wed, 18 Sep 2002 22:45:29 -0400, Rob Hutton wrote:
>Is there a way to get MYSQL to alias all fields in a select even if
>there is
>no naming conflict? For instance, if I do a:
>
>select * from table1, table2 where table1.t1c1 = table2.t2c2
>
>then I want
>
would select table1.*,table2.* from
hi guys,
is it possible to write triggers and procedures in mysql?
thx
sql
--
Hytham Shehab
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
Is there a way to get MYSQL to alias all fields in a select even if there is
no naming conflict? For instance, if I do a:
select * from table1, table2 where table1.t1c1 = table2.t2c2
then I want
table1.t1c1 | table1.t1c2 | table1.t1c3 | table2.t2c1 | table2.t2c2
Not just the column names.
Th
HI Paul
Thank you very much!!!
yes it works when I have PRIMARY KEY (SoftwareId, id)
but didn't work for KEY(SoftwareId, id), since this allows to have
multiple entries on the keys, I think
vinita
Paul DuBois wrote:
> At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote:
>
>> HI
>>
>
At 15:39 -0400 9/16/02, Fengling_Li wrote:
>Hi,
>
>Our company will start a new project soon. We might want to use mysql
>database. Now I have a question, does mysql work with VB.NET? if it does,
>could you tell me how ?
Here's some information that may be helpful:
http://www.mysql.com/articles
At 1:32 -0700 9/18/02, neal wrote:
>Is there a wat to have mySQL auto fill in the current date into my
>dateCreated field?
>
>In SQLServer I would simply specify the getDate() method as a default value.
>I presume I would use the analogous MySQL function curDate() but it does not
>appear to work f
At 1:41 -0700 9/18/02, neal wrote:
>If Tomcat is installed and pointing to JDK1.3 but one wants to point instead
>to JDK1.4, is there an easy way to do this?
>
>If so, I'm not finding it. Seems like one would need to completely
>uninstall and reinstall tomcat???
Naw, just redefine the JAVA_HOME
At 10:32 +0300 9/18/02, adi wrote:
> Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30)
>I want to make a sql selection:
>SELECT * from table1 WHERE condition, and after that, to make sum of values
>of column "Duration" and display it.
>Any Help?
>tx
To display as seconds
At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote:
> HI
>
>I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33
>
>This is the definition of table software_machineOSs
>++--+--++-++
>| Field | Type | Null
At 9:30 -0400 9/18/02, Neil Mansilla wrote:
>On Wed, 18 Sep 2002, Rajesh Kanade wrote:
>
>> Hi All
>>
>> I am new to MY SQL .
>>
>> I am writing a script where I will have 2 insert statements
>> The first insert is into a table which has an Auto_Increment field.
>> I want to know the value wh
No,, I dumped the table and put it on a different server and tried it there.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 6:37 PM
Subject: Re: count function issue
> >Thanks but no change.
> >
> >--=C
Hi
Well... I tried all the methodes, tried inserting with out the id,
with NULL id & with 0 as id. No of them seems working :-(
Any other ideas??
Thanks you
Arjen van der Weijden wrote:
>Leave out the id column in your insert-statement
>
>
>
>
Thanks but no change.
--=C
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 5:41 PM
Subject: Re: count function issue
> At 17:26 -0500 9/18/02, McIrvin wrote:
> >OK,, I'll clarify:
>
At 17:26 -0500 9/18/02, McIrvin wrote:
>OK,, I'll clarify:
>
>A query like:
>SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
>count(*)>1 ORDER BY count DESC
>
>Is run on a table built by users searches on a site, so there are lots of
>duplicate entries, were trying to count the
Hi
I have a php script that 'should' get data from a MySQL database and display
it in a web page. When I test the script using 'zend development
environment' the output appears fine, all the data records, html tags and
all.
When I try and run it from a browser I keep getting a parse error as
fo
OK,, I'll clarify:
A query like:
SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
count(*)>1 ORDER BY count DESC
Is run on a table built by users searches on a site, so there are lots of
duplicate entries, were trying to count the duplicates to determine the most
popular searc
I saw the information for upgrading MySQL 3.23 to 4.03
regarding altering table types, etc. If I am using the
Windows release can I just install the binaries etc.
over the existing installation? Will the new install
wipe out the data directory?
Thanks in advance!
At 16:50 -0500 9/18/02, McIrvin wrote:
>Doing queries to determine the number of times search terms are used on a
>web site.
>
>Here is a sample sql query.
>
>SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
>count(*)>1 ORDER BY count DESC
>
>But the results seem to be inaccurat
Thanks for the reply:
The only entry in the .ini file is
Server=C:/mysql/bin/mysqld-max-nt.exe
I did a telnet xx.xx.xx.xxx 3306 from the remote computer and the
conection went through so my computer is accepting from port 3306
This is a dump from SELECT * FROM mysql.user. Does it look right?. I
Doing queries to determine the number of times search terms are used on a
web site.
Here is a sample sql query.
SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
count(*)>1 ORDER BY count DESC
But the results seem to be inaccurate, by no more that 3.
Anyone run into anything
On Wed, Sep 18, 2002 at 10:15:05AM -0400, John Griffin wrote:
> Hi Yuri,
>
> Money talks. Point out that MySQL is an open source initiative and
> can save them money. As for knowing another product, such as MS-SQL,
> being a deciding factor; it really isn't an issue. All databases, at
> their cor
On Wed, 18 Sep 2002, Shravan Durvasula wrote:
|Hi all,
|I have MySQL server installed in Solaris 2.8.
|1. How can i change the existing password for a user?
|2. How can i delete an existing user?
|3. How can i create a new user and associate a
|password for that new user?
I believe the documenta
On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote:
> Hi All;
>
> Is there any way to get a real time queries per second in MySQL as opposed
> to the average given when I request the server status?
Use mytop:
http://jeremy.zawodny.com/mysql/mytop/
That's partly what I wrote it to d
Hello,
I'm sorry for posting this here. I tried the msql-mysql-modules list but
mine was the only message posted within the past few days, so I doubt I'll
be getting any help :)
I am getting the following error while trying to run a perl script to
access some information. DBD::mysql seems to hav
Hi all,
I have MySQL server installed in Solaris 2.8.
1. How can i change the existing password for a user?
2. How can i delete an existing user?
3. How can i create a new user and associate a
password for that new user?
Could anyone please help?
Best regards and thanks in advance,
-skd
___
I can only think that's because you haven't used a Windows system. My
principal client's Windows system has been up for over a year. Win2K Server.
I brought the server down a couple of times to update table structures etc.,
but the OS has never failed us. Not once.
Arthur
- Original Message
From: Mike Hillyer
MH> > Is there any way to get a real time queries per second in MySQL as
MH> > opposed to the average given when I request the server status?
From: Dan Nelson
DN> Request status twice, with a 1-second delay in between.
I think what Mike is looking for is an average across a
In the last episode (Sep 18), Mike Hillyer said:
> Hi All;
>
> Is there any way to get a real time queries per second in MySQL as
> opposed to the average given when I request the server status?
Request status twice, with a 1-second delay in between.
--
Dan Nelson
[EMAIL PROTEC
I tried to use myODBC 3.51 to connect OpenOffice1.0.0 to my MySQL db on
my 'Debian GNU/Linux Sarge' machine. I was able to view tables and
addbut I wasn't able to add new records. I installed the 'stable'
version of the myODBC driver and then it worked. (Same options/programs
other myODBC ver
At 14:00 -0600 9/18/02, Mike Hillyer wrote:
>Hi All;
>
>Is there any way to get a real time queries per second in MySQL as opposed
>to the average given when I request the server status?
"real time" defined how, exactly?
>
>Mike
-
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm not running on OSX Server, but I am running on regular OSX without
any problems. I just downloaded v4 of MySQL and am trying to play with
it on my laptop. I'm getting path errors when trying to run it, but I
haven't played with it much yet. You can download v3 from
www.entropy.ch, which ha
Hello Ryan,
No real problems with Windows 2000 Server and Adv. Server. Install SP3
before MySQL as the SP installation might remove the MySQL service
registration in some cases. The setup process itself is an extremely
straightforward one, taking just two or three minutes. The manual has good
inf
I have it installed on my w2k w/sp3 server and I don't have any problems with it.
-Original Message-
From: Ryan Cavanaugh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 3:23 PM
To: [EMAIL PROTECTED]
Subject: installin mysql on win 2000
I will begining to install mysql o
Hi,
Finally, I installed mysql and php successfully. The mysql commands line run well and
phpinfo(); gives me information.
To do a test to run with php script, I wrote the following script in test.php:
*** Beginning ***
*** End ***
Can you help me resolve the error message below
I tell you that there is a simple script under whatever/mysql/share/ that is
called "mysql.sever" and it manages the mysql server in a very fashionable
way: simply type "mysql.server start" or "mysql.server stop". I use the
script to launch the server when my linux box starts.
Another posibility
if all fails try "killall mysqld" after that you can do an lsof -i
: to see if it is still running,
you have to have lsof package installed dont know if you have it by default
on solaris ..never used solaris b4 :)
ma 2cents
cheers
David Ziggy Lubowa
Network Administrator
One2net (U)
web: www.
I will begining to install mysql on my server in a few days. I have never
done this before. Is there anything i need to know, any problems mysql has
with 2000 server? Any help is appreciated.
Ryan
-
Before posting, please c
Hi all,
I am completely new to MySQL. I installed the source
version of MySQL on Solaris 2.8. I did
"mysql_install_db".
I started the server by saying
"bin/safe_mysqld --user=mysql &". The server started
my creating "mysql.sock" file in the /tmp directory.
Now i
want to stop the server. How s
I was about to email bugs/lists back today to basically say I've found a
reasonable workaround.. I'll respond to your message though in case you see
something that needs attention ...
> strend() is a function we use a lot in the MySQL client code and is
> thus included in the libmysqlclient libra
I've got a weird conundrum here that I'm hoping I can get some help on. I'm
attempting to install a chat board system called Ikonboard
(www.ikonboard.com) with MySQL as the database; setup on it went smoothly
until it tried to talk to the database. No matter what I do, I get:
"mySQL connectio
Rajesh,
Wednesday, September 18, 2002, 9:32:29 AM, you wrote:
RK> I have written 2 scripts the first one which will ceate the schema and
RK> second one will insert some rows into it.
RK> The table type is BDB.
RK> Scripts are something like this
[skip]
RK> If I run these scripts together repea
jwakely,
Wednesday, September 18, 2002, 5:46:19 PM, you wrote:
jamdc> The output of DESCRIBE tbl_name shows unique keys to be "MUL" for columns
jamdc> defined as NULL.
jamdc> The SQL shown is a minimal test case that creates a new database and two
jamdc> tables, both with a unique key on the col
I'm considering moving a mySQL dbase off an expensive ISP and in-house to
host ourselves on OSX Server. Has anyone tried this? Any advice or
warnings?
Thanks!
-Bill
-
Before posting, please check:
http://www.mysql.com/man
Installed version 3.23.45 from a package on sunfreeware.com
Installation was successful. Having a problem creating the priv tables and starting
the myslqd server.
When I try to run ./scripts/mysql_install_db,
the script prepares all the tables, then dies when it is in the process of installi
I am trying to create a user-defined function for mysql. I am using a windows binary
version of mysql and visual c++ to compile the code. I have created a dummy function
call func_test that just returns 1.0. I compile this within a win32 dll project and
get a file called funcdll.dll.
This is
Hello,
I would like to update my slave mysql server which is not within the firewall,
however, the master is. Is there anyway I can do it without opening mysql port in the
firewall. In other words, is there anyway I can make my master update the slave
without slave initiating the request?
Tha
Hi!
> "rafarife" == rafarife <[EMAIL PROTECTED]> writes:
rafarife> Description:
rafarife> Hi Heikki,
rafarife> I'm Lourdes and I work with Rafa in the MySQL project.
rafarife> We have done what you have told us. We have run SHOW STATUS before
rafarife> the query and we have obtained the
Hi,
Can anybody tell me source for getting information on
4.6.3 Adding a New Character Set in MySQL.
I read the manual, it's not clear to me.
The steps there does not give enough information to start.
Thanks,
Bhushan.
-
I must update the same table in two databases from differents remote host
es:
DatabaseA:tableA
DatabaseB:tableA
how can do ? Without using mysqldump if possible...
-
Before posting, please check:
http://www.mysql.com/manua
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria Reznichenko wrote:
| As far as I remember there was found and fixed the similar bug in
| 4.0.3. Could you provide output of SHOW CREATE TABLE for testing?
Hi Victoria,
When you say 'SHOW CREATE TABLE' I assume you mean during the cr
adi wrote:
>I have a table with column1 text type.
>I want to make a sql query:
>SELECT * from table WHERE column1 LIKE condition,
>to select all record that contain numbers(0..9), and do not select records
>that contain only text.
>Any ideas?
>tx in advance
>
>
column1 REGEXP "[0-9]"
--
Ra
I have a table with column1 text type.
I want to make a sql query:
SELECT * from table WHERE column1 LIKE condition,
to select all record that contain numbers(0..9), and do not select records
that contain only text.
Any ideas?
tx in advance
---
Hah!!
Wondering if anyone could tell me of any MySQL specific security vulnerabilities on
win32?
Thanks,
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
>Description:
Currently the manual contains circular references for "EXPLAIN tbl_name",
"DESCRIBE tbl_name" and "SHOW COLUMNS FROM tbl_name".
None of the relevant sections explains the output, they just refer you to
one of the other sections.
If the output of this command *is* described somewher
>Description:
The output of DESCRIBE tbl_name shows unique keys to be "MUL" for columns
defined as NULL.
The SQL shown is a minimal test case that creates a new database and two
tables, both with a unique key on the column "uni"
The first table is fine.
The second table "bug" shows the wrong ou
On Wed, 18 Sep 2002, Rajesh Kanade wrote:
> Hi All
>
> I am new to MY SQL .
>
> I am writing a script where I will have 2 insert statements
> The first insert is into a table which has an Auto_Increment field.
> I want to know the value which was inserted in this Auto_increment field and
> use it
AH..thx a lot everybody!
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]]
> Sent: Mittwoch, 18. September 2002 15:34
> To: [EMAIL PROTECTED]
> Subject: re: Forgot mysql-root password
>
>
> Mario,
> Wednesday, September 18, 2002, 1:50:25 PM, you wrote:
>
> MO> I a
>
>How can i solve this Problem? I have alread reinstalled mysql, but
>unforunatelly i keeps its password.
Reinstall will only work if you remove the database containing the
passwords and users (mysql).
Personally I would prefer the way suggested in the manual.
Bye,
B.
--
Hi Yuri,
Money talks. Point out that MySQL is an open source initiative and can save them
money. As for knowing another product, such as MS-SQL, being a deciding factor; it
really isn't an issue. All databases, at their core functionality, are the same. The
same rules of database design apply
mysqld --user=mysql --skip-grant-tables
Mario Ohnewald wrote:
>Hi!
>I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux
>
>What i did (http://www.mysql.com/doc/en/Resetting_permissions.html):
># rcmysql stop
># mysqld --skip-grant-tables
>Fatal error: Please read "Security" section of th
Mario,
Wednesday, September 18, 2002, 1:50:25 PM, you wrote:
MO> I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux
MO> What i did (http://www.mysql.com/doc/en/Resetting_permissions.html):
MO> # rcmysql stop
MO> # mysqld --skip-grant-tables
MO> Fatal error: Please read "Security" section
Danny,
Wednesday, September 18, 2002, 1:08:23 PM, you wrote:
DH> mysqld got signal 11;
DH> This could be because you hit a bug. It is also possible that this binary
DH> or one of the libraries it was linked against is corrupt, improperly built,
DH> or misconfigured. This error can also be caused
Jay,
Tuesday, September 17, 2002, 10:45:51 PM, you wrote:
J> On my server the MySQL database decided to die on me. So I killed it and
J> restarted and that didn't work. So I just rebooted the machine. Now I'm
J> getting this error below.
J> Invalid SQL: SELECT COUNT(*) AS messages FROM privat
neal,
Wednesday, September 18, 2002, 11:32:39 AM, you wrote:
n> Is there a wat to have mySQL auto fill in the current date into my
n> dateCreated field?
n> In SQLServer I would simply specify the getDate() method as a default value.
n> I presume I would use the analogous MySQL function curDate()
neal,
Wednesday, September 18, 2002, 11:17:49 AM, you wrote:
n> I have a table that will auto increment it's PK field upon adding a new
n> record. I would like obtain that auto-increment value immedicately after
n> the add of that record so that I may reference it within another table ...
n> sor
Hi,
I think Joel Rees wrote an interesting message as well. Hope you read
it.
I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through
ASP/PHP/JSP/Perl DBI. There is no problem as far as I am concerned, it
works without a hitch.
If your default locale is EN, then you may see ju
On Wed, 18 Sep 2002, Mario Ohnewald wrote:
> Hi!
> I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux
>
> What i did (http://www.mysql.com/doc/en/Resetting_permissions.html):
> # rcmysql stop
> # mysqld --skip-grant-tables
> Fatal error: Please read "Security" section of the manual to find
Did you try a straight join so MySQL won't swap the order of the tables?
Philip Smolen wrote:
>Right. The simple example listed at the bottom of this message works great
>under version 4. Version 3 gave the right answer, but it was very slow.
>That made me upgrade to version 4.
>
>However, eve
Hi Bryan;
First I would direct you to the MyODBC mailing list, as it is generally the
place where we VB programmers converse. At any rate, you need MyODBC
installed (check the products heading of the MySQL web site for the MyODBC
download), and your connection string is wrong. I would detail it,
hi ,if you're on windows I would use mysqlfront. It has been
discontinued but you can still get it from:
http://mysqlfront.sstienemann.de/
alternatively, you could use urSQL:
http://www.urbanresearch.com/software/utils/urbsql/
cheers
Rich
David Kramer wrote:
>Can anyone point me in the d
last_insert_id()
-
neal wrote:
> I have a table that will auto increment it's PK field upon adding a new
> record. I would like obtain that auto-increment value immedicately after
> the add of that record so that I may reference it within another table ...
> sort of an informal PK/FK relat
We have build an ASP site in Delphi which heavy relay on a handfull of .dll files
(Active Server Objects)
Its actualy quite hard to define our problem, but I can say that our main problem is
that on simultanius user-connections the dll's appeare to die, or they don't respond.
This problem occo
I followed the advice given but get these errors:
If I use rpm -Uvh MySQL-3-23-52-1.i386 I get;
error failed dependencies
MySQL-server conflicts with mysql-server-3.23.49-3
followed by a list of dependencies on libmysqlclient.so.10
If I use rpm -Uvh MySQL*.rpm I get:
error failed dependencies
My
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| I am writing a script where I will have 2 insert statements
| The first insert is into a table which has an Auto_Increment field.
| I want to know the value which was inserted in this Auto_increment
field and
| use it in the second INSERT statement.
SELECT *,sum(Duration) as durationsum from table1 WHERE condition
should work,
Thomas
On Wed, 18 Sep 2002 10:32:07 +0300 "adi" <[EMAIL PROTECTED]> wrote:
>
> Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30)
> I want to make a sql selection:
> SELECT * from table1 WH
Hi All
I have written 2 scripts the first one which will ceate the schema and
second one will insert some rows into it.
The table type is BDB.
Scripts are something like this
SCRIPT 1
DROP TABLE IF EXISTS ROLE;
DROP DATABASE IF EXISTS ERECRUITER;
CREATE DATABASE ERECRUITER;
#Start using eRe
Hi All
I am new to MY SQL .
I am writing a script where I will have 2 insert statements
The first insert is into a table which has an Auto_Increment field.
I want to know the value which was inserted in this Auto_increment field and
use it in the second INSERT statement.
How can I do it in MySQ
Hi!
I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux
What i did (http://www.mysql.com/doc/en/Resetting_permissions.html):
# rcmysql stop
# mysqld --skip-grant-tables
Fatal error: Please read "Security" section of the manual to find out how to
run mysqld as root!
020918 12:42:39 Aborting
But here you do not specify the --data "c:\Program Files\"
option. The space couldn't be handled by the mysqld-nt exe, I believe it
could have something to do with the fact that it interprets the
arguments as 3 strings instead of 2.
Regards
Tobias
Tobias Eriksson
ComOpt AB
Michael Löfma
Hi!
I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux
What i did (http://www.mysql.com/doc/en/Resetting_permissions.html):
# rcmysql stop
# mysqld --skip-grant-tables
Fatal error: Please read "Security" section of the manual to find out how to
run mysqld as root!
020918 12:42:39 Aborting
On Tue, 17 Sep 2002, Tam,Aaron wrote:
> I'm installing the mysql-max-3.23.52-pc-linux-gnu-i686 version. But I don't
> have the root permission, and don't have the /var/lib/ access permission.
> And I got the following error when I ran the ./configure commend. Do anyone
> know how to change the
> This is for anyone out there storing Japanese characters along with
> English characters.
Hi.
> SUMMARY:
> The client recently requested that Japanese be stored in an otherwise
> standard English (Latin) MySQL database. Whereas all rows in the table
> used to be Latin only, now some rows sto
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello All,
Hope somebody can shed some light on this as i think my torch is running
out of batteries ;-)
I have two mysql 4.0.1 servers on two 1Ghz athlon boxes (which are both
running on Mandrake linux 8.2). Our main server has been bulked
Description:
Hello Monty,
I have already sent to pub/mysql/secret the table definition and data (clientes.txt)
and my.ini file in a compressed file named clientes.zip.
You can import clientes.txt and test it.
I have only then problem with InnoDb tables.
I tell you my test
Check TIMESTAMP type in the documentation.
Best regards,
Mikhail.
- Original Message -
From: "neal" <[EMAIL PROTECTED]>
To: "mySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 10:32 AM
Subject: date field - default value = current date
> Is there a wat to have mySQL auto fi
Perhaps you should create a new table with an id column and a flag
column.
Select the found calls > 5 or <= 5 into that new table and set the flag.
Then do a left join of your t_callog_calls table on the new table
selecting only the rows where the flag is NULL, these should be the rows
not found b
Hi!
> "rafarife" == rafarife <[EMAIL PROTECTED]> writes:
rafarife> Description:
rafarife> Hello,
rafarife> I am working with mysqld-max-nt under windows 2000 and unsing InnoDb
rafarife> tables.
rafarife> I have the following table:
rafarife>I don´t understa
Hi!
> "Ben" == Ben Goodwin <[EMAIL PROTECTED]> writes:
Ben> There are probably other functions that need to be made private, too.. but
Ben> this one's directly affecting me.
Ben> I'm writing a shared library that loads libmysqlclient; When Solaris 'csh'
Ben> uses said library, there's a cla
Hi!
> "Sergey" == Sergey S Kostyliov <[EMAIL PROTECTED]> writes:
>> Description:
Sergey> Server hang when trying to test field=AES_DECRYPT(filed, key)
Sergey> in case when filed contain garbage.
>> How-To-Repeat:
Sergey> CREATE TABLE atest(
Sergey>
1 - 100 of 111 matches
Mail list logo
