you can use mysqld_multi
On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni wrote:
> did you remove /etc/my.cnf?
>
> 2010/10/15 ml ml
>
> > Hello,
> >
> > i installed mysql with:
> > ./configure --prefix=/usr/local/myprefix/mysql/ && make && mak
did you remove /etc/my.cnf?
2010/10/15 ml ml
> 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 initi
You can pass the following variables as well
--defaults-extra-file=
--socket=
--port=
On Fri, 2010-10-15 at 18:50 +0530, ml ml wrote:
> Hello,
>
> i installed mysql with:
> ./configure --prefix=/usr/local/myprefix/mysql/ && make && make install
>
> (at
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:
---
gt; >> 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
> >>
> &
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,
>
ll 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 ...
>>
hi,
do you want to compile or you can use binaries?
Claudio
2010/10/15 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
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
Something in the ilk of
update *table* set *field* = concat("prefix_", *field*) where *condition *
should do the trick.
On Mon, Oct 19, 2009 at 4:56 PM, lejeczek wrote:
> dear all, a novice here
> quickie regarding query syntax - is it possible to take fields values from
> one column
> and updat
dear all, a novice here
quickie regarding query syntax - is it possible to take fields values
from one column
and update the same column with new values like this: prefix_OldValue
column: one, two, three -> column: prefix_one, prefix_two, ...
can this be done with one query and with on use of ab
://www.olindata.com
On Wed, Feb 11, 2009 at 5:35 PM, csego...@gmail.com wrote:
> I am trying to install mysql in a non-standard directory - specifically
> /app/mysql
>
> Subsequently, I ran the following configure command:
>
> ./configure --prefix=/app/mysql --with-plugins=innobase,myisam
I am trying to install mysql in a non-standard directory - specifically
/app/mysql
Subsequently, I ran the following configure command:
./configure --prefix=/app/mysql --with-plugins=innobase,myisam
There were no problems with the compile, but mysql failed to start.
Furthermore, the following
>
> pt_table1
> pt_table2
> pt_table3
>
> What I want to do is copy each of the tables (exactly as they are,
> including primary keys, data, etc) but at the same time change the prefix
> to something else (ie: eng_) so that I would end up with:
>
> pt_table1
> pt_ta
imary keys, data, etc) but at the same time change the prefix to something
else (ie: eng_) so that I would end up with:
pt_table1
pt_table2
pt_table3
en_table1 (exact copy of pt_table1, including data PK, FK, etc..)
en_table2 (exact copy of pt_table2, including data PK, FK, etc..)
en_table3 (ex
Martijn Tonies wrote:
>
>
>> >> Anyway of accomplishing this? Ideally without having to state each of
> the
>> >> tables names. And also that this would work so that you could only
>> > duplicate
>> >> tables that have a certain pre
> >> Anyway of accomplishing this? Ideally without having to state each of
the
> >> tables names. And also that this would work so that you could only
> > duplicate
> >> tables that have a certain prefix, so: duplicate only tables that start
> > with
&g
les:
>>
>> pt_table1
>> pt_table2
>> pt_table3
>>
>> What I want to do is copy each of the tables (exactly as they are,
> including
>> primary keys, data, etc) but at the same time change the prefix to
> something
>> else (ie: eng_) so that I wou
do is copy each of the tables (exactly as they are,
>> including
>> primary keys, data, etc) but at the same time change the prefix to
>> something
>> else (ie: eng_) so that I would end up with:
>>
>>
>> Anyway of accomplishing this? Ideally without having to stat
gt; What I want to do is copy each of the tables (exactly as they are,
including
> primary keys, data, etc) but at the same time change the prefix to
something
> else (ie: eng_) so that I would end up with:
>
> pt_table1
> pt_table2
> pt_table3
> en_table1 (exact copy of pt_table
time change the prefix to something
else (ie: eng_) so that I would end up with:
Anyway of accomplishing this? Ideally without having to state each of the
tables names. And also that this would work so that you could only duplicate
tables that have a certain prefix, so: duplicate only tables that
les (exactly as they are, including
primary keys, data, etc) but at the same time change the prefix to something
else (ie: eng_) so that I would end up with:
pt_table1
pt_table2
pt_table3
en_table1 (exact copy of pt_table1, including data PK, FK, etc..)
en_table2 (exact copy of pt_table2, including d
I have some long VARCHAR fields that a user will sometimes sort on. Does
a prefix index in any way help with sorting or just for lookups? Will it
speed up a filesort? I couldn't find this information in "How MySQL uses
indices".
R.
--
MySQL General Mailing List
For list
50 AM
Subject: Re: Granting all to a user with a db name prefix
Paco Zarabozo A. wrote:
> Hello All,
>
> I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i
> can't find the way to so it on the documentation. Let's assume the usern
Paco Zarabozo A. wrote:
Hello All,
I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i
can't find the way to so it on the documentation. Let's assume the username
is "john". I want him to have all privileges only on databases with the
prefix jo
Hello All,
I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i
can't find the way to so it on the documentation. Let's assume the username
is "john". I want him to have all privileges only on databases with the
prefix john, so he can:
- create an
Jasper Bryant-Greene wrote:
> Michael's solution will not produce reliable results as it will return
> at least two results for many different phone numbers, with no way to
> tell which is the correct result.
As long as the database contains Abhishek's bogus "XYZ" and "ZXF" records,
yes. If the d
7;t claim to be an expert on phone numbers, but if
they're ambiguous, how do they work? That is, if a number can start with a
valid prefix for two different places, where does the call go? Surely, there
must be a way to parse a phone number that correctly directs the call. The
question t
Michael Stassen wrote:
Anyway, I just wanted to share these observations with the original
poster - and anyone else on the list who is following this issue - to
help put some perspective on the matter. Again, feel free to ignore me
if you like. :-)
All good points. As you say, if the numbers
Rhino wrote:
- Original Message - From: "Michael Stassen"
<[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 3:55 PM
Subject: Re: Mysql Finding the
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 3:55 PM
Subject: Re: Mysql Finding the country name from country
Rhino wrote:
- Original Message - From: "Michael Stassen"
<[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 1:11 PM
Subject: Re: Mysql Finding the
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 1:11 PM
Subject: Re: Mysql Finding the country name from country
Rhino wrote:
> If you parsed the first example, you might assume that I am in
> Brazil, because '55' is the country code for Brazil. (Country codes '5' and
> '555' are not in use at present.)
And they never will as long as "55" is in use, because then phone numbers
would become ambiguous.
Björn
Peter Brawley wrote:
abhishek jain,
>I need to find the country name from the country prefix so eg. i have
>a mysql table with prefix and name as the coumns and with datas like :
>1 USA
>11XYZ
>44UK
>91India
>92Pakistan
&g
Rhino wrote:
- Original Message - From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:10 AM
Subject: Mysql Finding the country name from country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the c
abhishek jain wrote:
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
mysql table with prefix and name as the coumns and with datas like :
Prefix, Name
1 USA
11XYZ
44UK
91India
92Pakistan
abhishek jain,
>I need to find the country name from the country prefix so eg. i
have
>a mysql table with prefix and name as the coumns and with datas
like :
>1 USA
>11 XYZ
>44 UK
>91 India
>92 Pakistan
>123 ZXF
You me
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:10 AM
Subject: Mysql Finding the country name from country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
mysql table with prefix and name as the coumns and with datas like :
Prefix, Name
1 USA
11XYZ
44UK
91India
92Pakistan
123 ZXF
and i
gt; >
> >Table should look like this:
> >UP01
> >UP02
> >UP03
> >
> >So the problem is, how can I grab the auto_increment number, then
> append the prefix while doing an insert?
> >
> >Can anyone give me some advice on this proble
ot; + the next "AUTO_INCREMENT"
Here is what I have.
category_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
Table should look like this:
UP01
UP02
UP03
So the problem is, how can I grab the auto_increment number, then append the
prefix while doing an insert?
Can an
TO_INCREMENT PRIMARY KEY,
Table should look like this:
UP01
UP02
UP03
So the problem is, how can I grab the auto_increment number, then append the
prefix while doing an insert?
Can anyone give me some advice on this problem?
Thanks,
Scott
--
MySQL General Mailing List
For
Hi,
We have inquired about this warning before, but now that we have
upgraded to 4.1, we know which query/table is causing these frequent
warnings:
050701 17:19:34 InnoDB: Warning: using a partial-field key prefix in
search.
InnoDB: index `rp_id` of table `as_imp/roundrobin_pub`. Last data
2 |
| EN05003 |
| EN05004 |
+-+
5 rows in set (0.00 sec)
Mathias
Selon Scott Purcell <[EMAIL PROTECTED]>:
> Hello,
>
> I have a table that has a varchar column in which I need to change a prefix
> for all records. Currently there are about 500 records and I did not wa
le via mysqldump, edit the flat file with a text editor so that all
'EN' become 'UP', then reload the modified data back into the database. A
lot more work but still do-able if there are some gotchas in the data that
you haven't told us about.
Rhino
- Original Message -
Hello,
I have a table that has a varchar column in which I need to change a prefix for
all records. Currently there are about 500 records and I did not want to do
this by hand. It looks like this:
[data here ]
UP05000
UP05001
UP05002
UP05003
The identifier has now changed to EN so each
end) {
/* The last field in key was not a complete key
field
but a prefix of it.
Print a warning about this! HA_READ_PREFIX_LAST does
not currently work in InnoDB with partial-field key
value prefixes. Si
In one of my logfiles I have quite repeatedly the following message:
InnoDB: Warning: using a partial-field key prefix in search
What does this warning mean ?
Regards,
Marc Mechain
Atos Origin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On Friday 03 January 2003 19:14, aman raheja wrote:
> How can I delete all tables starting with prefix 'abc' in the MySQL
> database (there
> are about 200 such tables).
> Wild cards?
Nope. You should use list of all tables in the DROP TABLE command if you want
to do it
Hi All
How can I delete all tables starting with prefix 'abc' in the MySQL database
(there
are about 200 such tables).
Wild cards?
Or if I just delete the files from the location where all the MySQL database
tables are
stored, what would happen ?
T
At 0:47 -0500 9/13/02, [EMAIL PROTECTED] wrote:
> > > 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory
>> > PREFIX. MySQL would then assign values that start with the prefix,
>> > followed by a sequential number.
>>
>> This works alrea
> > 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory
> > PREFIX. MySQL would then assign values that start with the prefix,
> > followed by a sequential number.
>
> This works already for MyISAM and BDB tables. From the manual:
>
> CREATE TABLE ani
m the specified range. Then, the user would
assign a different range to each replication master. Example of
proposed syntax:
CREATE TABLE example (id INT AUTO_INCREMENT RANGE 1-999 PRIMARY
KEY, other_column VARCHAR(100));
2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory
PREFIX. M
local.
>
> Any way to do this
>
> ./configure --prefix=/usr/local (default)
> make
> make install prefix=/home/turner/mysql/test
Not that I know of. I belive some of the paths are compiled into
MySQL, so recompilation is necessary.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PR
I guess
make install prefix=/home/turner/mysql/test
just isn't an option. How would I request this functionality be provided
in the make file?
Thanks, Dave Turner
On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote:
> Thanks, but what I need to do is have
>
>
Thanks, but what I need to do is have
make install install everything into /home/turner/mysql/test then I'll
check everything out to make sure it is how I want it and last I'll copy it all
to /usr/local.
Any way to do this
./configure --prefix=/usr/local (default)
make
make inst
On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote:
>
> I would like to make install to my home directory but can't seem to get it to
> work.
>
> make install prefix=/home/turner/mysql/test
>
> It keeps wanting to install to /usr/local even thoug
I would like to make install to my home directory but can't seem to get it to
work.
make install prefix=/home/turner/mysql/test
It keeps wanting to install to /usr/local even though I pass the prefix parm.
Thanks,
[EMAIL PROTECTED] wrote:
:>Description:
: ./configure --help
:claims that the default value of localstatedir is PREFIX/var, but
:after setting --prefix it appears to be still pointing to '/var'.
:
:>How-To-Repeat:
: ./configure --prefix=/opt/mysql-3.23.44
: make
: make inst
>Description:
./configure --help
claims that the default value of localstatedir is PREFIX/var, but
after setting --prefix it appears to be still pointing to '/var'.
>How-To-Repeat:
./configure --prefix=/opt/mysql-3.23.44
make
make install
./scripts/mysql_install_db
mkdi
If I have a table:
CREATE TABLE film (
title CHAR(200) NOT NULL,
INDEX title_index (title(5))
);
What is the underlaying reason why it is faster to index only a prefix of the title?
Is it always faster? even if i have a trillions of title 200 characters long
62 matches
Mail list logo
