Re: I am stupid>>

s database, look at GRANT in mysql docs. HTH Aman Raheja http://www.techquotes.com On Sat, 2 Apr 2005 19:20:46 +0100 (BST), Niki Lampropoulou <[EMAIL PROTECTED]> wrote : > I dont know how to do this very basuc, just atrated > working with MySQL and not sure about what I am > suppos

Re: Database hung; please help!

have cause the server slow down. Let us see what experts have, for comments. Regards Aman Raheja E SA wrote: Aman, The system is SuSE Enterprise 9 with kernel 2.6.5-7.111.5-bigsmp. MySQL is version 4.0.21 From mysqladmin status: Uptime: 7091 Threads: 13 Questions: 174188 Slow queries: 2

Re: MySQL database and user creation from script file

The -e option with mysql allows you to run queries and would allow doing user creation etc as well. Aman Raheja [EMAIL PROTECTED] wrote: Hi, I have to create user and database using script file. My requirements are given below. 1. Login as root 2. Execute the script file for database and

Re: MySQL Newbie: Running in UNIX

grant privs. Thanks Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Restart mysqld with the --skip-grant-tables option . Thanks. This suggestion works. Does it also mean I am skipping the grant-tables? -Original Message- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Wedn

Re: MySQL Newbie: Running in UNIX

Restart mysqld with the --skip-grant-tables option and then try Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Thanks. But, it confuses the unix "root" with the mysql root. I don't have the unix root previleges. Am I doing something wrong? Here is the error: unix> bin/mysql -

Re: Works with MySQL Logo

http://images.google.com/images?hl=en&lr=&q=%22Works+With+MySQL%22&btnG=Search Aman Raheja Karam Chand wrote: Hello, I searched MySQL.com but couldnt find the official "Works With MySQL" logo. Can somebody point me to the right direction. If they can send it to me as an attac

Error making mysql-4.1.5-gamma

