Sanjeev Adhyapak wrote:
> We have installed redhat 7.0 server on one machine and want to run mysql
> server on that. The installation is default. After that only the root is
> allowed to connect to the server and if login as different user i am
> getting the error as error 111 connection refused.
If mysqlserver is not installed on your computer then
first try to connect remote host from mysql client.
mysql -h 192.168.0.1 -u root
if you can connect via this way then
odbc can resposible about this situation.
But i don't think so.
Problem is about permissions to remote clients.
If not prob
Try to dump your database from Linux first.
Then put them into Windows via ftp.
Then import it into a Windows.
> I am using MySQL on windows platform. How can I port mt datas from MySQL
> server on windows to MySQl server on Linux?
>
> Thanks for all.
>
Hi
I just downloaded MYsql for windows NT. I'm running it on Windows2000
Advanced Server. Everything loads fine and it is running ok but, when I
try to run Winmysqladmin the program loads up for only about 2 seconds
and then closes. Any ideas on what I need to do?
Thanks
Joe
---
Expected behaviour, look in your Tray on the Taskbar for a stoplight icon.
Pat...
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 17, 2001 6:12 PM
Subject: Help Needed
> Hi
>
> I just downloaded MYsql for windows NT. I'm running it on Windows
Hello Pat
Well, I really feel stupid! Under the gun with this any I really don't
have a clue. I also need to install some type of DBI foe windows2000
advanced server too and I'm now downloading a perl file off of
mysql.com. I really have no idea working with windows. My main OS that I
have been w
On 17-Mar-2001 Greg Cope wrote:
> Michael Widenius wrote:
>>
>> Hi!
>>
>>
>> Greg> On the off chance any ideas when this (A Gemini THandler) 3.23.x
>> release
>> Greg> may be and when we might see a public 4.x alpha. I know the answer
>> will
>> Greg> probably be "When its ready" but a small
Summanen,Jack writes:
> Umm I went looking for libz.a under which subdirectory? I checked lib and
> gnu, and no libz.a unless I am looking in the wrong place.
>
>
>
Look for zlib.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*
Clyde Lewis writes:
> Hello,
>
> I was able to download the .gz file, but was not able to go any further
> with the installation. Is there an installation guide available online.
> Looking forward to using this tool.
>
>
> **
Cal Evans writes:
> Other than the (sparse) documentation in the manual, is there any other
> documentation available for INNOBASE files?
>
> Cal
> http://www.calevans.com
>
>
Hi!
Try :
http://www.innobase.fi
Regards,
Sinisa
__ _ _ ___ == MySQL AB
Hi all,
I have a query in my program which is taking to long when I get data in the
database. I'm currently testing with ~40.000 articles in the system.
The query which I'm using is (takes about 2 secs ):
SELECT Article.ID as ArticleID
FROM eZArticle_Article AS Article,
On Fri, 16 Mar 2001, Daniel Soto Armijo wrote:
> ¿Why the user interface of MySQL is very difficult? ¿Why is not more
> friendly like MS SQL Server user interface? I tried to use and configure
> MySQL and I get nothing.
H. I'll probably get flamed for this, but you wouldn't
be using eithe
BlankI never found one so I wrote a simple FoxPro program that opens the MS
SQL database and builds a file similar to what mysqldump would build. If
you find a generic tool please post the URL!
Cal
http://www.calevans.com
-Original Message-
From: Michael Blood [mailto:[EMAIL PROTEC
Cal,
I will write more documentation during the week beginning 19th of
March, and post that to my website at www.innobase.fi. It will
also appear in the MySQL online manual at www.mysql.com, but
even sooner at my website, since I do not control the version
of the MySQL manual shown at www.mysql.c
Hi,
I' trying to use MySQL Gui 1.7.4 and keep getting the following error:
>>Can't connect to local MySQL server through socket '' (111) <<
I'm using Redhat 7.2 and have tried it with the semi-static and the static
versions of MySQLGui. Connecting to the server with mysql is no problem.
I'm usi
Thanks for the reply but I'm not seeing any useful documentation.
Specifically, is there a comprehensive list of all the my.cnf settings along
with a detailed explanation of what they mean? Or is the one in the MySQL
manual complete?
Also, is there a tutorial or some sort of list of steps necessa
Cal Evans writes:
> Thanks for the reply but I'm not seeing any useful documentation.
> Specifically, is there a comprehensive list of all the my.cnf settings along
> with a detailed explanation of what they mean? Or is the one in the MySQL
> manual complete?
>
> Also, is there a tutorial o
Thomas Schwerk writes:
> Hi,
>
> I' trying to use MySQL Gui 1.7.4 and keep getting the following error:
> >>Can't connect to local MySQL server through socket '' (111) <<
>
> I'm using Redhat 7.2 and have tried it with the semi-static and the static
> versions of MySQLGui. Connecting to
I have remote access to a MySQL database. I would like to be able to
"download" a table or portions of a table to my local computer so as to work
with the data using other tools for simple data manipulation. Can this be
done? How? Any tips or pointers in the right direction would be greatly
ap
Mark,
That's not really that way you work with RDBS engines. It's not a desktop
database like Access or FoxPro. (mmFox Pro!)
What is the problem you are trying to solve? Is the remote connection too
slow?
You can always use mysqldump to create a MySQL script that will rebuild the
datab
1) How do I give access to other users in MySQL?
2) How do I give access to tables to other users?
3) How do I create another database and then give access to that database to
other users?
I can get into the test database as user x
but I can't get even get an access error when trying mysql wit
Check the manual for the GRANT command. It holds the secret that you are
searching for. :) You can use it to grant specific rights to databases or
tables within databases.
Once you have granted rights for a user, then use
mysql -u username -p
the -p is only necessary if the user you are trying
I've benchmarked a few scenarios to load mysqldumped data into an
innobase-table (about 27 columns, mostly int's and float's) with about
150.000 rows with primary key and an additional unique key. The mysqldumped
data was generated one insert per row (not dumped with --extended-inserts).
1. cat t
Hi,
I am trying to set up a passsword a system root for the root MySQL
server
for the 1st time (rpm download) & I get the following error message:
[root@localhost MySQL]# /usr/bin/mysqladmin -u mysql -p password
'x1234!'
Enter password:
/usr/bin/mysqladmin: connect to server at 'localhost' faile
On Sat, Mar 17, 2001 at 06:56:34AM -0500, [EMAIL PROTECTED] wrote:
>
> On 17-Mar-2001 Greg Cope wrote:
> > Michael Widenius wrote:
> >>
> >> Hi!
> >>
> >>
> >> Greg> On the off chance any ideas when this (A Gemini THandler) 3.23.x
> >> release
> >> Greg> may be and when we might see a public 4
Andy,
thank you for your benchmark :). I was also going to measure these,
but have not had time yet. But what parameters you used in
my.cnf? You have a lot of RAM in your system, and you could make
the Innobase buffer pool big.
>I've benchmarked a few scenarios to load mysqldumped data into an
>
Hello guys
Does anyone know where I can get the MySQL-DBI-perl-bin RPM distribution
(version 3.23.17-1.i386). I'm running a RH6.0 box.
Thanks a lot
*Wilmar Pérez
* IT Department
* Libraries System
*Un
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Rolando Roman
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Rolando Roman
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
I am trying to compile mysql on a 233 AMD. The video adaptor is:
Description: S3 86C764_1[Trio 32/64 vers 1]
Manufacturer: S3 Inc
Device: Unknown
Driver: XF86_S3
PCI Information:
Vendor ID: 0x5333
Card ID: 0x8611
Slot Number: 4
PCI Information: 0x5333,0x8611,4
The ves
try microsoft msdn web site at :
http://msdn.microsoft.com
see properties opening your odbc connection in exclusive mode/or not.
Regards.
- Original Message -
From: Wojciech Spychała <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 11:14 AM
Subject: ODBC troub
Hi,
I am having problems with my query trying to call a list of interests.
When someone signs up too the site they choose 7 different interests
from a list and it can be in any different configuration. I am having a
hard time getting it to query, and amy getting this error message:
SELECT
clien
Hi!
I exchanged some emails with Cal and he got his database running
today.
If you have repeating problems with creating the Innobase database,
check that you have deleted all Innobase data files and log files,
also a possible small archived log file, before trying the database
creation again. F
hey,
i'm running serveral mysql servers on powerful
machines - dual processor, 2 GB memory, etc... Most of
the databases store temporary data only. I need the
maximum performance from these servers and have a lot
of connections to the database.
My problem is this - whenever the number of qu
Greg,
I think mysqldump and import work for all table handlers in the same
way in MySQL. But to get the maximum performance, there are some optimizations
available.
Andreas Vierengel measured that using autocommit=0 makes the import
much faster for Innobase. You have to issue a commit after you
Hello
I've compiled mysql-3.23.35 with innobase support - it runs much
better than BDB for me - and run a simple benchmark with the
following script:
use DBI;
my $DB= DBI->connect("dbi:mysql:innobase","chris",shift) or die;
$DB->{RaiseError}=1;
$DB->do("drop table if exists speedtest");
$DB->d
Yeah, this is why some people like the idea of having transaction supports
in the tables, to make sure both the inserts to the two tables succeed, or
none of them do. Currently MyISAM does not support this, only the newly
introduced Berkeley DB tables support this feature although it is assumed
qu
Hello all;
Sorry to sound a little naive, but what is this new GEMINI thing I have been
reading about? Is there any FAQ/Docs on it or what is so neet about it??
Thanks!
Patrick
- Original Message -
From: Greg Cope <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent:
Thanks for your quick reply. My database is nearly 700 megs alltogether, 320 of those
megs are the main table which also receives the most queries.
The log is currently around 700 megs as well, which very obviously is a bad idea to
analyze every night... but as I said, I was looking more for a
Hi there,
Another problem.
i have the following tables:
table 1:
id, primary key, auto increment
name varchar(50)
city varchar(50)
phone varchar(25)
table 2:
categorie_id, primary key, auto_increment
kategorie varchar(50)
in table one i have the contacts
and in table two the categories (Busi
The Problem was that
i didn't have a primary key in addition to a timestamp field.
that's all.
regards denis
.' '.' `.
_.-| o | o |-._
.~ `.__.'.__.'^ ~.
.~ ^ / \ ^ ~.
\-._^ ^| |^_.-/
On Sat, 17 Mar 2001 22:04:37 +0100, "Denis Mettler" <[EMAIL PROTECTED]>
wrote:
Denis,
Can't you tie the table 1 id and the table 2 category_id together?? Or are this
going to be different?? If they are going to be different, I would suggest then
create a "linking" table to link table 1 to table
Hello.
On Sat, Mar 17, 2001 at 10:05:25PM +0100, [EMAIL PROTECTED] wrote:
> Thanks for your quick reply. My database is nearly 700 megs
> alltogether, 320 of those megs are the main table which also
> receives the most queries.
Well, in this case 1GB wouldn't hurt. 512MB is not enough to keep th
I've done some experimenting with the config variables based on the disk usage theory,
and after increasing the table cache, Mysql handles the log analyzer being run much
better. It still buckles under after a while, but now after minutes instead of
seconds, and it's able to recover after I sto
Oops. Found lots of threads regarding this compile error with Geocrawler. I
better update MySQL and see if MyODBC will compile then fine.
> I forward my question as I didn't get any response in the myODBC mailing
> list. Hope someone can help.
>
> > Is this the best mailing list when experiencing
I am try to do a join with tables that are in two different databases.
I thing I've got the actual SQL syntax down:
my $q = "SELECT i.inv_no, i.inv_date,
c.cust_name
FROM receivables.invoice i, sales.customer c,
WHERE i.paid_date IS NULL";
but I am confused on how to pr
Sorry, No Green Beer, No can do that ;-)
Richard Reina wrote:
> I am try to do a join with tables that are in two different databases.
>
> I thing I've got the actual SQL syntax down:
>
> my $q = "SELECT i.inv_no, i.inv_date,
> c.cust_name
> FROM receivables.invoice i, sales.cust
On Sat, 17 Mar 2001, Denis Mettler wrote:
> Hi there,
>
> Another problem.
> i have the following tables:
>
> table 1:
> id, primary key, auto increment
> name varchar(50)
> city varchar(50)
> phone varchar(25)
>
>
> table 2:
> categorie_id, primary key, auto_increment
> kategorie varchar(50)
I'm trying to populate a pulldown menu with distinct values from a found set
using the following query.
SELECT DISTINCT name FROM request
WHERE id <= '5' OR demo_id = '$demo_id'
ORDER BY name
Apparently I am doing something wrong. If I have a record with the same name
that meets the WHER
Can someone look at this syntax and tell me what is wrong with it. Any
and all help is appreciated. I worked with several databases and have
never had any trouble writing CREATE statements in the past.
I get the following error when I run this create statement. So what is
wrong with my syntax.
On Sat, Mar 17, 2001 at 12:53:50PM -0800, Patrick Calkins wrote:
> Hello all;
>
> Sorry to sound a little naive, but what is this new GEMINI thing I
> have been reading about? Is there any FAQ/Docs on it or what is so
> neet about it??
It is a new table handler which is being developed by the fol
I want to know if it is possible to build a MySQL query which will only
return the unique values of a specific column. Ie if I had this table:
id | name |date___
1 | Jon | 2001-01-03
2 | Bob | 2001-01-04
3 | Jon | 2001-01-05
Is there any SQL query that will only return 1 row for each
I want to know if it is possible to build a MySQL query which will only
return the unique values of a specific column. Ie if I had this table:
id | name |date___
1 | Jon | 2001-01-03
2 | Bob | 2001-01-04
3 | Jon | 2001-01-05
Is there any SQL query that will only return 1 row for each
On 18-Mar-01 Tom Beidler wrote:
> I'm trying to populate a pulldown menu with distinct values from a found set
> using the following query.
>
> SELECT DISTINCT name FROM request
> WHERE id <= '5' OR demo_id = '$demo_id'
> ORDER BY name
>
> Apparently I am doing something wrong. If I hav
On Thu, 21 Dec 2000, JCampbell wrote:
> I want to know if it is possible to build a MySQL query which will only
> return the unique values of a specific column. Ie if I had this table:
>
> id | name |date___
> 1 | Jon | 2001-01-03
> 2 | Bob | 2001-01-04
> 3 | Jon | 2001-01-05
>
> Is
On 22-Dec-00 JCampbell wrote:
(get ready for it, big 21st century party is coming up)
> I want to know if it is possible to build a MySQL query which will only
> return the unique values of a specific column. Ie if I had this table:
>
> id | name |date___
> 1 | Jon | 2001-01-03
> 2 | B
I have recently installed MySQL-server-version-3.23.35.rpm on my cobalt
raq4...
The install documents state that the rpm will install into the /var/lib
folder... I ran the install but can't seen to locate where the files were
installed?
Any help is appreciated.
Thanks,
Greg
-
On 18-Mar-01 Rodney J. Woodruff wrote:
> Can someone look at this syntax and tell me what is wrong with it. Any
> and all help is appreciated. I worked with several databases and have
> never had any trouble writing CREATE statements in the past.
>
> I get the following error when I run this c
I'm trying to use a remote telnet connection to access a mysql
server. Anyone know where I could find protocols to connect to
a mysql server, with telnet? Thanks.
Bob Feldbauer
[EMAIL PROTECTED]
-
Before posting, please check:
-Mensagem original-
De: Vagno A.G. [mailto:[EMAIL PROTECTED]]
Enviada em: Quinta-feira, 15 de Março de 2001 16:08
Para: xeryus; WindowsMedia.com; Suede Vieira; RSNA 86TH SCIENTIFIC
ASSEMBLY & ANNUAL MEETING; [EMAIL PROTECTED]; Mark White; Marcelo
Mendes; luiz augusto borba de oliv
Hi,
I am a newbie in Mysql and is confused about setting login/passwords. Just
want a simple security measure as I am the only user.
Here's the scenario:
I managed to connect using PHP to mysql via the mysql_connect without using
any
hostname/password. What do I change to impose this security m
Op Saturday 17 March 2001 22:04 kon Denis Mettler het niet nalaten op te
merken:
> Hi there,
>
> Another problem.
> i have the following tables:
>
> table 1:
> id, primary key, auto increment
> name varchar(50)
> city varchar(50)
> phone varchar(25)
>
>
> table 2:
> categorie_id, primary key, aut
I just started using MySQL, so I can't confirm this, but if it is really not
possible, maybe someone could consider implementing something like Oracle's
database links ? It might be a good thing for the beer industry ;-)
Only a suggestion...
Marc
Op Sunday 18 March 2001 01:10 kon c.smart het
Hi there !
I wanna know if the reverse of the function SUBSTRING_INDEX exists or
not.
--DESCRIPTION---
==
>SUBSTRING_INDEX(str,delim,count)
>Returns the substring from string str before count occurrences of the
delimiter delim.
>If count is positive, everything to the left of the fin
64 matches
Mail list logo
