Hi Dave,
To try and explain it better: if you used Synaptic, you use what is called a
package manager, basically a program that will get everything you need and
install it for you. (the .rpm)
But in that case as you said you can't use 'configure'.
The other option you have is to install from what is called the source,
meaning you download the source code of a program and accomplish manually
the commands to have it running. The three steps you usually follow when
doing that are configure, make and then make install.
The whole instructions to do that are there:
http://dev.mysql.com/doc/refman/5.1/en/installing-source.html
It's the one I used when I started to try and install manually programs, and
they are very clear (even if it may look a bit hard at the beginning,
really, don't worry, go slowly step by step and it will work).
At some stage you will then be asked:
shell> ./configure --prefix=/usr/local/mysql
this is where you would add an extra option:
shell> ./configure --prefix=/usr/local/mysql --with-charset=utf8
(you have several configure options, you may want to take a look at them
before:
http://dev.mysql.com/doc/refman/5.1/en/configure-options.html)
don't forget to do the post-installation as described here:
http://dev.mysql.com/doc/refman/5.1/en/unix-post-installation.html
About mysqld --character-set-server=utf8, you have an error meaning that you
probably didn't stop your mysql server.
mysqld --character-set-server=utf8 is used to start the server, so if an
other one is already running it will fail.
try stopping your server:(from the mysql directory)
shell> bin/mysqladmin -u root shutdown
and restart it with
shell> bin/mysqld_safe --character-set-server=utf8
I think it's really worth spending the time on the installation form the
source,it's a bit long the first time, but you'll get used to it, and if you
ever want to install an other program from the sources you'll know what to
do!
hth,
melanie
From: Dave M G <[EMAIL PROTECTED]>
To: mel list_php <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Unable to duplicate a database at home, possible encoding
problem
Date: Wed, 15 Feb 2006 11:44:41 +0900
The precise instructions are here:
http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html
...but if it is your local home installation you could also recompile
mysql specifying utf8 when you run configure.
Thank you for the very helpful advice.
I understand what it is you're saying I can accomplish, but I'm fuzzy on
the specifics, because, if it weren't already apparent, I'm a bit of a
newbie at this stuff.
I get that I can use commands with the --with-charset=utf8 perameter to
rebuild (?) my server with utf8 as the default encoding.
But you see, I installed MySQL from within a program called Synaptic within
Ubuntu. On the upside, it was very easy to get my MySQL installation up and
running. On the downside, I didn't see or do any configuration settings our
source code building, which means I'm clueless as to where this stuff
happens.
Being the exploratory newbie that I am, I tried the following:
[EMAIL PROTECTED]:~$ mysqld --character-set-server=utf8
060215 11:40:58 [Warning] Can't create test file
/var/lib/mysql/ubuntu1.lower-test
060215 11:40:58 [ERROR] Can't start server: Bind on TCP/IP port: Address
already in use
060215 11:40:58 [ERROR] Do you already have another mysqld server running
on port: 3306 ?
060215 11:40:58 [ERROR] Aborting
060215 11:40:58 [Note] mysqld: Shutdown complete
[EMAIL PROTECTED]:~$ ./configure --with-charset=utf8
bash: ./configure: No such file or directory
I kind of knew it wasn't going to work when I tried it, but I thought I'd
dive in anyway.
Is it possible I can get a slighly more newbie-friendly set of instructions
on how I can either reconfigure my MySQL server, or at least permanently
alter the system variables?
--
Dave M G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://messenger.msn.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