directory /export/home/user/mysql-4.1.5-gamma ** Error code 1 make: Fatal error: Command failed for target `all' The .lib did get created in the /export/home/user/mysql-4.1.5-gamma/client but is empty. Suggestion appreciated.. Regards Aman RAheja -- MySQL General Mailing List For list

Re: mysql 4.1.5 source

Thanks a ton ! Aman Raheja Nate Blanchard wrote: http://downloads.mysql.com/archives.php -Original Message- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:47 PM To: mysql Subject: mysql 4.1.5 source Latest realease is 4.1.7 in 4.1.x but I am looking for

mysql 4.1.5 source

Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source download. Pointers will be helpful. Thanks Aman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql basics?

a colleague of mine used . http://www.analysisandsolutions.com/code/mybasic.htm The mysql's website has great details http://dev.mysql.com/doc/ HTH Aman Raheja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to remove an index

alter table drop index For details http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Aman Raheja leegold wrote: I want to remove the index I made below. I intend to then redo it because I forgot to add a third field. How do I remove this index? Alter...? Thanks. mysql> ALTER TABLE p

Re: Update a portion of text in a field

You'll get many results if you search for "mysql update replace" in google. You'd be using a combo of update-replace to do what you need. Aman Raheja Jacques Jocelyn wrote: Hello mysql, Something I have been thinking about without any clue on how I can achieve it. I know h

Re: Transfer data from mySql to access

different. HTH Aman Raheja Kamal Ahmed wrote: Hi, How do I transfer mySql Database (e.g Test Case Manager ) to MS Access ( Test Director) The Table names are different for the two DB's , but the content is similar Let say I have a Table CASE in Test Case Manager having 10 columns , and wa

Re: Query execution time?

As far as I know there isn't a way, though ideally there should be to do so. I would also look more for the answer and ask you to post it on the PER DBI mailinglist. Thanks Aman Raheja joe mcguckin wrote: Does the mysql server return to the client (DBI in this case) the query execution tim

Re: Problem with tables;

You need to do desc spamdata; NOT desc id. Aman Raheja Beauford wrote: Hi, I'm trying to create a table using the commands below, and everything seems to work and the table is there - I just can's access any of the fields. This happens on both my Windows and Linux versions of MySQL. A

Re: server is getting slower and slower

ng. i will await more expert suggestions at this point. Regards Aman Raheja Jonas Fischer wrote: The problem is that before (like last friday) there was no problem. The terminals (applications with microcontrollers) were connecting rapidly to the server. Today I checked and they will not connect unl

Re: server is getting slower and slower

Well, it does not sound to be a problem with the MySQL server if you get a good response from other computers but just not the microcontroller. As far as improving the performance of MySQL is concerned, check the MySQL docs and tons of info when you search google. - Aman Jonas Fischer wrote

Re: File size limits with mysql 4.1

ice on how to > transcend this limitation? > > > -- > - michael dykman > - [EMAIL PROTECTED] -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin www.TechQuotes.comBrainbench Certified Linux (RedHat 9) Adm

Re: Re[2]: nested sets

On Mon, 2004-07-26 at 10:24, DebugasRu wrote: > Hello Aman, > > Monday, July 26, 2004, 6:03:07 PM, you wrote: > > >> Hello, > >> > >> I have a question related to nested sets: > >> > >> On my website a user should be able to create su

Re: using mysql in commercial software

As I understand from the following link http://dev.mysql.com/doc/mysql/en/Using_the_MySQL_software_under_a_commercial_license.html You need to buy a commercial license if the software you are developing is not to be registered under GPL. Aman On Mon, 2004-07-26 at 09:55, Issac Goldstand wrote

Re: nested sets

gt; -- User 5 a > --- User 7a > --- User 8a > -- User 6 a > - User 3 a c > > If I give back full rights to User 2 all should be like at the beginning > > Any help is welcome! > > Alexander Newald -- Aman Raheja Linux+ Cer

Re: using mysql in commercial software

> MySql looks to be exactly what I am looking for as the database in my > windows c++ code. I hope I am able to use it! > > thanks, > > Steve Richter > -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admi

Re: Errcode: 27

This should be a useful thread for you http://lists.mysql.com/mysql/167953 Suggests using ALTER TABLE MAX_ROWS= On Fri, 23 Jul 2004 20:20:24 +, "J S" <[EMAIL PROTECTED]> wrote : > Hi, > > I'm trying to run the following SQL (on > mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc): > > CREA

Re: can not start mysql daemon

bc.so.6 -> > libc-2.2.4.so > -rwxr-xr-x1 root root 1283964 Dec 8 2001 /lib/libc-2.2.4.so > -rw-r--r--1 root root 27314296 Dec 8 2001 /usr/lib/libc.a > -rw-r--r--1 root root 178 Dec 8 2001 /usr/lib/libc.so > Configure command: ./configu

Re: grants for non-root

row in set (0.00 sec) + I would recommend checking the user table in mysql database and see what change your GRANT query did, if any. Let us see what it looks like, if there is any entry for the user you are GRANTing privileges. Regards Aman On Fri, 2004-07-23 at

RE: insertion of multiple rows - correction on my part

There is REPLACE... SELECT... http://dev.mysql.com/doc/mysql/en/REPLACE.html Thanks Aman On Wed, 2004-07-21 at 11:32, aman wrote: > Replace will be useful if you mean to delete the previous duplicates and > then enter the new data. > Moreover there is no REPLACE... SELECT like there

RE: insertion of multiple rows

As indicated earlier in one of my responses, INSERT... SELECT will allow you to grab a subset from one table and put in the other. You can also use the WHERE clause to apply conditions to your subset. Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 11:22, bruce wrote: > and

RE: insertion of multiple rows

Replace will be useful if you mean to delete the previous duplicates and then enter the new data. Moreover there is no REPLACE... SELECT like there is INSERT... SELECT which make life easy! Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 11:12, Laercio Xisto Braga Cavalcanti wrote

RE: Problem with GRANT...WITH GRANT OPTION

Also, if you have any doubts whether your changes took the right effect, check the mysql database on your server and check out the tables that store privileges assigned by your GRANT query. Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 11:11, Martin Gainty wrote: > J

Re: Column name case sensitive problem?

Java is case sensitive, this is the way JDBC wants you to work. The Exception is generated by JDBC, not due to an error from MySQL. I would recommend checking JDBC documentation. Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 10:55, Ying Lu wrote: > Hello, > > I have a

RE: insertion of multiple rows

I agree with Andrew - this is quicker. And if you area transferring data from one table to the other, you may wanna look at http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html Thanks Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 10:51, Andrew Hill wrote: > Hi Bruce, >

Re: MySQL port question

Not a problem! Do look into the database "mysql" after you log in. There are different privileges that you assign to different users and hosts on databases. GRANT and REVOKE are used for access control on databases / tables / columns. Regards Aman Raheja http://www.techquotes.com On

query locking up the system

Hello I executed a query on my server mysql> select count(*) from mytab where change < 2004070100 And another mysql> select count(*) from mytab where change > 2004070100 Would like to mention, the table is 240 million records and 78GB (MYD) I've been waiting forever to get any output

Re: Erro:Got error 28 from table handler!

Use the command perror Here's yours $ perror 28 Error code 28: No space left on device So get some disk ! Aman Raheja http://www.techquotes.com On Mon, 19 Jul 2004 16:30:05 -0300, [EMAIL PROTECTED] wrote : > Olá, > >qual o significado da seguinte menssagem de erro do

Re: MySQL port question

EMAIL PROTECTED] IDENTIFIED BY 'password'; HTH. Aman Raheja http://www.techquotes.com On Mon, 19 Jul 2004 14:21:04 -0400 (EDT), Yves <[EMAIL PROTECTED]> wrote : > Hello, > > I recently installed MySQL on Mandrake 10, not the > distro version, but the standard versio

Optimize problem on BIG table

ce left on device I agree that there is not much disk space. THE ISSUE: I want to reclaim the disk space that should be freed because of the millions of records I deleted. I need disk space to reclaim disk space? Atleast that's what it seems to be. I would await suggestions from experts. R

RE: re structuring tables for a huge database

se in this case, with my hard disk limit, I can not just modify columns. Thanks Aman Raheja Check out http://www.techquotes.com On Thu, 2004-07-08 at 16:26, Quentin Bennett wrote: > Hi, > > Alter table will create a whole new table, so you may have disk issues there. > > Check in

Re: re structuring tables for a huge database

(more than 430 million records) - that would help! Thanks for the quick response. Regards Aman Raheja http://www.techquotes.com On Thu, 2004-07-08 at 16:09, [EMAIL PROTECTED] wrote: > I think you may need to use a scripted approach in order to avoid > overflowing your disk. > > 1. Cr

re structuring tables for a huge database

to modify almost all the pre-existing columns - is there a quicker way? Regards Aman Raheja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump

all your tables and data into DB2 In case it is DB1 on the target system - in that case you will need to follow the last two steps on the target system, having the DB1 file copied and using DB1 instead of DB2 in those two steps. HTH Aman Raheja http://www.techquotes.com On Thu, 2004-07-08 a

Re: 4.1.1 not an update or upgrade of 4.1.0

Hi, I also faced this kind of error in sub query, any solution for this?: -Aman. On Mon, 19 Jan 2004, Director General: NEFACOMP wrote: > Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 > When the SUB-SELECT contains more than one field, it does not work (this

Re: To Re-write complex query with JOINS

hi vijay, You can use order by & group by commands in the queries.. Thanks and Regs, - Aman. On Mon, 19 Jan 2004, Vijay Patel wrote: > Hello friends, > > I have a problem with one of the JOIN query here. > Below is a brief description of the problem. > > tablena

Re: can't start server

Do check the ownership on /var/lib/mysql if not right, then chown -R mysql /var/lib/mysql I am getting out of ideas here. Would recommend to uninstall all the mysql packages - mysql-server, mysql-client and other you have installed and start afresh. Aman Raheja AGF Technologies http

Re: Need Help Upgrading From 4.x to 4.x

What if one is using rpm - should just use the --upgrade option rpm -U Is this ok to do? Thanks Aman Raheja AGF Technologies http://www.agftech.com [EMAIL PROTECTED] wrote: On Wed, 19 Nov 2003, Mark Marshall wrote: Hi, everyone. I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want

Re: can't start server

Do try ps -ef | grep mysqld to check the server is currently running. If not then do /etc/init.d/mysqld start Let know if there's an error at this point. Also show your my.cnf Did you use rpm or source to install mysql? Aman Raheja AGF Technologies http://www.agftech.com [EMAIL PROTECTED]

Re: can't start server

when you are trying to connect you get this - have you started the server??? try with chkconfig and start if it's not ON /etc/rc.d/init.d/mysqld start Check and let know so we can go on. Aman Raheja AGF Technologies http://www.agftech.com [EMAIL PROTECTED] wrote: Thank you again for your

Re: can't start server

running on and what version of mysql you are using, will help you get the solution faster - not the restarting the services kind :) Aman Raheja AGF Technologies http://www.agftech.com [EMAIL PROTECTED] wrote: Aman, thank you for your reply. I did check the ports with netstat and it appears that no

Re: mysql_client

from remote clients - Other information about GRANT can be obtained by searching GRANT on mysql.com HIH Regards Aman Raheja AGF Technologies http://www.agftech.com [EMAIL PROTECTED] wrote: Hi i have just installed the mysql_client and i am trying to remotely connect to the database of the ot

Re: can't start server

did you try netstat and see if something else is using the port. Aman Raheja AGF Technologies http://www.agftech.com [EMAIL PROTECTED] wrote: I am sure that this problem has already been answered but some how I can't figure it out. When I try to start the mysqld I get the error 2002 can&#x

win mysql performance test

on Windows or with ODBC or VB. Thanks Aman Raheja AGF Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

exhaust limit of auto_increment int on mysql

estion :) Thank you -- Aman Raheja AGF Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTE

Lost connection to MySQL server during query

led mysql-server-3.23.54a-1 mysql-3.23.54a-1 mysql-devel-3.23.54a-1 Still the same problem. Any suggestions? Thank you in advance Regards -- Aman Raheja AGF Inc. - Before posting, please check: http://www.mysql.com/

Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

HINT: I have used PERL to generate random numbers and then do a SELECT on the auto_increment field in the mysql table, thus generating random picks from my tables; I'll be glad to bet informed of better ways around, though :) Thanks Aman Raheja AGF Inc. - Original Message - From:

comparision in the datetime field

Hi All I have a datetime field in one of my tables in the MySQL database. Can I do something like return all records between two certain dates, say between Nov 02, 2002 and Nov 07, 2002. Thanks Aman - Before posting, please check

deleting tables with same prefix !

Hi All How can I delete all tables starting with prefix 'abc' in the MySQL database (there are about 200 such tables). Wild cards? Or if I just delete the files from the location where all the MySQL database tables are stored, what would happen ? T

changing database location

Hi All Right now I have all my MySQL database files getting stored in /var/lib/mysql/ If I want to change that to another location, say, /home/mysql or something else, how do I do it? Thanks Aman - Before posting, please check

Re: mysqladmin missing

Thanks. If I have an old copy of Mysql on the system and want to uninstall that, how would I make sure that all the database associated should get deleted, or do I do it manually? Thanks Aman - Original Message - From: "Frederic Trudeau" <[EMAIL PROTECTED]> To: &quo

mysqladmin missing

Hi I downloaded the mysql in RPM format and installed on my RH Linux 7.3 box. There is no mysqladmin, though there was no error. Do i need something else or should i be downloading te tar-ball and installing that? Aman - Before

access MySQL server from remote windows m/c

Hi all How do I access a remote MySQL server (on LINUX platform), from a windows application. What drivers I need to download and from where? How do I set permissions on the mysql server to let be accessed by the remote windows machine. Thanks alot Aman

fetching specific date from datetime field

ate that I may mention. Thanks Sincerely Aman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PRO

new user's login

Hi I added a new user in mysql using the following mysql>insert into user values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N',' N','N','N',&#

mysql sub query

the help Aman _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the

sql: create duplicate record

Hi I want to write sql query to duplicate a row. It has a PRI key called ID. The MySQL database looks like IDNameAddress 345 Aman42, sb 346 347... I want to duplicate the ID=345. Any suggestions ? Thanks in advance. Aman

query for search on mysql database

If the user searches for Rim Torus, I am though. But how to allow results if the search is "Jerry Classy", saying Any should match and have both second and third rows returned? Help is appreciated. Thanks Aman _

alter table - query help

Hello everyone I want to alter 50 tables, and for each the names start with the string 'mak' Is there an SQL query, so that I can do the change in one command. I have tried using wildcards - they don't seem to work in SQL. Thanks i

sql query alter HELP!!!

Hello everyone I want to alter 50 tables, and for each the names start with the string 'mak' Is there an SQL query, so that I can do the change in one command. I have tried using wildcards - they don't seem to work in SQL. Thanks i

select a certain num of items in sql query

Suppose I want to select items 10 to 30 from a table tab, which has 36 rows. What could be the sql query ? Thank you. Aman PS: I am using cgi-perl. _ MSN Photos is the easiest way to share and print your photos: http

sum of a column

Hi all How do I get the sum of all values in a column 'col' of a table 'tab' I am using CGI-Perl and mysql. Thank you. Aman _ Send and receive Hotmail on your mobile device: h

problem in cgi-perl using queries

#x27;}`, `$form{'temail'}`, `$form{'tdob'}`, `$form{'taddrstreet'}`, `$form{'taddrcity'}`, `$form{'taddrstate'}`, `$form{'taddrzipcode'}`, `$form{'taddrcountry'}`, `$form{'toccupation'}`, `$form{'

Re: install prob - different error

l 020312 18:29:52 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020312 18:29:52 mysqld ended [root@coolnis-ar mysql]# any suggestions ? Thank you Aman _ Get your FREE download o

Re: installation problem

- The default socket parameter is correct - mysqld is not running earlier - I changed the required ownership #ls -ld /var/lib/mysql/ drwxr-xr-x4 mysqlmysql4096 Mar 12 17:46 /var/lib/mysql/ # I am still getting the same #more my.err 020312 15:56:40 mysqld started 020312 15:56:40

Re: installation problem

ysqld: Shutdown Complete 020312 15:57:31 mysqld ended [root@coolnis-ar mysql]# Any suggestions ? Thank you Aman Raheja _ Get your FREE download of MSN Explorer at http://explorer.m

mysqlbug - installation problem

any .err file either and the MySQL server doen't start. Please help Thank you Aman _ Chat with friends online, try MSN Messenger: http://messenger.msn.com ---

installation problem

any .err file either and the MySQL server doen't start. Please help Thank you Aman _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/world