How to Install mysql from source
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 . bin/mysql_install_db --user=mysql FATAL ERROR: Could not find mysqld The following directories were searched: /usr/libexec /usr/sbin /usr/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. == Okay, this my make some sense. Whats the _correct_ way to solve this? Which mysql_install_db options do i need here? bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ Installing MySQL system tables... 101018 11:50:13 [ERROR] /usr/local/mysql//libexec/mysqld: unknown option '--skip-bdb' 101018 11:50:13 [ERROR] Aborting 101018 11:50:13 [Note] /usr/local/mysql//libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. == Why does it also log to /var/lib/mysql ? find /var/lib/mysql/ /var/lib/mysql/ /var/lib/mysql/mysql /var/lib/mysql/test /var/lib/mysql/mysql-bin.index Cheers, Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
multiple mysql installations - Install mysql from source with a prefix
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 need if i want to install mysql seperatly in a folder? Do i also need --datadir? If yes, where sould my data dir be? In /usr/local/mysql-5.1.42/var? Thanks a lot, Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: multiple mysql installations - Install mysql from source with a prefix
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 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 need if i want to install mysql seperatly in a folder? Do i also need --datadir? If yes, where sould my data dir be? In /usr/local/mysql-5.1.42/var? Thanks a lot, Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: multiple mysql installations - Install mysql from source with a prefix
Hello, i installed mysql with: ./configure --prefix=/usr/local/myprefix/mysql/ make make install (at the point mysql is not running yet) Next i would like to initialize the DB but get the follwoing error: -- #:/usr/local/myprefix/mysql# bin/mysql_install_db --user=mysql --basedir=/usr/local/myprefix/mysql/ --datadir=/usr/local/myprefix/mysql/data Installing MySQL system tables... 101015 15:13:17 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 /usr/local/myprefix/mysql//libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 2) 101015 15:13:17 [ERROR] Aborting 101015 15:13:17 [Note] /usr/local/myprefix/mysql//libexec/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /usr/local/myprefix/mysql/data for more information. find /usr/local/myprefix/mysql/data/ /usr/local/myprefix/mysql/data/ /usr/local/myprefix/mysql/data/mysql /usr/local/myprefix/mysql/data/test --- And the folder /var/log/mysql/ does not exist. I dont want it to be there anyway. Cheers, Mario On Fri, Oct 15, 2010 at 2:12 PM, Himanshu Raina 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: 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 need if i want to install mysql seperatly in a folder? Do i also need --datadir? If yes, where sould my data dir be? In /usr/local/mysql-5.1.42/var? Thanks a lot, Mario -- Regards, Himanshu Raina -- Guillotine, n.: A French chopping center. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Selecting Dates
Hi All, Switching from Oracle to MySQL, I seem to be having some difficulty selecting dates using between or even where = and = like: SELECT * FROM orders WHERE order_date BETWEEN='2010-01-01' AND '2010-01-30' ORDER BY order_date; or SELECT * FROM orders WHERE order_date ='2010-01-01' 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
Jim, Shouldn't it be: SELECT * FROM orders WHERE order_date = '2010-01-01' AND order_date = '2010-01-30' ORDER BY order_date; ? change the = and repeat the column_name. Datetime should be datetime or timestamp; Spot on. Thank you for the clarification, obviously a syntax mistake 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
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 I have, but this is showing from today for the next seven days. SELECT * FROM orders WHERE WEEK(NOW(), 7) = WEEK(orders.order_date, 7) AND DATEDIFF(NOW(),orders.order_date) 7; Would anyone have any advice? -Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL running, but I cannot connect
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 connect I get an error (4) which when I google says: Interrupted System call I have tried using the MySQL Workbench and other client software. If I look in /var/log/mysqld.log I dont see anything but the fact the server started. I tried stopping mysql with /etc/init.d/mysqld stop Then starting with mysqld_safe --init-file=/tmp/code.txt Where code.txt contains: UPDATE mysql.user SET Password=PASSWORD('BabyToad09') WHERE User='root'; GRANT ALL ON mysql.* to 'root'@'127.0.0.1'; GRANT ALL ON mysql.* TO 'root'@'localhost'; GRANT ALL ON mysql.* TO 'root'@'my home IP'; FLUSH PRIVILEGES; commit; and I still cannot connect. What am I doing wrong? What can I check for? Things work, just not for me from home. -Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Porting MySQL database across international sites
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, I have made some changes to the server configuration: - set default charset as utf8 (originally it was latin1) Plus, I've made some correction to the J2EE application: - forcing the JVM to start with the option -Dfile.encoding=UTF-8 But still, the passwords doesn't match when trying to log in. Any suggestion or hint about what I should look into? To me, it appears that all the settings have been properly changes, but there is something missing. Thanks! Dan
Uploading large files with mySQL
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 get some errors - including the MySQL server has gone away. I followed the discussion in other post, and I properly set all the system variables (max_allowed_packet_size, wait_timeout) to the maximum value, but the error still occurs. Would you suggest looking at something in particular? For the time being, just to try this, I'm inserting the file through the MySQL Query Browser - just not to add other possible sources of problems on top of that. Thanks! Dan
Stored Procedures from SQL Server
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how to set quota for sql use ?
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
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 need to have an encrypted version of the password in the sql database and I've also read that there is a certain way to do it..but i can't seem to find it. i looked through the docs but came up with nothing.. Can someone tell me how to do this, or at least point me to a specific reference. I'm also wondering if i just use 'crypt' on the desired password and then cut and past this value into the database is the proper way to do this? I've seen somewhere that the encrypt function of mysql isn't compatible with courier. Thanks in advance, Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
Thanks for your info, I d/l SQLyog and it seems really cool. MySQLFront 2.5 had so many bugs that I had to leave it. I prefer SQLyog now. Its FREE !!! and has all the features ( plus some realy cool extra features ). You can try SQLyog at http://www.webyog.com/sqlyog Karam --- Peter 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 line and it works, the problem occurs with MySQL Front v2.5. This is strange because I love this software and this is a strange bug... Regards. I'm using User Variables, I tried it with the query found in the mysql manul: SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; But I receive this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 I have MySQL v4.0.12 Worked perfect for me. Did you execute the above query from command-line client or what client did you use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]