I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My
office currently keeps track of our projects via an excel spreadsheet. We
keep such info as project costing, status, points oif contact, name,
description, number, last updated, etc... What I want to do is merge all
that info
At 15:30 -0700 10/19/02, John Weez wrote:
How can i limit the number of mysql instances that occur when i start mysql??
It seems to be launching 10 instances of mysql.
You're running Linux? If so, you're seeing threads, not processes.
Thanks, John
---
At 17:28 -0400 10/19/02, Paul Melia wrote:
Hello,
I am newbie to MySQL and I having some problems transferring my
existing data to MySQL. Could someone tell me what I am doing wrong?
I started by exporting certain fields from Filemaker 5.5 to a
comma-separated .txt file. I then opened the file
How can i limit the number of mysql instances that occur when i start
mysql??
It seems to be launching 10 instances of mysql.
Thanks, John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Hello,
I am newbie to MySQL and I having some problems transferring my
existing data to MySQL. Could someone tell me what I am doing wrong?
I started by exporting certain fields from Filemaker 5.5 to a
comma-separated .txt file. I then opened the file in BBedit, deleted
duplicates and made othe
At 5:54 -0500 10/17/02, Terry & Cheryl Haimann wrote:
I was reading a book at B&N yesterday which left me with the
impression that in MySQL you can do the following:
What book was this?
Define a group with specific security access.
Then define a list of users that inherit this groups securit
At 15:16 19/10/2002 +0100, Nikki Mason wrote:
Hi,
Hi,
I wish to learn SQL, and as some of my friends already use MySQL, they
recommended that I too use it. Please can you tell me what I need to
download and install to get me going.
I have:
Pentium III 450Mhz, 256Mb Ram
Windows 98
I don't have a
It sounds like it may be time to look at threads. Set up a thread and open
your recordset there or look at the C or C++ API for MySQL.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's 1st ISP
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday,
Victoria Reznichenko writes:
>
> SELECT COUNT(*) FROM question, listing, user ub, user us WHERE
> question.listing_id = listing.id AND question.buyer_id = ub.id AND
> listing.seller_id = us.id AND (ub.id = 2346 OR us.id = 2346)
> ORDER BY question.last_modified DESC;
>
> +--+
> | COUNT(
At 17:23 18/10/2002 -0400, Fernando Grijalba wrote:
Hi,
You guy recommend that I download the binaries instead of the source code.
In the Win32 version of 4.0.4 is SSL enabled or do I need to download the
source code and apply the flags that you mention in your sort version of the
SSL Documentati
Hi !!!
> Hi all
>
> I'm having a performance problem opening a recordset using a
> CRecordset class (Visual C++). If the table is empty (or
> contains few records) it takes a very little time to open,
> but if the table contains many records (about 48000 in my
> tests) it takes too much time
I can get PHP to work fine, its just the mysql functions...
The PHP setting --with_mysql points to /usr but its installed in /usr/local.
The only way I found to change this is to recompile PHP but then I run into
a multitude of problems for some reason.
If you could send me that, it would be g
Greetings...
In windows, in general the settings are done by default so that you can
start it with the default case.
To start the server go to the bin directory and just enter mysqld. I dont
think you need to enter --standalone or something like that. By default a
root user is created with 'root'
> Does anybody know how I can solve this problem?
> How can I improve the " opening " performance?
> Does MySQL cache something for each records?
It's not a MySQL problem, but a problem how you're opening the recordset.
In VB, you would set the DBSQLPassThru flag - I don't know what the
equivalent
Well, let's start with the simply, yet possibly overlooked solution: have
you indexed the table appropriately?
Mike Hillyer
-Original Message-
From: [EMAIL PROTECTED] [mailto:m.colurcio@;softhor.com]
Sent: Saturday, October 19, 2002 9:12 AM
To: [EMAIL PROTECTED]
Subject: Slow opening a re
Hi all
I'm having a performance problem opening a recordset using a CRecordset class
(Visual C++).
If the table is empty (or contains few records) it takes a very little time to
open, but if the table contains many records (about 48000 in my tests) it takes
too much time (about 20 seconds) to open
Hi,
I wish to learn SQL, and as some of my friends already use MySQL, they
recommended that I too use it. Please can you tell me what I need to
download and install to get me going.
I have:
Pentium III 450Mhz, 256Mb Ram
Windows 98
I don't have a C or C++ compiler installed.
My PC is not connecte
Well, after much fussing around with RPM's and searching this list, I have
resolved my problem.
The clue was the discussion on this list regarding the glibc bug. I upgraded
to the 4.0.x RPM's that I got from the MySQL site and after I got all of the
dependency problems fixed I was able to start up
On Sat, 2002-10-19 at 07:04, Dave Best wrote:
> Anyone have any good information on how to setup PHP and mysql?
[snip]
I followed the instructions from the "Create dynamic sites with PHP &
MySQL" I downloaded from http//www.ibm.com/developerWorks (you have to
register first).
If you want I can m
Can anyone shower light over this problem:
I tried to install mysql 3.32.51. But it throws the following error while
trying to start safe_mysqld:
021019 17:40:10 mysqld started
021019 17:40:10 /usr/local/libexec/mysqld: Can't create/write to file
'/usr/local/var/ibm.pid' (Errcode: 13)
021019 1
Hi all,
I found another solution of a problem with buggy glibc.
Try to start mysqld with --skip-name-resolve
It's work for me fine, but hosts part in security must be only IP addresses,
not names.
Dishko Georgiev
SysAdmin Terasyst Ltd.
---
RG>> I've installed and re-installed MySQL on Windows (binary) multiple times,
RG>> using multiple versions (3.x and 4.x). The reference manual discusses a
RG>> script called mysql_install_db, in the /scripts folder. I can't for the
RG>> life of me find such a script anywhere on my machine.
RG>
Hello.
A note due to lots of reports.
Those of you who has problems running latest binary MySQL with the
latest glibc from RedHat (MySQL crashes when client tries to connect
from remote host) - you can either:
* Downgrade glibc
* Run nscd
That will help.
--
For technical support contrac
Inandjo,
Wednesday, October 16, 2002, 7:54:03 PM, you wrote:
IT> i'd like to know if there is a way to tell the mysqld to remove a thread
IT> that has hang, without human intervention.
IT> Let say an update query is fired to the engine, and the client just freezes
IT> and we have to reboot the ma
Mark,
Saturday, October 19, 2002, 11:57:35 AM, you wrote:
M> Is it true that when I assert a WRITE lock on a table, SELECTS by other
M> threads just wait, instead of fail? I did a test, and this seems to be the
M> case. That would be perfect, really.
Yes, it's true.
--
For technical support c
Deleo,
Friday, October 18, 2002, 1:19:55 PM, you wrote:
DPRJ> I would like to know if someone has the solution to my problem.
DPRJ> I was using MySQL Administrator for Windows yesterday and everything was
DPRJ> working fine (I use dBTools also). Today when I tried to access MySQL
DPRJ> (default v
Douglas,
Saturday, October 19, 2002, 1:08:14 AM, you wrote:
D> INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
D> INNODB: than specified in the my.cnf file!
D> INNODB:Assertion failure in thread 138207232 in file os0file.c
D> send bug report to [EMAIL PROTECTED]
D> mys
Umashankar,
Saturday, October 19, 2002, 8:55:46 AM, you wrote:
UA> I had a problem with mysql. Actually mysql was
UA> accepting a space after a column name, which I think
UA> its not supposed to accept. This problem frustrated me
UA> a lot, it gave a error stating field does not exist.
UA> Eventu
Randy,
Saturday, October 19, 2002, 4:23:31 AM, you wrote:
RG> I've installed and re-installed MySQL on Windows (binary) multiple times,
RG> using multiple versions (3.x and 4.x). The reference manual discusses a
RG> script called mysql_install_db, in the /scripts folder. I can't for the
RG> life
avoigt,
Saturday, October 19, 2002, 5:06:45 AM, you wrote:
>Description:
aatdrdc> Attempting to connect to MySQL Server 3.23.53 (also tested
aatdrdc> with 3.23.51) causes a message to appear on the root console:
aatdrdc> /usr/local/mysql_3.23.53/bin/safe_mysqld: li
Is it true that when I assert a WRITE lock on a table, SELECTS by other
threads just wait, instead of fail? I did a test, and this seems to be the
case. That would be perfect, really.
mysql, query
- Mark
-
Before posting, pleas
31 matches
Mail list logo
