How to Install mysql from source

2010-10-18 Thread ml ml
Hello List, i am trying to install mysql on debian lenny from source. Here is what i did (yes, i did read the INSTALL-SOURCE): ./configure --prefix=/usr/local/mysql/ make -j 4 make install cp support-files/my-medium.cnf /etc/my.cnf cd /usr/local/mysql chown -R mysql . chgrp -R mysql .

multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread ml ml
Hello List, how do i install mysql COMPLETLY in a diffrent directory? Right now i am using: ./configure --prefix=/usr/local/mysql-5.1.42 --sysconfdir=/usr/local/mysql-5.1.42/etc BUT, mysql still looks for /etc/my.cnf and for /var/log/mysql/mysql-bin.index ... So what configure options do i

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread ml ml
Hi Claudio, i would like to compile it from source. Mario On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni claudio.na...@gmail.com wrote: hi, do you want to compile or you can use binaries? Claudio 2010/10/15 ml ml mliebher...@googlemail.com Hello List, how do i install mysql COMPLETLY

Re: multiple mysql installations - Install mysql from source with a prefix

2010-10-15 Thread ml ml
himanshu.ra...@naukri.com wrote: Hi Mario, While installing a new instance you don't exactly need to mention anything except for the --prefix option. While starting the new instance you can provide all config parameters like config file, datadir etc. On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote

Selecting Dates

2010-02-01 Thread ML
' AND = '2010-01-30' ORDER BY order_date; Neither of these work. What am I missing? -ML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Selecting Dates

2010-02-01 Thread ML
on my part. -ML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Weeks

2009-12-28 Thread ML
Hi All, trying to write some SQL that will give me records for the CURRENT WEEK. Example, starting on a Sunday and going through Saturday. This week it would be Dec 27 - Jan 2. I am doing this so I can write a query that will show orders that are placed during the current week. Here is what

MySQL running, but I cannot connect

2009-12-21 Thread ML
Hi All, MySQL 5.0.77 on CentOS 5.4 MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. I checked the firewall and that is successfully allowing the passage. I checked the firewall on the server and that has 3306:tcp allowed. When I try to

Porting MySQL database across international sites

2009-07-16 Thread Daniele Development-ML
Hello everybody, the MySQL application I'm building needs to be ported from my current site to the hosting site - which is based on another nation. The problem I'm having is that the login doesn't work as the password doesn't match in the charset of the new hosting site. To address this problem,

Uploading large files with mySQL

2009-07-13 Thread Daniele Development-ML
Hello, I'm developing a web application that requires to store large files in a MySQL database. The files can range up to 2Gb. In my understanding the upper limit for the SQL queries (thus insert queries) is 1GB. I'm trying, for the time being, to upload files of sizes around 65MB, but I still

Stored Procedures from SQL Server

2009-07-07 Thread ML
I am working on moving a database from SQL Server to MySQL 5. Tables, data, etc I already know. I have some procedures that i would like to move as well. Does anyone have examples on creating stored procedures? Best, -Jason -- MySQL General Mailing List For list archives:

how to set quota for sql use ?

2003-09-28 Thread ml
Hi all , I have a trouble about how to set quota for sql use , all db under mysql are own by mysql:mysql, i can't set any system quota for it , does anyone have idea about it ? thx

encrypted entries

2003-07-16 Thread ml
Hi, I'm using mysql along with Postfix MTA and courier imapd to run a virtual aliased domain email server. I have no problem connecting to and retrieving mail when i use clear passwords, but when i have the imap client try to connect using tls/ssl..it fails. I've read the docs and know that i

Re: User Variables doesn't work?

2003-05-28 Thread ML
Brawley [EMAIL PROTECTED] wrote: Not just MySQLFront. PhpMyAdmin chokes on it, too. - - Original Message - From: ML To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:08 AM Subject: Re: User Variables doesn't work? You are right, I tried from command