store search result as new table in memory

hello Masters, I am a novice, and I am wanting to know how to achieve this: 1million plus row in a table. user runs a search, gets some results. I want to store this result in memory in a way, so that user can fire more SQL searches on this result. How is this done? I want this to go atleast upto

converting numeric to date-time?

I have a column in a table which is epoch time including milliseconds. e.g. = 1409304102153 now i want to display all fields in the table but this field as: "2014-8-29 Fri 09:21:42: GMT" (whatever comes in ) and i am not finding anything on web about how to do that. can anyone help

Re: ubuntu 12.04 not running latest phomyadmin, even though installed.

when i run the application like this: http://mywebsite.com/phpMyAdmin/index.php on the home page it shows i am using old version: "Version information: 3.4.3.1, latest stable version: 4.2.7.1" but i have latest phpmyadmin installed (see below) why is it not appearing? MySQL client version is 5.5

ubuntu 12.04 not running latest phomyadmin, even though installed.

when i run the application like this: http://mywebsite.com/phpMyAdmin/index.php on the home page it shows i am using old version: "Version information: 3.4.3.1, latest stable version: 4.2.7.1" but i have latest phpmyadmin installed (see below) why is it not appearing? MySQL client version: 5.5.3

Re: indexing on column having duplicate values

ajeev On Wednesday, May 28, 2014 3:29 PM, Rajeev Prasad wrote: thx Reindl, I am using phpMyAdmin, i looked closely and found "index" is this index you are talking about? (earlier i used "Primary"). My further question is: the index key here is going to be epoch system t

indexing on column having duplicate values

Gurus, I am going to have a big table with lot of records, to expedite searching i wanted to index on a key field (which is numeric value). BUT, there will be records which will have same value for the key field (other columns will be different). so how can i do this? right now, i am getting er

how to list record in column (instead of a row)

this table has many columns and only 1 record. select * from table; generates an unreadable list. how can i list the record as in two columns? (column name and its value)? i looked at UNPIVOT, but could not get it to work. SQL> select * from table UNPIVOTE INCLUDE NULLS;                    

Re: update a row only if any column has changed, in a very large table

thx all, the source data is in text file. - Original Message - From: "h...@tbbs.net" To: mysql list Cc: Sent: Saturday, April 6, 2013 8:02 PM Subject: Re: update a row only if any column has changed, in a very large table >>>> 2013/04/06 13:56 -0700, Rajee

update a row only if any column has changed, in a very large table

hello, > >I have a table with around 2,000,000 records (15 columns). I have to sync this >from an outside source once everyday. not all records are changed/removed >/new-added everyday. so what is the best way to update only those which have >changed/added/or deleted? > >i can use update_or_crea

(resolved) Re: user not able to login from localhost

friends,  i figure that i had to give password in quotes. i was then able to login. thank you all for your help and time. From: Rajeev Prasad To: Rick James ; mysql list Sent: Monday, September 24, 2012 4:11 PM Subject: Re: user not able to login from

Re: user not able to login from localhost

sql> I am looging in from the same server. From: Rick James To: Rajeev Prasad ; mysql list Sent: Monday, September 24, 2012 2:09 PM Subject: RE: user not able to login from localhost That says that your password in not correct.  You have not go

Re: user not able to login from localhost

