Re: I am stupid

. 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 supposed to do.. Please help!! 2. Create a database

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

Re: Database hung; please help!

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 Opens: 100

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 -uroot ERROR 1045

Re: MySQL Newbie: Running in UNIX

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: Wednesday

Re: Works with MySQL Logo

http://images.google.com/images?hl=enlr=q=%22Works+With+MySQL%22btnG=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 attachment, will be helpful

Error making mysql-4.1.5-gamma

/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 archives: http

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 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

Re: MySql basics?

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 tabble-name drop index index-name 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

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 how to update a field

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 want

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. Any help

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 time

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: server is getting slower and slower

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 unless I

Re: using mysql in commercial software

windows c++ code. I hope I am able to use it! thanks, Steve Richter -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin www.TechQuotes.comBrainbench Certified Linux (RedHat 9) Admin -- MySQL General

Re: nested sets

is welcome! Alexander Newald -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin www.TechQuotes.comBrainbench Certified Linux (RedHat 9) Admin -- MySQL General Mailing List For list archives: http

Re: using mysql in commercial software

when you're selling a product to the general public which relies on MySQL (or redistributing MySQL, etc). Please correct me if I'm wrong... - Original Message - From: Aman Raheja [EMAIL PROTECTED] To: Steve Richter [EMAIL PROTECTED] Cc: chat. mysql. [EMAIL PROTECTED] Sent

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 subusers and give them the rights to add/change/delete subsites of the users

Re: File size limits with mysql 4.1

? -- - michael dykman - [EMAIL PROTECTED] -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin www.TechQuotes.comBrainbench Certified Linux (RedHat 9) Admin -- MySQL General Mailing List For list archives: http

Re: grants for non-root

for user 'mysqladmin' on host 'localhost' What does it mean? What's wrong? The problem occurs with MySQL-4.0.20 at Linux Fedora, it does not occur with MySQL-3.23. Thanks for any help. Regards, Wolfgang -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench

Re: can not start mysql daemon

-party/depot/Linux-2.4c2.2-i686/gcc-2.95.3/bin/gcc' 'CFLAGS= -mcpu=pentiumpro -D_FILE_OFFSET_BITS=64' 'CXX=/opt/third-party/depot/Linux-2.4c2.2-i686/gcc-2.95.3/bin/g++' -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin

Re: Errcode: 27

This should be a useful thread for you http://lists.mysql.com/mysql/167953 Suggests using ALTER TABLE MAX_ROWS=a big num 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):

Optimize problem on BIG table

I have a HUGE table, with hundreds of millions of records. mytab.MYD 78GB mytab.MYI 16GB I decided to get rid of some old data because I can't INSERT into this table anymore, since the MAX for index file is reached. Following is what I did and what I got. mysql DELETE FROM mytab WHERE

Re: MySQL port question

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 version from mysql.com. Version 4.x

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 MySQL: Got error

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: 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't start

Re: mysql_client

- 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 other pc so i gave

Re: can't start server

are 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

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 help

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] wrote

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

What if one is using rpm - should just use the --upgrade option rpm -U MySQL-server-4.x 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

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

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

:) 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 PROTECTED

Lost connection to MySQL server during query

-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/manual.php (the manual) http

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: Tue

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:

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

mysql sub query

Hello All I have the following situation ID GRP PRC CHECK 1 3 10.0Y 2 2 12.0Y 3 3 32.0N 4 1 5.0 N 5 1 7.0 Y 6 2 9.0 N 7 3 17.0N 8 1 11.0N Problem is

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

Hi All I am making a search program. I am looking for a query. I want to allow the user to search Any or All. Anyhow, suppose the database contains the following Author | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | --- If the user

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 in advance. 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 in advance. Aman

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:

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: http://mobile.msn.com

problem in cgi-perl using queries

Hello I have a database abc with one table xyz The html page is to sign up a new user and calls the following signup.cgi script. The new data is not getting inserted in the table when I execute it from the ip address - the page getting called by the form. BUT I can INSERT data in table by

installation problem

New to MySQL. Have got RH Linux 7.2 on Intel-based processor Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz Followed the documentation instructions given in Chapter 2 online at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary I get

mysqlbug - installation problem

New to MySQL. Have got RH Linux 7.2 on Intel-based processor Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz Followed the documentation instructions given in Chapter 2 online at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary I get

Re: installation problem

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.msn.com/intl.asp

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

Re: install prob - different error

I re-installed MySql from RH Linux 7.2 cd and now I am getting the following [root@coolnis-ar mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020312 18:29:52 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql --err-log=my.err [root@coolnis-ar mysql]#