Aftab Khan <[EMAIL PROTECTED]> wrote on 12/28/2005 02:15:33 PM:
> Can some one please tell me what I am doing wrong here I have
installed
> and configured users in the database. I am using ODBC driver to logon.
> When I use the password, it does not work but surprisingly the logon is
> allow
Can some one please tell me what I am doing wrong here I have installed
and configured users in the database. I am using ODBC driver to logon.
When I use the password, it does not work but surprisingly the logon is
allowed without a password. I have tried to use MySQL Administrator to
logon r
Terence <[EMAIL PROTECTED]> wrote on 11/23/2005 08:22:30 PM:
> Hi All,
>
> We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not
> working. It works fine on 4.1 but 5.0.16 gives us an error:
>
>
> How to reproduce:
>
> CREATE TABLE `user_master` (
>`user_id` int(5) unsigned
Terence,
>SELECT um.username,rm.role_name,dm.department_name
>FROM user_master um, role_master rm
>LEFT JOIN department_master dm ON um.department_id = dm.department_id
>WHERE um.role_id = rm.role_id;
>J
Your query joins rm to dm on a um column = a dm column. Recent 5.0 releases
rightly object t
On 24/11/2005 2:22 p.m., Terence wrote:
SELECT um.username,rm.role_name,dm.department_name
FROM user_master um, role_master rm
LEFT JOIN department_master dm ON um.department_id = dm.department_id
WHERE um.role_id = rm.role_id;
1054 - Unknown column 'um.department_id' in 'on clause'
Query:
S
Hi All,
We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not
working. It works fine on 4.1 but 5.0.16 gives us an error:
How to reproduce:
CREATE TABLE `user_master` (
`user_id` int(5) unsigned NOT NULL auto_increment,
`department_id` int(5) default NULL,
`role_id` int(5
Hello.
In my previous post I gave you a link to the thread where had
been described how to create the my_global.h. Have you tried that?
>Hi,
> U replied me without any contents. pls help me by giving some tips.
>
> Thanks and Regards,
>Ashok Kumar.P.S.
--
For techni
Hello.
See:
http://lists.mysql.com/mysql/180308
Ashok Kumar <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 11 lines --]
>
> Hello Friends,
> I wrote one simple pgm to connect and disconnect the database in
> TC(Windows). when compiling the program,
Hello Friends,
I wrote one simple pgm to connect and disconnect the database in TC(Windows).
when compiling the program, it's giving the error, unable to open the
my_global.h and giving some more errors from the header files my_sys.h and
mysql.h. I copied all the header files from the mysql\in
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need to be pointed in the right direction please.
> Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
> hosting environm
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Unknown error, urgent help please
"Ronnie Regev" <[EMAIL PROTECTED]> wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need t
"Ronnie Regev" <[EMAIL PROTECTED]> wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need to be pointed in the right direction please.
> Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
> hosting environment on Ensim webppli
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment on Ensim webppliance-3.5.20-7.
When using phpMyAdmin and attempting
04/01/04 11:40 AM cc
Subject
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subje
Hi,
I am working on mysql repliction on windows 2000.
I am trying to make the slave as master when the master goes down. When I
execute the io thread shutdown on slave after master goes down, it hangs.
Even the slave server does not stop on executing the shutdown command using
mysqladmin and
Hi!
It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql "internal" databases(the
ones that carries user and config info), the script is usually in
"install_prefix/bin/mysql_install_db"
If you have no recently installed mysql, and the ser
Raza
GE Financial Assurance
-Original Message-
From: Soni, Sanjay K [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 6:48 PM
To: [EMAIL PROTECTED]
Subject: urgent help required for mysql
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not
"Soni, Sanjay K" <[EMAIL PROTECTED]> wrote:
> 040225 13:57:20 mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full:
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040225 13:57:22 InnoDB: Log file ./ib_logfile
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote:
> Hi,
>
> I could not find the binary for SCO Unixware (Intel based) in download
> section. I suppose mysql supports this environment too. May I know as to
> where can I find this binary. Do I need to build this myself?
There are some version on ftp.zen
TECTED]
Subject
Re: Urgent help needed - SCO Unix
Subject
Re: Urgent help needed - SCO Unix
Hi!
If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes, don
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA
Regards,
Anup Mahansaria
--
MySQL General Mailing List
For list archives: h
greetings nug
we ar estuck in a project to connect to mySQL running on Mac OS X, through
TCP/IP, please suggest
regards, ram
--
+--+
Mac Solutions
http://www.macsolutionsindia.com +91 98102 70848
> It looks like you have a dynamic IP your end and the mysql
> server is looking
> for a fixed IP.
Nope, you read it wrong, both of you. MySQL is printing out YOUR IP
address, not the address of the server. It's complaining that you don't
have permission to access the data you want.
sql, query.
It looks like you have a dynamic IP your end and the mysql server is looking
for a fixed IP.
Try name based DNS form your PC.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:manuvi@;eth.net]
Sent: 18 October 2002 09:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Urgent
Hi all,
I have used the following script to connect our remote database from my local
machine. The PHP script is at my local machine.
When I tried to connect the database, instead of connecting to the IP provided
in the script, it is searching the Dynamic IP of my Internet Service Provider.
and
Hi fellows,
Thanks for your help. Finally I have the data in the table. But I lost these
special Characters( à ? å ä ); Which when I imported from the text file,
they existed. But I can't find them now by Select statement.
Should I use Character encoding if so, then how?
I am using Java wit
tp://www.mobilink.com |
mailto:[EMAIL PROTECTED]| |
| 2 | 01 | Sandra | Bridget | 12th Aveneue No. 301 | 12548 |
Broklyn| (212)780101 10 | |
mailto:[EMAIL PROTECTED] | |
+---+--++-+--+---+--
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But
> when I
> import the file, it only gets half of recor
PROTECTED]
Subject: Urgent Help! Importing Data from Text File...
Importance: High
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the table using below
mentioned command;
LOAD DATA INFILE 'user.txt' INTO TABLE userda
y that errno 13 means a permission issue. a straight sudo
chown -R mysql /usr/local/mysql/* solved everything.
- Original Message -
From: "jeroen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 06, 2002 9:23 AM
Subject: need urgent help
Okay, I'm very sorry for bothering you all with this. If I had not panicked,
I probably would have found it myself.
- Original Message -
From: "jeroen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 06, 2002 9:23 AM
Subject: need u
Maybe you didn't specify the correct data-dir in my.cnf?
Thomas
sql,query
On Sun, 6 Oct 2002 09:23:51 +0200 "jeroen" <[EMAIL PROTECTED]> wrote:
> hello,
>
> I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
> installed a new system (I'm running on MacOSX, was 10.1.
hello,
I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
installed a new system (I'm running on MacOSX, was 10.1.5.1, now after
upgrading it is 10.2.1) and I did not properly do it I'm afraid : I backed
up my /usr/local/var directory which contained all my mysql 3.23.28
Hi,
Could any of you help me in getting a Performance Comparison document for
MySQL on different architectures (Intel linux or S390 linux).
Regards,
prabha
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi all,
I have installed a clean RedHatLinux 7.1, and 7.2, and have selected
the PHP and mysqlshare components to install. I also have configured the
httpd.conf to use the php modules with Override ALL option. But when I want
to run any php, including the one that need to access the mysql serv
Hi Stanley
You can get mysql to tell you what an error means by doing
perror
In your case the result is 'Record was already deleted (or record file
crashed)'.
You should be able to recover your table with myisamchk -r
james
At 15:09 04/03/2002 +, Stanley Joseph wrote:
>Hi ,
>When ever
Hi ,
When ever I am running my query it gives me
1030- got error 134 from table handler.
has anybody come across it.
Any help will be greatly appreciated.
Thanks
Stanley
This email and any attachments
ddy/
ICQ: 56093095
- Original Message -
From: "Karuku Srinivas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 1:12 PM
Subject: Urgent Help needed
> Hi All,
>
> Can anyone please tell me how to alter a table wherin modify a
Hi All,
Can anyone please tell me how to alter a table wherin modify a column
(which is Unique) to a non unique column.
Any help on this would be great .
Thanks
Regards,
K Srinivas
res Ph:6631851
ATS TransLogic Systems
5th Floor Amogh Plaza, Greenlands,
Hyderabad, AP 500 016, India
Tel: +9
ent: Thursday, January 24, 2002 5:46 PM
To: [EMAIL PROTECTED]
Subject: Need very very Urgent help
Hi,
I installed mysql-3.23.47-win version on Win NT 4.0 Workstation, but I cant
start MySQL
service.
When I am trying to start mysql service, I get an error msg like this:
Could not start the My
Hi,
I installed mysql-3.23.47-win version on Win NT 4.0 Workstation, but I cant start MySQL
service.
When I am trying to start mysql service, I get an error msg like this:
Could not start the MySql service on \\SARADHI.
Error 1067 : The process terminated unexpectedly.
I installed mysql once
Hello John,
are you sure, that the user "test" with password "test1" exist in your
Grant-Tables and has rights to
INSERT ??? [;-)]
Gruß
Christian
john zie wrote:
>
>
>
> Mysql:
>
> We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It
> works fine, however when we test a
>>> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
>with both the binary distro and source distro with no luck. The install seems to go
>OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
>system.
>>>
>>> Please disregard thi
Mysql:
We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works
fine, however when we test a php file which just function to insert some
data to a table in database, and display all data on the web page. After
run this, the data have been inserted and displayed; however,
At 4:08 PM -0500 7/25/01, MikeBlezien wrote:
>On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
>>>Source distributions don't really come with any table handler enabled
>>>by default, because there are no binaries included in the distribution.
>>>To see what options co
"MikeBlezien" <[EMAIL PROTECTED]> writes:
> Hello All,
>
> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
>with both the binary distro and source distro with no luck. The install seems to go
>OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Ker
On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>>Source distributions don't really come with any table handler enabled
>>by default, because there are no binaries included in the distribution.
>>To see what options control the table handlers, run this command:
>>
>>
At 2:55 PM -0500 7/25/01, MikeBlezien wrote:
>Hello All,
>
>>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40
>>>I have tired with both the binary distro and source distro with no
>>>luck. The install seems to go OK, but I can't start the mysql
>>>server. This is on a RH/Linux
Hello All,
>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with
>both the binary distro and source distro with no luck. The install seems to go OK,
>but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
>system.
Please disregard this
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to
go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel
2.4.6 i686 system.
The main problem seems to be,
: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>The directories specified in the above variables exist.
>However when I try to run the service I get the error "C
Hi,
I am using mySQL on Windows 2000. I need to use the InnoDb table type to get
transaction support. I had initially installed mysql and was using the ISAM
table type and everything was working fine. My NT service was configured to
run the mysqld-nt.exe. For using the InnoDb type I un-installed
Hi all,
I need to convert the records from mysql database into MS.Access.
I don't have ODBC.The mysql is in different machine(stand alone).So i need
to convert that into a flat file then put into MS-Access.
Can u pl.help me in this regard.
It's very urgent.It'll b very much useful if i get a r
Hi all,
My RedHat 6.1 + MySQL server box has some rare thing happens today.
This box is sitting on the 192.168 network. It allows a cgi program to
select and update its records. The cgi program was triggered by the
Internet.
This box was received a lot of query this afternoon. Suddenly, it(redh
t;mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 8567 invoked from network); 14 May 2001 09:49:45 -
From: "Chris Bolt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Urgent Help Needed
Date: Mon, 14 May 2001 03:52:32 -060
May 2001 12:02:54 +0200
Sender: jbueno
Message-ID: <[EMAIL PROTECTED]>
Date: Mon, 14 May 2001 12:02:54 +0200
From: Joseph Bueno <[EMAIL PROTECTED]>
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdkfb i68
Hi,
Does $keywords contain a quote ?
You must escape special characters in strings before using them in SQL
statements. If you are using Perl DBI look use 'quote' function otherwise,
check MySQL API for your programming language.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
[EMAIL PROTEC
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type =
> '$employment_type'
> AND location = '$location' AND related_discipline =
> '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree,
> wxcdfour AGAINST
> ('$keywords') AS score FROM cvt
Hi Group,
I posted this question before, and need help urgently. The problem is using a
specific search! What we are trying to do is intially search 3 fields and
then once the results are found it needs to be able to narrow down the
results by searching the intial 3 criteria and also a keyword
Hi,
I have 5 tables in mysql, each of same structure.
When some search word is given, I am creating 5 threads
to search in 5 tables. Now i need to order the search
results in the most suitable order.
For example, for a search word, the results from table 3
will be more suitable, where
AT I HAVE TO DO
--- i checked below commands at least 10 times---
please i need urgent help!!!
cem
---
The Fastest Browser on Earth now for FREE!!
Download Opera 5 for Windows now! Get it at
http://www.ope
67 matches
Mail list logo
