hay guyz
im a bit stuck
first i couldnt get any user but root to log into mysql
on command prompt and myadmin
now i can ,et my user to log in through command prompt but i get this weired
error for myadmin
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
these are linux machines on internet, one is web server and another db
server, with real IPs. but I may optionally want to export data to my PC,
also on internet connected through LAN to my web server and db server.
thanx for ur time
Nitin
- Original Message -
From: Christensen, Dave
I still have this problem with replication, and i dont know how to fix it.
I have a slave that has been running for a long time without any problems,
but now its not replicating any more. So I tried to do a LOAD DATA MASTER;
which always gives me this error now:
Version: '4.0.15-standard-log'
Jose Rojas [EMAIL PROTECTED] wrote:
I have installed Mysql 2.23.56 in Linux (Cobalt), but when it is started shows the
next messages in the ../var/*.err file:
mysqld started
/home/mysql/libexec/mysqld: File './dns1-bin.1' not found (Errcode: 13)
031008 15:18:16 Could not use dns1-bin
Hi group,
I recently asked about Compression and security and got nice answers.
Now I have got a different question:
What are the disadvantage of using that client/server Compression protocol?
Does it increase speed? Does it decrease speed? Does it overload the server? The
client?
Any ideas
Hi Taylor
While I have only used mysqldump to backup MyIsam files, I have found the
process to be fairly painless. Mysqldump creates batch f iles which
effectively rebuild your database structure + database data. To restore the
data all you need to do is run the backup files as a batch file i.e.
Hi Toby
I am not an expert on permissions within mysql - boy, do I wish I was - but
could the problem be that you have only granted permissions to
[EMAIL PROTECTED] and not '[EMAIL PROTECTED]' ?
Here endeth my knowledge of MySQL permissions
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL
thnx rory
the thing is kwexchange is localhost you know .
so it should work
alwayz has before this dammed day .
anywayz .
i did install mysql on another machine and installed all the rest , php,
apache, phpmyadmin on another
when it gave me these access denied errors
the
Hi toby
If I log in to mysql via the command line on the hosting machine it says
[EMAIL PROTECTED] ... therefore, stating the obvious :) it doens't think you're
connecting from localhost - this may be because of the two NICs but I don't
know enough to be sure .when you connect to the mysql
Hi !
Are sub-selects supported by MySQL 3.23.58, because below query does not
work (syntax error in console):
select iphdr.ip_src, timestamp \
from iphdr , acid_event \
where iphdr.sid = acid_event.sid \
and iphdr.cid = acid_event.cid \
and acid_event.sig_name = STATEMENT \
and
Hi!
On Oct 07, Dathan Vance Pattishall wrote:
I have to drop the FULLTEXT INDEX added to a set of dbs containing a
TEXT field with an average of 6K of text added to each row, at a growth
of 250K rows added a day to a set of 100 tables. The reason for the drop
is due to table corruption and
No, its supported by version 4.1
gr.
- Original Message -
From: boka [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:54 AM
Subject: MySQL 3.23.58 and sub-seletcs
Hi !
Are sub-selects supported by MySQL 3.23.58, because below query does not
work (syntax
Hi boka
Nope sub-selects to my understanding ar only supported from version 4.1
onwards (still in beta I think)
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original
Bob Brands wrote:
No, its supported by version 4.1
MySQL 4.1 -- Alpha release (use this for new development) ... is this
stable enough to use it on production systems ?
btw. is there any workaround for this functionality in 3.23.58 ?
greetz
boka
--
MySQL General Mailing List
For list archives:
Thank you for the ideas. Very helpful.
Thanks
Emery
- Original Message -
From: Danny Haworth [EMAIL PROTECTED]
To: Director General: NEFACOMP [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:01
Subject: Re: Ideas on Compression Protocol
We used compression on a project with about
Hello,
This sql query works fine with mysql 4.0.15, but it gives an error with
mysql 3.23.49:
SELECT officiele_naam, rechtsvorm, activiteit1, activiteit2, adres, postnummer,
gemeente, Biogarantie, Hefboom, Netwerk_Vlaanderen, Vibe, Fair_Trade, NULL , Vosec,
Solidr, Demeter, Europees_Ecolabel,
I have posted the message with the subject Serious problem with
replication, but nobody seems to know what to do?
Now I have even tried to completly uninstall MySQL (with rpm -e), delete the
/var/lib/mysql dir, and reinstall MySQL with rpm -i
MySQL-server-4.0.15-0.i386.rpm.
Then I create my
Thanks for your help, just what I needed.
I will play around but if you have a chance and know how, how would I order
the results by count? (ie. highest counts first..)
-Original Message-
From: Mike Knox [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 5:09 AM
To: '[EMAIL
Hi, I have a page on a intranet where workers can insert data into a
database, the thing is that when they type the info an press submit the page
use the INSERT INTO db then when i check the data in the database i can
see the record that the user entered and a second record that is all in
--
mysql select * from msg where Author=6213 and (Saved='s' or Saved='n')
order by ID;
Empty set (0.00 sec)
---
mysql select COUNT(*) from msg where Author=6213 and (Saved='s' or
Saved='n') order by ID;
+--+
| COUNT(*) |
+--+
| 191 |
+--+
1
Emilio,
Can you supply the full insert statement? Also, is this happening for all users, or
one in particular? I ask, as I've seen issues with web app users double-clicking the
submit button causing similar issues
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL
I am running it on a production server for about two weeks. So far it has been very
stable.
--ja
On Thu, 9 Oct 2003, boka wrote:
Bob Brands wrote:
No, its supported by version 4.1
MySQL 4.1 -- Alpha release (use this for new development) ... is this
stable enough to use it on
Charles Warren [EMAIL PROTECTED] wrote:
I've searched the manuals and any websites I can find but am still at a loss
on how to calculate what I thought was going to be an easy 'Average' of Call
Times.
Situation. Have a table which is updated daily for users metrics and have
configured
Hi,
can you indicates your configuration about :
- my.cnf
- all tables type your using in the master (MyISAM, INNODB, BDB)
This may help to see what goes wrong .
Regards
Thierno 6C - MySQL 4.0.15
- Original Message -
From: Søren Neigaard [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Here is my my.cnf (had to zip it, my Windoze would not let me attache
it??).
As far as I know, im only using MyISAM (thats the standard version
right), but how do I check this?
Best regards
Søren
-Original Message-
From: Thierno Cissé [mailto:[EMAIL PROTECTED]
Sent: 9. oktober 2003
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is
the server won't start and there don't seem to be any logs available to help diagnose
the problem. I've tried both
sudo safe_mysqld
Starting mysqld daemon with databases from
[EMAIL PROTECTED] wrote:
--
mysql select * from msg where Author=6213 and (Saved='s' or Saved='n')
order by ID;
Empty set (0.00 sec)
---
mysql select COUNT(*) from msg where Author=6213 and (Saved='s' or
Saved='n') order by ID;
+--+
| COUNT(*) |
sending on to list while I think... ;)
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:34 AM
To: Dan Greene
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Ok, here it is the full statement:
Hi,
I wanted to add some new user defined functions (UDF) to mysql 4.0.12-standard-log.
I read in the manual that it is possible if you can start with the option
--with-mysqld-ldflags=-rdynamic.
Then I found that my distribution is most likely build with --disable-shared, which
makes me believe
James,
Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?
So you're doing the following
# (1) Going to the mysql directory.
cd /usr/local/mysql
# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
are you doing this insert in any sort of loop? if you emailed yourself the
final query, or printed it on the screen and then ran it directly into
mysql...do you get the same results?
Jeff
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Trouble acquiring proper AVG with TIME
Date: Thu, 9 Oct 2003 17:24:14 +0300
Charles Warren [EMAIL PROTECTED] wrote:
I've searched the manuals and any websites I can find but am still at a
loss
on how to calculate what I
Adam,
Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's
not running:
1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
2. when I issue ps -auxww|grep mysql I
Hi,
i suppose you do the necessary GRANTS on the master (before executing LOAD
DATA FROM MASTER) as :
- file
- super
- reload
- select (on all tables you want to load)
If not do this, and try again
You can check if you are using only MyISAM tables with the client console by
:
show table status
I want to ask you one thing:
Is your Crystal Report accessing the database through the Mascon Utility
or it uses MyODBC?
I think the main problem to me is how Crystal Report is accessing the
database.
I will try to access the database using ADO and see if there is any change.
Thanks
Emery
Hello All,
I have two system, we shall call then system A (OLD) and system B (NEW), running
MySQL that I want to combine their tables. The system B is the newer and most
accurate. The table structure is the exact same. Some of the rows in system B (NEW)
tables are also in system A (OLD). For
Hopefuly someone will be able to save me, before I destroy my system too bad. I am
trying to compile mysql 4.1.0 alpha with openssl support. I know I have everything
needed installed on my system, gcc 3.2.2, and two copies of openssl. I originaly
tried installing with the rpm, to hopefuly be
Emilio-
I ran into this problem just yesterday using some PHP code. The problem was in
control logic. I executed the insert within an if statement, but failed to see
that there was another mysql_query statement outside the if block. This caused
the same insert to happen again.
Basically, in
James,
Yea, I have to agree its not starting.
Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is
As I read the documentation, ALTER TABLE my_table DISABLE KEYS only
works on MyIsam tables. When I run the command against an InnoDB
database, however, I get no indication of a problem. I get the usual
Query OK message. So, can I temporarily disable keys on an InnoDB
database (say while doing a
I'm trying to move a bugzilla database from a MySql 3.23.54 - 3.23.56
database on a new machine.
I have exported the database with the following
mysqldump -u root -pPASSWORD --add-drop-table bugs bugs.dump.sql
moved the file to the new machine and done
mysql -u root -pPASSWORD bugs
Crystal was pulling the data through MyODBC, Mascon was just used for
inserting the image into the database.
hth
danny
On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote:
I want to ask you one thing:
Is your Crystal Report accessing the database through the Mascon Utility
or
Hello
I am developing a small program for a small computer firm.
Now I wonder when I have to buy the corporate licens?
And when to use the free GPL-licens one.
My application ´saves some data in the database and I have done NO change in the
cource code of the free version of MySQL.
Should I
Adam,
Well, you were right about there being logs :) (I hadn't looked into the data dir
since it required root and I was reluctant to setup a root user--live and learn.)
031009 11:12:10 mysqld started
031009 11:12:11 InnoDB: Operating system error number 13 in a file operation.
InnoDB: See
I am developing a small program for a small computer firm.
Now I wonder when I have to buy the corporate licens?
And when to use the free GPL-licens one.
http://www.mysql.com/products/licensing-examples.html
You need a license if you sell a product designed specifically for use
with MySQL
Hello, list,
What is a good setting for max_connections on a Windows machine with 1GB
RAM, Dual Athlons, RAID, etc...
The default of 100 seems a bit lean, we would like to increase this number,
but don't have any experience history with MySQL to draw upon.
The docs say that 500-1000 is good
I installed all the stuff as root, so /home/mysql and beyond are root owner
and group. Should I have to change to mysql user and group?
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 2:57 AM
Subject: Re: Errors
Hi guys,
Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15?
If so, are the main advantages of using INNODB tables the added features
of transactions, cascading deletes, and it's other more robust features?
Any thoughts on any disadvantages of INNODB to MyISAM? I know that
hello,
Im writing a db software using delphi7 mysql(3.23.41) (with standard dbexpress and
data access components)
The problem is: sometimes i get the error message unable to execute query, and the
connection breaks.
i only saw this occur on UPDATEs or INSERTs, but every time a different line
The online manual at http://www.mysql.com/doc/en/Replication_Options.html
says that these two variables:
max-relay-log-size=#
relay-log-purge=0|1
exist to control the size of the relay log. But when I try to start my
slave server
with:
set-variable = max-relay-log-size=192MB
set-variable =
On Thu, Oct 09, 2003 at 01:23:39PM -0400, Don Vu wrote:
Hi guys,
Do both MyISAM tables and INNODB tables support foreign keys in
4.0.15?
No.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 25
Adam,
Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything
special when I downloaded and installed the latest version. I assumed that anything in
need of doing would be taken care of during package install. I guess that was just
wishful thinking. I'll make the
Sounds like a plan. Actually, MySQL ships with OS X Server - sounds like
your using the desktop version, which doesn't include it.
Over lunch I threw 4.0.15 on a G4 running 10.2.6 - love that new installer.
I had no issues.
- Downloaded it.
- Ran the installation package
- kicked-off MySQL via
This is probably my mistake somewhere, but perhaps someone
could shed some light on the matter:
I have an app, compiled with the mysql c apis, that
is leaking memory. I know this by fine-tuned debugging
using mallinfo.
The memory that is being leaked is allocated by calls
to mysql_real_query(),
Hmm, that is weird. Actually, I had the same issue (sort of). I was grabbing
some data from a MySQL instance on an OS X workstation. I had shared the
tables in Access via ODBC. I'd start to update the MySQL DB and get an ODBC
error. Usually I'd get about 93 rows done (out of 1000 or so).
You're
Pako,
That blows my theory.
Regards,
Adam
-Original Message-
From: Pak Gza [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 2:32 PM
To: Fortuno, Adam
Subject: Re: Error: unable to execute query - Problems using Win32 MySQL
ODBC driver
i dont use odbc. i only need
Adam,
It works! I also had to run the initialization script...
Thanks very much for the help.
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE:
procs memoryswap io system
cpu
r b w swpd free buff cache si sobibo incs us
sy id
0 1 0 5232 93140 26732 3736888 0 0 157510 388 343 11
1 88
0 1 0 5232 88552 26748 3741348 0 0 892 6 327 269
At 12:23 PM 10/9/2003, you wrote:
Hi guys,
Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15?
If so, are the main advantages of using INNODB tables the added features
of transactions, cascading deletes, and it's other more robust features?
Any thoughts on any disadvantages of
Is there one that's especially outstanding?
Thanks,
jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
usually, to release memory is used mysql_free_result().
You do that ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
On Thu, Oct 09, 2003 at 03:03:59PM -0400, Anderson, James H [IT] wrote:
Is there one that's especially outstanding?
I haven't read it front to back, but I have an affinity for New Rider's
MySQL by Paul DuBois. (It's where I picked up PHP, and has been a useful
reference for me these days, as
Are there any SQL injection threats for MySQL less than 4.1?
Dwight Trumbower
T Systems Corp
Custom Database Solutions
[EMAIL PROTECTED]
920-667-4438
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all
I am new to the programming world so please forgive!!!
Would like to get to get my hands on any info (Tutorials and such) to
help me on me way whith SQL and Php
Would appreciate any help... links / text / whatever...
Thanx
Casper
South Africa
Casper Matthee
Consultant
IT3
As I understand it, and I confess I am not totally sure I do, sql injection is more of
a problem in your page code than what database (/version) you run.
--ja
On Thu, 9 Oct 2003, Dwight Trumbower wrote:
Are there any SQL injection threats for MySQL less than 4.1?
Dwight Trumbower
T
MySQL the definitive guide to using, programming, and administering
mySQL, version 2 by
Paul Dubois, who is active on this list.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Anderson,
Goto www.devshed.com some nice resources there, from introductions to
advance topics.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Casper Matthee [mailto:[EMAIL PROTECTED]
--Sent:
I think I got it
What look like what is happening happening is that your page is running the insert
when you present the form to the user, which is why the php variables are empty. when
they submit the page, you are inserting the correct values. To test this, load the
page up, do not
At 02:03 PM 10/9/2003, you wrote:
Is there one that's especially outstanding?
Thanks,
jim
--
Jim,
MySQL Cookbook also by Paul Dubois is also a good read. I got both
books (including MySQL 2nd Edition) at a 30% discount off the list price
plus another $10 off with a coupon plus free
You need a license if you sell a product designed specifically for use
with MySQL or that requires the MySQL server to function at all.
Actually, could someone from MySQL clarify this bit for future reference?
If my application includes a standardized method of access such as ODBC, or
provides
Cheap books - http://www.bookpool.com
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 4:16 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: Re: Which is the best MySQL book?
At 02:03 PM 10/9/2003, you wrote:
Is there one that's
\As I understand it, and I confess I am not totally sure I do, sql injection is more
of a problem in your page code than what database (/version) you run.\
Absolutely. As I show at http://www.vbmysql.com/articles/sqlinjection.html SQL
Injection is a flaw in the front-end code, and you are at
I recently got a redhat 9 server with mysql
3.23.54-log (what does the -log mean BTW?). Every time
I start mysql it maxes out the cpu in a few minutes.
Nothing is even connecting to mysql at this point, and
SHOW PROCESSLIST doesn't show anything (except it's
own query). Any idea what the problem
I am running MySQL 4.1 in a sandbox, trying to test some code against it.
No matter what, even when no value is explicitly applied, or the field is
not explicitly named in a SQL statement, the TIMESTAMP column refuses to
update.
I have tested this with several programs written in 3 different
At 14:53 -0700 10/9/03, Scott Brown wrote:
I am running MySQL 4.1 in a sandbox, trying to test some code against it.
No matter what, even when no value is explicitly applied, or the
field is not explicitly named in a SQL statement, the TIMESTAMP
column refuses to update.
I have tested this
Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of
a row that was just inserted? I'm using PHP, I don't know if that makes
a difference?
Something like:
INSERT INTO foo (bar) VALUES (bar);
SELECT last_insert(id) FROM foo;
Also, are there any problems with using this in an
Here's the link to the on-line manual page that will help you.
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 5:06 PM
To: [EMAIL PROTECTED]
Subject: Getting the value of a row you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 09 October 2003 06:06 pm, Dan Anderson wrote:
: Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of
: a row that was just inserted? I'm using PHP, I don't know if that makes
: a difference?
:
: Something like:
:
:
Hi
I have used other relational databases but am new to my sql. Where can
I find documentation on how to connect my database to a web page?
Thanks
Hi
I have used other relational databases but am new to my sql. Where can
I find documentation on how to connect my database to a web page?
Thanks
---Original Message-
--From: Dora [mailto:[EMAIL PROTECTED]
--Sent: Thursday, October 09, 2003 3:18 PM
--To: [EMAIL PROTECTED]
--Subject: web interface...
--
--
--Hi
--
--I have used other relational databases but am new to my sql. Where
can
--I find documentation on how to connect my
DROP TABLE IF EXISTS t;
CREATE TABLE t (ts TIMESTAMP, i INT);
INSERT INTO t (i) VALUES(0);
SELECT * FROM t;
At this point, the timestamp field is un-interpretable. SELECT returns
-00-00 9:01 AM
UPDATE t SET i = i + 1;
SELECT * FROM t;
Returns the same thing; -00-00 9:01 AM. JFYI, none of
There are about 1000 people on this list that can put a web front end for
you
Something to think about..
-Martin Gainty
- Original Message -
From: Dora [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 6:21 PM
Subject: web interface...
Hi
I have used other
Thank you. I'd like to do it myself though.
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 6:40 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: web interface...
There are about 1000 people on this list that can put a web
Martin Gainty wrote:
There are about 1000 people on this list that can put a web front end for
you
Something to think about..
-Martin Gainty
Who am I missing? I only counted 997.
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
What are your thoughts?
Thanks
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Thursday,
PLEASE, I'M A STUDENT AND I´D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE
CONFIGURATION TO RUN MYSQL SERVER. THANKS.
_
Voce quer um iGMail protegido contra vírus e spams?
Clique aqui: http://www.igmailseguro.ig.com.br
Ofertas
On Thu, 9 Oct 2003 18:41:42 -0400, Dora [EMAIL PROTECTED] wrote:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
Add PHP to your list of skills. There is so much documentation
on
Dora wrote:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
What are your thoughts?
Thanks
PHP... http://www.php.net
And if PHP isn't doable, Perl.
--
By-Tor.com
It's all about
Dont worry
The indians will put 3 more of us out of work by tommorrow am!
-M
- Original Message -
From: John Nichel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 6:45 PM
Subject: Re: web interface...
Martin Gainty wrote:
There are about 1000 people on this
On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote:
PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE
CONFIGURATION TO RUN MYSQL SERVER. THANKS.
I think this depends on how big the database will be, how much it will be
hit, etc!!!
I've heard of MySQL
If the are a UNIX CGI plant then they probably run PERL which then you
can use DBI; this is much different then writing HTML since PERL by
itself can't include raw imbedded html. So, I suggest using PHP it
should be easier for you to make a transition to then a pure old fashion
CGI script.
Look
So, we just got this handy dandy new G5 with 4GB of RAM and I'm trying
to get it to store as much of our 4.3GB database in RAM as possible.
I've tuned most of the usual parameters (query cache, tmp table size,
sort buffer, key buffer, record buffer, table cache, myisam sort
buffer, etc.) but
I am a new mysql user. I am installing MySQL for the first time on my mac. I
need to set a password for the 'root' user by using the following 2
commands:
/usr/local/mysql/bin/mysqladmin -u root password password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password
The first
I've been searching the Lotus site and have gotten kind of lost. Does
anybody have any experience using Lotus Notes as a front end to a MySQL
database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I
barking up the wrong tree?
Thanks.
Randy
--
MySQL General Mailing List
For list
Hi Gabriel,
No, you can't currently modify compressed tables.
For in memory tables, are you aware of the HEAP type for non-critical
data?
You're probably talking regular permanent tables, though. For those, the
OS will use all free memory (that programs aren't using) to cache file
data after
sorry for this late reply rory
i just got back to work ..
i am trying to connect to 192.168.x.y
but the jerk connects to 192.168.xx.xxx
the other ip
yeha it connects to an ip . not the loop back adrs
am i supposed to connect to loop back adrs thinggy ?
im all screwed with
Hi,
I have the following statement:
echo $tenureidP;
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid';
$result =
Hi All,
I have some doubts regarding Mysqlbinlog. Does Mysqlbinlog support this
usage?
mysqlbinlog --user=root --host=127.0.0.1 master-bin.001.
I am repeatedly getting errors like master-bin.001 file not found in
Linux . When I give the full path of the master-bin.001 its working.
There is a
On Thu, 2003-10-09 at 16:33, pete M wrote:
$new_id = mysql_query('select last_insert_id()');
your can also user it within a query - eg
$sql = ' insert into related table parent_id, data , data2) values
(last_insert_id(), 23, 45);
Is there also a similar way of getting the last error
100 matches
Mail list logo