how to execute the compiled mysql without make install, always?


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/


--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

Karthik Gurukuntala wrote:

You should example MySQL's options for execution

"mysqld --help --verbose" and use the proper options for your setups.

For a better situation, I would suggest that if you are averse to
installing MySQL system-wide,to at least install MySQL locally using
"./configure --prefix=/home/karthik/mysql_testdir" (chose a name of your
laking) and run it from there.

regards,

Patrick

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

everytime i re-compile the source with some
changes?(Actually am debugging the code to learn some
aggregationoperations' execution.)


-K


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/


--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

Hi, Karthik!

On Mar 23, Karthik Gurukuntala wrote:
It does. But you can do 'make install' once, then delete the installed
mysqld and replace it with a symlink to your mysqld binary in the source
tree. Then you won't need to install anymore, recompile and run.

Regards,
Sergei

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

Karthik,

Personally I never install MySQL/MariaDB on my work machine.
I have a pair of scripts (one to run the server, one for the
client) that assume a certain location of all databases
(there can be many, e.g. one for each major server version).

Assuming that my databases are under "~/databases" (e.g.
"~/databases/5.3"), and my sources (and BZR repository) are
under "~/src", the server startup script must be run in the
root directory of each source tree.

The server startup script generates the following command:

../sql/mysqld --no-defaults --port=11211
--datadir=/home/<user_name>/databases/5.3
--socket=/home/<user_name>/databases/5.3/mysql.sock
--language=/home/<user_name>/src/5.3-mwl68/sql/share/english
--character-sets-dir=/home/<user_name>/src/5.3-mwl68/sql/share/charsets
--lower-case-table-names=1

Notice that I have chosen by default a non-standard port (11211),
to avoid possible conflicts with a standard MySQL installation.
The option --no-defaults is there so that it is guaranteed that
all options to the server come from my script (and thus the
command line).

Also notice that for versions > 5.1 the language and character
set options are different, check the docs.

Actually, if you want them, I can publish my scripts, let me
know.


Timour

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

You can also check out

http://mysqlsandbox.net/

maybe it has an option that will work for your needs.

http://search.cpan.org/~gmax/MySQL-S...box/Recipes.pm



Philip Stoev

----- Original Message -----
From: "Karthik Gurukuntala" <kgurukuntala (AT) yahoo (DOT) com>
To: <internals (AT) lists (DOT) mysql.com>
Sent: Tuesday, March 23, 2010 6:44 AM
Subject: Re: MySQL execution


everytime i re-compile the source with some
changes?(Actually am debugging the code to learn some
aggregation operations' execution.)


-K


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/


--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...toev (DOT) org


--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

--- On Tue, 23/3/10, Sergei Golubchik <sergii (AT) pisem (DOT) net> wrote:

Ok... so, is it the mysqld.o(inside workdir/sql) which gets created after make in the source, the binary of the new mysqld, that I have to symlink to 'mysqld_safe' in '/home/karthik/install/mysql/bin/' ?

my source is in '/home/karthik/source/workdir'.

Regards,
-Karthik


Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/


--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

--- On Tue, 23/3/10, Karthik Gurukuntala <kgurukuntala (AT) yahoo (DOT) com> wrote:


Where is the binary of the mysqld in the source tree located? I am working on source mysql 5.5.1 m2.

Regards,
-Karthik


Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/


--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

Karthik,

<cut>
Please re-read carefully my previous email, specifically the
command line I sent you. The answer is there.

Timour

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw

Hi, Karthik!

On Mar 23, Karthik Gurukuntala wrote:
no, it's "mysqld" - that is "/home/karthik/source/workdir/sql/mysqld" -
that you need to symlink to "/home/karthik/install/mysql/libexec/mysqld"

ln -sf /home/karthik/source/workdir/sql/mysqld /home/karthik/install/mysql/libexec/mysqld

Regards,
Sergei

--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?uns...ie.nctu.edu.tw