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
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
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
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 clue would be nice
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
/*/\*\/\*\ /*/ \*\ /*/ \*\
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 either if
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
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
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 or
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 the server
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
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
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
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'
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.x alpha. I know the
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 Prez
* IT Department
* Libraries System
*
Description:
when i first start the mysqld i get error @HOSTNAME@ COMMAND
NOT FOUND. AND WHEN I TRY TO CHANGE PASSWORD I GET ACESS DENIED FOR ROOT
AT LOCALHOST USING YES please help How-To-Repeat:
code/input/activities to reproduce the problem (multiple lines)
Fix:
Description:
when i first start the mysqld i get error @HOSTNAME@ COMMAND
NOT FOUND. AND WHEN I TRY TO CHANGE PASSWORD I GET ACESS DENIED FOR ROOT
AT LOCALHOST USING YES please help How-To-Repeat:
code/input/activities to reproduce the problem (multiple lines)
Fix:
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
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 Spychaa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 11:14 AM
Subject: ODBC trouble -
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
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.
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
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");
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
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
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 the
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
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.customer
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)
in table
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
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
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 folks
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
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
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 | Bob |
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
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
-Mensagem original-
De: Vagno A.G. [mailto:[EMAIL PROTECTED]]
Enviada em: Quinta-feira, 15 de Maro 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
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
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 final
51 matches
Mail list logo