Re: does mysql alert about all the duplicates?

Maybe this post will help you with your user/config question. http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update > On Mar 16, 2016, at 7:46 AM, Reindl Harald

Re: using alias in where clause

Have you tried using a select case statement for ftag? > On Jan 25, 2016, at 6:39 PM, Larry Martell wrote: > > On Mon, Jan 25, 2016 at 7:27 PM, Reindl Harald wrote: >> >> >> Am 26.01.2016 um 01:16 schrieb Larry Martell: >>> >>> I know I

Re: Aes Encryption

the risk 0% i wanted to know where to store the key but now James Black has suggested to pass the key on application startup and not to store on disk which is a good idea and will try to implement that. Thanks evey one for your help. Love .. [EMAIL PROTECTED] wrote: On Thursday 10 February 2005

Re: Copying Database from One Hard Drive to Another

Well if you copy my.cnf settings along with ibdata files and log files then it is possible to copy innodb exactly on the different machine and i have done this before worked fine for me. Love .. [EMAIL PROTECTED] wrote: InnoDB files can not be copied from one machine to another like the MyISAM

Re: Aes Encryption

Has any body implemented Aes encryption while storing critical data in mysql? I want to know the logic you are implementing to store your passwords to encrypt/decrypt data. Love Kumar Love Kumar wrote: Hi, Aes Encryption requires a password (key) to access data, now where do we store this key

Aes Encryption

deal to get those passwords if source code is accessible. What i think Aes encryption reduce the risk but does not make data 100% safe because of source code dependency. Love Kumar Perl Develpment Team eBookers.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: key on the month portion of a date field

use below: alter table table_name add index (birthday); Love Kumar .. [EMAIL PROTECTED] wrote: Short Version: is there any way to make an index for a date field that appears in the WHERE as a MONTH() argument? I have a table with some hundreds of thousands of rows already, and now i have the need

Re: backup/synchronize tables/db web-local server

It is very easier with mysql replication concipt, this automatic replication from Master server to Slave server and real time. I wonder how you do not know about this. http://dev.mysql.com/doc/mysql/en/replication.html Love kumar .. [EMAIL PROTECTED] wrote: SQLyog Enterprise's Database Sync

Data load

I'm trying to import data (approx. 2000 records), but am unable due to the following circumstances; My host doesn't allow access into the mysqldb directory for security purposes (shared server). This is the directory where MySQL is looking for the import file. I then tried to use LOCAL but