ase`.* TO 'myuser'@'localhost' | +-+ I am using phpmyadmin to manage mysql, including user privileges. ____ From: Ben Mildren To: Rajeev Prasad Cc: mysql list Sent: Monday, Sep

user not able to login from localhost

i have given select/insert/update/delete rights to a user on a specific database, from localhost. when i try to login to mysql using the uid, i get error: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) what other privilege do i need to give this user?

secure user name for MySQL account?

I am considering using cryptic username for accessing and working on a database on my MySQL installation. can anyone with experience provide some suggestion pl? in documentation, i only see that it can be 16 char long. how complex it can be? any side effects/bugs of username complexity? can I us

Re: suggestion needed for table design and relationship

thx in advance. Rajeev From: Peter Brawley To: Rajeev Prasad ; "mysql@lists.mysql.com" Sent: Wednesday, August 15, 2012 4:01 PM Subject: Re: suggestion needed for table design and relationship On 2012-08-15 1:54 PM, Rajeev Prasad wrote: > I

suggestion needed for table design and relationship

I have to keep this data in MySql, and i am not sure (as SQL/databse is not my field) how to organise this into one or many tables? right now I would represent my info as follows: device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specific_to_device|associated_service   |associated_

Re: [Dbix-class] search any matching word in given string in table column which has only one word

thanks a lot that worked! From: Rodrigo To: Rajeev Prasad ; DBIx::Class user and developer list Cc: mysql list Sent: Saturday, August 11, 2012 11:12 AM Subject: Re: [Dbix-class] search any matching word in given string in table column which has only one

search any matching word in given string in table column which has only one word

here is given string of type:...   "as23,rt54,yh79" and i have to lookup in a table which has column "id" which has only one four letter word. i have to select that row in which the colum 'id' value matches any of the word in given string... table column: id contents like: | id| |sd32| |wa

changing mySQL table name screws phpMyAdmin?? reverting change fixes??

I changed a name of the table from within phpMyAdmin, and immediately it crapped. after that when I try to connect using phpMyAdmin (/phpMyAdmin/index.php) I get error in log: [Wed Aug 0814:18:582012][error]Query call failed:Table'mydb.mychangedtbls'doesn't exist (1146) (I changed the name from

Re: how to changing default '-' character in Datetime in MySQL?

a session-by-session basis if you prefer.  Refer to the documentation page below for details on manipulating system variables either globally or on a per-session basis. http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html - michael dykman 2012/2/5 Halász Sándor : >>>&

using mod auth_mysql with apache for authentication

Hello, currently i have  mod auth_mysql configured and running as plaintext password: 1. how can i generate crypt_des passwords to store in database? 2. how can i get a user log out once the browser tab is  closed. seems i have to close the browser and reopen, then only i am presented login box.

installing mysql 5.1.37 in ubuntu 8.10

Hi, i am using ubuntu 8.10, i installed mysql from aptitude(version is 5.0.67-0ubuntu6). My db creation sql script is working correctly in version, But my client complaining its giving errors in mysql 5.1.37 version. Could any one guide me to install mysql 5.1.37 in my ubuntu 8.10 OS. Thanks

Need help executing mysql stress test suite

Hi, For mysql stress test suite (mysql-stress-test.pl) to execute, it requires --stress-tests-file to be provided which contains the list of tests to be executed. As per the documentation the default name of the file is stress-test.txt and it will be located under ./mysql-test directory. But I co

errror while installing DBD::MYSQL.

Hi All, I don't know whether it is correct group or not. Just a hope that I may get solution. I have installed DBI and when I run the following perl script; --SCRIPT use strict; use warnings; use DBI; my $DSN="DBI:mysql:database=faculte;host=localhost;port=3306"; my $DB_OBJ=DBI->

adding event in 2nd table??

elp is appreciated. Thanks Love and regards Prasad

Re: performance of extended insert vs. load data

mysqlimport with parallel threads is worth giving a try. It is similar to 'load data infile' but with concurrent threads loading the tables. I think , it was added in mysql-5.1.18. But it is said to work with previous versions also according to the author : http://krow.livejournal.com/519655

Re: Replication constantly restarting

Make sure each of the replication slaves uses different server_id. --Ravi Ben Clewett wrote: MySql, I am running 5.0.41 on a master and four replication slaves, all 64 bit Linux. In the error.log on all four replication servers I keep seeing: 070626 8:34:23 [Note] Slave: received end pac

Re: MySQL memory allocation

Which thread library is the mysqld linked against? Linuxthreads shows each thread as a separate process in top or ps output. All threads share the same memory. From your output, it is likely that you are using linuxthreads(all pids having the same VSZ and RES memory). Regards, Ravi Cabbar

Re: mysqldump corrupting utf8 data

How are you importing the dump into mysql? Importing by piping the dump file to mysql may broke some chars due to shell. Have you tried this: (with in mysql client) SET NAMES UTF8; SET CHARACTER SET UTF8 source /pathto/dump.sql Cheers, --Ravi Sean O'Hara wrote: Hi All, I've been googling al

Re: identify process that created the connection

This blog may help, http://www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/ Cheers, Ravi Rithish Saralaya wrote: Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux-Apa

Re: INNODB Question

Tripp, ibdata files never shrink. You can try this to free up space: * Take a mysqldump of all tables that you may need, * delete the ibdata files, * Rebuild your tables by importing the dump. Using innodb_file_per_table, will freed the disk space whenever you run optimize table or del

Re: ~performance issues~

t; rite ? > > Thanks, > Abdul. > > On Tue, 2006-04-11 at 10:51 +0530, Ravi Prasad LR wrote: > > Hi Abdul, > >When sync_binlog is set to 1, innodb fsyncs the binary > > log to disk after every single write to binary log, but not in the case > > of sync

Re: ~performance issues~

Hi Abdul, When sync_binlog is set to 1, innodb fsyncs the binary log to disk after every single write to binary log, but not in the case of sync_binlog=0. From MySQL manual: If the value of this variable is positive, the MySQL server synchronizes its binary log to disk (fdatas

Re: DBD::mysql::st execute failed: MySQL server has gone away

Luke, > Yup. Basically if I do a particular query from the command line, > I get the following error: > === > InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. > InnoDB: Was only able to read -1. > 060327 8:25:41 InnoDB: Operating system error number 5

Re: Multi Master Replication

Marvin, > The process is working between Master, Slave1 and Slave2 but >for some reason Slave2 is not writing bin-log information. > So Slave3 is sitting empty and not getting any data because of no data > in Slave2's bin-log. I guess u don't have 'log-slave-updates' flag

Mysql Server crashes saying Page directory corruption

Hi all, Server version :4.0.26 OS: FeeBSD-4.10 The mysql server(slave) crashes with the following messages in its error log, and gets restarted, after which rollbacks and starts replicating from master Page directory corruption: supremum not pointed to 051226 10:02:58 InnoDB: Page dump

Re: Binary Logs not updating

Hi James, If you want to configure a relay replication server, i.e. make the replication to pass data from slave to another slave as A->B->C you need to start B with --log-bin and --log-slave-updates.So check that log-slave-updates has been included in your my.cnf file. You can read mor

Re: MyODBC 3.5.9 and MySQL 4.1.8

I Agree I did downloaded from dev.x MyODBC 3.5.10-x86-win-32bit.exe and it works with MySQL 4xx Thanks Love and regards Prasad - Original Message - From: "Homam S.A." <[EMAIL PROTECTED]> To: "Tom Crimmins" <[EMAIL PROTECTED]>; "nikos" <[E

Downgrade Mysql from 4 to 3.23

Hi, I am developing a database in mysql 4.Is it possible to downgrade the same into mysql 3.23.If its possible then how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Calling a procedure with parameters

Hi, If this possible in MYSQL (capability of procedure with parameterized parameters). Assume a procedure with parameters a1,a2,a3 test(a1,a2,a3) begin . . end Can I call the procedure test by following way call test(a2 = 5, a1 = 4, a3 = 7); i.e changing the ord

Stored procedures

Hi, I'm testing stored procedure on MySQL5.0.My question is can I change the definition of a procedure body using ALTER PROCEDURE?(Not the characteristics). I'm not sure if it is implemented! TIA, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: replication: slave returns a 1236 error_code.

Is the server-id of slave different from that of master? Check this. both the serverid's must be different.. Regards T.Nagendra Prasad Professional Services OSI Technologies __ -- Original Me

Automate Mysql Replication

ossible to make the B as master & C as slave to B incase A goes down? Can this scenario be automated? Any Ideas?? Regards T.Nagendra Prasad Professional Services OSI Technologies __ -- MySQL General Mailing List For

Thread safe client

Hi, Is there any sample code available for MYSQL thread safe client using C API? Thanks in advance, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL benchmarks

Hi All, Is there any AS3AP benchmark suite readily available for MySQL? Thanks in advance, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Needing help for JDBC issue

Hi, I'm getting the following error while connecting to a MySQL databases using JDBC. Any clues?? "java.net.SocketException: errno: 48, error: Address already in use" Thanks, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

java.net.SocketException: errno: 48, error: Address already in use

Hi, I'm getting the following error while connecting to a MySQL databases using JDBC. Any clues?? Thanks, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4 Built in SSL?

Hi, 1.First generate un encrypted certificates. This can be done by using an Open SSL library. The instructions are available at http://www.mysql.com/doc/en/Secure_Create_Certs.html Note: Here un encrypted certificates means certificates that are not protected by any password. When MySQL code

Need ur help ..........

Hi, I downloaded Linux semi static binary of mySQL,mysqlgui-linux-semi-static-1.7.5.tar.gz. Could you please help me,how to install in my system.My OS is Redhat Linux9.0. Warm regards, Renuka Prasad.N

Re: Error 2013 during query

Check the connection timeout parameter. Increase it if it's low and try.. >>> "W. Bauer" <[EMAIL PROTECTED]> 10/16/2003 6:20:44 PM >>> Dear all When I run a query on a table with about 22 Mio records and three columns of type bigint, I get a Error 2013 Lost connection to MySQL server during que

Re: Select always "Using FileSort"

Whenever you use select * MySQL will skip using index. For more information, http://www.mysql.com/doc/en/MySQL_indexes.html . Thanks, Ram >>> mos <[EMAIL PROTECTED]> 10/15/2003 10:17:22 AM >>> I want to speed up a large query and I noticed if I do an: Explain select * from LargeTable order by

Migration tools for sybase to MySQL

Hi, Are there any tools to migrate db schema as well as data from sybase to mysql? Thanks, Prasad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

XML support for MySQL

Is it possible to direct xml support for queryiing a SQL statement and get the result in also in xml? Prasad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqladmin: connect to server at 'localhost' failed

Check the sysntax! It should be mysqladmin -u root -p shutdown (If u r shutting down the server) You should provide the password if you have one for the root user. >>> Saravanan Kulandaivelu <[EMAIL PROTECTED]> 7/23/2003 3:21:59 PM >>> Hi, I am getting the following error: mysqladmin: connect

Help required on testing MySQL with Open SSL

Hi, I'm looking for information on testing MySQL server with Open SSL using any client(JDBC/ODBC). Please let me know how to test using a MySQL client for SSL. I was able to compile mysql with using open SSL Thanks Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

How to Archive and restore the data in MySQL database.

Hi, Can any of you give me links about Archiving and restoring the data in MySQL database. Are there any utilities for the same? Thanks in advance, Ram - Before posting, please check: http://www.mysql.com/manual.php (the man

Java.lang.outofMemoryException while accessing MySQL usingJDBC

Hi, I have a JDBC application connecting to MySQL database. It was working fine for the queries that retrieve small amounts of data. But when the database contains 600,000 records and the query SELECT * is fired it gives Java.lang.outofMemoryException. Can any of you help me out what could be the

Problem with installation of mysql 3.23.52 on solaris 9

Hi, The error is as follows sql_lex.cc: In function `void lex_init()': sql_lex.cc:84: `symbols' undeclared (first use this function) sql_lex.cc:84: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:86: `sql_functions' undeclared (first use this fun

connecting mysql using servelets

hi list user , i am new to list and new to mysql i gotta do a project of my company w=hci reqiure to extract data from a server the user in his browser reqest a graph .in the client m/c and this requset goes to server where a java servelet has to accept the request ..now what the servelet

Composite primary key in MySQL

Dear all, Will MySQL supports "composite primary key" constraint? If so what is the actual syntax? How foreign key relationship can be established in MySQL? Please help me. Prasad. - Before posting, please chec

always this happenes to me

ct to MYSQL server through socket /tmp/mysql.sock" __ but when i go to the /tmp & search for this socket mysql.sock i donh't find it there. i don't understand what the probs is. plz

Leaking Handles

time the handle count increases . Approximately 24 per hour . The handle count can be seen by using the Task Manager . The application has to work with 2500 simultabeously open tables. Can some one suggest any solution ? Best Regards Prasad Gurav

Distribution of MYSql

I have to obtain some license ? Best Regards Prasad Gurav - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

mysql installation on linux(RH7.2)

ng kpackage, i found all the header files in the same dir(/usr/include/mysql) i don't understand what to . HELP ME I'M STRUCK regards prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: MySQL Problem in Slackware 8.0

password (correctly)it gives me following error: Access Denied for user 'root@localhost' (Using password:YES) Am I following the steps wrongly? Should I uninstall the MySQL and also delete the datadir and then again install mysql package in Slack8? Regards, Prasad --- Prasad Paranja

Re: MySQL Problem in Slackware 8.0

Hi, I also noticed one thing , will the entry in the file /etc/hosts make a diffrenece. In Red Hat it is 127.0.0.1 localhost But in Slack it is 127.0.0.1 prasad( which is my name) Regards, Prasad --- Prasad Paranjape <[EMAIL PROTECTED]> wrote: > Hello gurus, > > I have Sl

MySQL Problem in Slackware 8.0

e /etc/my-small.cnf to ~mysql/.my.cnf (This is as per documentation in my-small.cnf) Still I am not able to log on to the database. I am not able to understand why mysqld is ending.Is there any other thing I am missing which would start this daemon and then I can connect to database. Regards

MYSQL Database Specs

Hello, I am interested in knowing :- 1) The maximum number of tables possible in MYSQL Database 2) The maximum number of columns that are in a table. - Before posting, please check: http://www.mysql.com/manual.php (the man

RE: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306.

1 Do you already have another mysqld server running on socket:/tmp/mysql.sock ? 08 13:59:01 Aborting I have tried to run it on different ports using -P option. But still i am getting same error. regds, Prasad. -Original Message- From: Venu [mailto:[EMAIL PROT

java.sql.SQLException: Cannot connect to MySQL server on localhost:3306.

are to process next line line = in.readLine(); } in.close(); } catch( Exception e) { e.printStackTrace(); } } // protect data with quotes private static String quote(String include) { return("\"" + include +

hai

solve out this problem. Thanks, Prasad. - 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 PROTEC

problem with starting mysql server + segmentation fault

al/mysql/data shell> chgrp -R mysql /usr/local/mysql shell> chown -R root /usr/local/mysql/bin shell> bin/safe_mysqld --user=mysql & 9800 shell> Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-solaris2.8-i386/data Segmentation Fault - core dumped 0110

Re: phpmyadmin + mysql +Unknown database 'test'

Hi, Well, I also had the same problem and finally traced the bug down to a file called db_readdump.php3 in phpmyadmin directory. If you'r still having the problem, may be this is helpful to you too. edit db_readdump.php3 and add in the beginning of the file $db = trim($db); Then at the

Re: mail all users in MySQL database

Dear Clay Bond, I am really new to PHP, Can you please kindly let me know a code snippet to do the same? i.e. while loop etc. Thanks Love and regards Prasad - Original Message - From: "clay bond" <[EMAIL PROTECTED]> To: "*MySQL mail list" <[EMAIL PROTE

mail all users in MySQL database

Dear All, Can anyone suggest a link where I can find a script in PHP3 to mal all users in MySQL database? Thanks Love and regards Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual

Random string for each row in a table

Dear All, How do I create random string for each row in a mysql table? and mail the same each recepient in the respective row. Thanks Love and regards Prasad - Before posting, please check: http://www.mysql.com/manual.php

Re: how to use BLOB datatype...

de to store and retrive an image from the >BLOB data type( database,sql,query).I desperately need this... > > Thx, > Prasad. - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

mail to mysql database recepient

. Thanks Love and regards Prasad - 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]&

Problem with Dates...

additional things to do ? pls. send me the solution. Best Regards, Prasad. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

email only two columns

Dear All, Is it possible to mail only three columns from a database ? Third column being email ID? I need to send email to all with a valid email ID in a database. Thanks Regards Prasad - Before posting, please check

Membership management

to view any other members information. Nor can he modify his own data. Data modification is done only by system admin. If any of you come across such a script do mail me or the list. Thanks Love and regards Prasad - Before

Mysql Stability

Hi, I have a site with the database of size 90 MB on Mysql-3.22.25. It is performing quite well right now, Please let us know the maximum limit of the database size that Mysql can handle efficiently. Regards, Guru _ Get You

Problem With NOT IN Sql Statement...

Is NOT IN statement works in MySql ? I am having version 3.23.11-alpha of mysql... Is Newer version solves the problem? If (NOT IN) statement is not there pls can u send me alternative for the above sql statements and also suggestion about the version. Bye, P