[EMAIL PROTECTED] wrote:
Hello,
Is there anything we can do to help the MySQL project, we are firm believers
and would like to contribute in some way.
We have a several 100 mps connections and server space.
Thank you,
Charles
DWHS Inc. Manager
http://www.dwhs.com
http://www.dwhs.com/hostingf
Hello,
Is there anything we can do to help the MySQL project, we are firm believers
and would like to contribute in some way.
We have a several 100 mps connections and server space.
Thank you,
Charles
DWHS Inc. Manager
http://www.dwhs.com
http://www.dwhs.com/hostingforum/
https://dwhs.net/secu
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
You can set character set for each column or set default character set for each
table when CREATE TABLE.
Also you can set default character set for each database when CREATE DATABASE.
- Original Message -
From: "Dave M G" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 15, 2006 1:54 A
Is this the only way? I was hoping that phpMyAdmin would have a nice
function for this. What is the reason for not being able to use String types
when using UFT-8? Maybe I have to learn more about the UFT-8 to find the
answer about that?
Best regards,
Peter Lauri
_
From: Gabrie
Hi folks.
I've been compiling my own apps for over a decade, but it seems like
it's time to get -with- the times, and start using precompiled binaries
more.
So I got a set of matching set of precomiled apache2/mysql5/php5 off of
ibiblio for a Solaris 9/Sparc box.
However, even though I have apa
Scott Klarenbach wrote:
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances w
I'm having some issues creating a stored procedure to optimize tables
in the database.
PREPARE accepts only CREATE TABLE, DELETE, DO, INSERT, REPLACE, SELECT,
SET and UPDATE.
PB
-
DreamWerx wrote:
I'm having some issues creating a stored procedure to optimize tables
in the database.
> -Original Message-
> From: Gordon Bruce [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 14, 2006 15:42
> To: [EMAIL PROTECTED]; gerald_clark
> Cc: mysql@lists.mysql.com; David Godsey
> Subject: RE: Byte Swapping (Re Post)
>
> If the order of the bytes is opposite between big-endian
If the order of the bytes is opposite between big-endian and
little-endian, then if you can get the bytes in a string REVERSE()
should flip the order.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 14, 2006 3:25 PM
To: gerald_clark
Cc: mysql@l
gerald_clark <[EMAIL PROTECTED]> wrote on 02/14/2006
03:59:21 PM:
> [EMAIL PROTECTED] wrote:
>
> >"David Godsey" <[EMAIL PROTECTED]> wrote on 02/14/2006 03:28:41
PM:
> >
> >
> >
> >>Well, just thought I'd try one more time because I didn't get an
answer
> >>
> >>
> >to
> >
> >
> >>my quest
If you have not installed MySQL before, you must create the
MySQL grant tables:
shell> scripts/mysql_install_db --user=mysql
Keith
In theory, theory and practice are the same;
In practice they are not.
On Tue, 14 Feb 2006, Ravi Kumar wrote:
> To: Imran Chaudhry <[EMAIL PROTECTED]>
> From:
It looks more like you haven't run the mysql_install_db script.
>From the manual :
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
If necessary, run the mysql_install_db program to set up the initial
MySQL grant tables containing the privileges that determine how users
are all
[EMAIL PROTECTED] wrote:
"David Godsey" <[EMAIL PROTECTED]> wrote on 02/14/2006 03:28:41 PM:
Well, just thought I'd try one more time because I didn't get an answer
to
my question last time.
So what I have is a random data stream that is sent in raw form, and
based
on
Imran,
I noticed couple of permissions were not correct.I changed mysql.mysql.
Still Ihave been getting following errors.
060214 15:53:05 mysqld started
060214 15:53:05 InnoDB: Started; log sequence number 0 43655
060214 15:53:06 [ERROR] Fatal error: Can't open and lock privilege tables:
T
"David Godsey" <[EMAIL PROTECTED]> wrote on 02/14/2006 03:28:41 PM:
> Well, just thought I'd try one more time because I didn't get an answer
to
> my question last time.
>
> So what I have is a random data stream that is sent in raw form, and
based
> on some data definition, I can assemble with
Well, just thought I'd try one more time because I didn't get an answer to
my question last time.
So what I have is a random data stream that is sent in raw form, and based
on some data definition, I can assemble with the correct data types and
such. One of my requirements is that I have to store
"Vinay" <[EMAIL PROTECTED]> wrote on 02/14/2006 02:29:45 PM:
> Hi,
>I am trying to create a view by joining two tables.These tables
> have a common column which references their parent table. I get the
> following error when I try to create a view.
>
>
> create view trn2 as select * from d
Hi,
I am trying to create a view by joining two tables.These tables have a
common column which references their parent table. I get the following error
when I try to create a view.
create view trn2 as select * from dbtmsg,dbtrbl where dbtmsg.accxsk=-1
ERROR 1060 (42S21): Duplicate colu
I'm having some issues creating a stored procedure to optimize tables
in the database. I'm pulling the table names from the information
schema. The tablename doesn't seem to be correctly being replaced in
the optimize command..
I've tried used prepared statements which seem to correctly replace
Amy,
You didn't mention what the problem is with your query...
select reference.uid
from reference, subject_name, ref_cat
where subject_name.sub_id = '45'
and ref_cat.ref_cat_id = '3'
and ref_cat.ref_cat_id = reference.ref_cat_id
and subject_name.sub_id = ref_cat.sub_id
IAC it is easier to unde
Hi,
The precise instructions are here:
http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html
You can start your server specifying the character set
(http://dev.mysql.com/doc/refman/5.0/en/charset-server.html), and alter the
databases (http://dev.mysql.com/doc/refman/5.0/en/charset-databa
I haven't tried the migration toolkit so I don't know what it can or
cannot do. I am assuming that you have hand-transferred a few users from
your old system to the new one.
What I can suggest is that you generate two sets of data. The first is a
list of your users, their hostnames, and their
detailed info here:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
Thank you for that link. I think this is the heart of the issue.
Following the advice on the web page, I ran these commands:
SET NAMES utf8;
SET CHARACTER_SET utf8;
But I can check my MySQL system variables i
On Tue, 14 Feb 2006, Amy Thornton wrote:
> I am trying to join 3 tables together.
>
> Table A has 3 fields: sub_id, subject, id
> Table B has 3 fields: ref_cat_id, sub_id, ref_cat
> Table C has 7 fields: uid, ref_cat_id, etc.
>
> I am trying to join Table A and B over sub_id and join B and C over
Does anyone have any idea on this one?
- Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 2/10/06 3:09 PM >>>
I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0
system. It doesn't appear that it can successfully migrate my usernames and
privileges. Is it supposed to be able to an
I am trying to join 3 tables together.
Table A has 3 fields: sub_id, subject, id
Table B has 3 fields: ref_cat_id, sub_id, ref_cat
Table C has 7 fields: uid, ref_cat_id, etc.
I am trying to join Table A and B over sub_id and join B and C over ref_cat_id
while pulling in the value of sub_id and r
Interesting... maybe this is because the fill is not actualy stored in the
database... and being sorted/compared as a number MySQL removes the ZEROFILL
!
You can go and do:
select BINARY * from a
union
select BINARY * from a;
--
Gabriel PREDA
Senior Web Developer
On 2/14/06, Juri Shimon <[EMAIL
Hello mysql,
Union on zerofilled fields eats 'zerofilling'.
How to repeat:
> create table a (id integer zerofill);
> insert into a values(1),(2),(3);
> select * from a;
++
| id |
++
| 01 |
| 02 |
| 03 |
++
> select * from a u
-Original Message-
From: Skarlatos, Matthew P.
To: 'mysql@lists.mysql.com'
Sent: 2/13/2006 8:37 AM
Subject: Any help with resetting the administrative password using
'mysqld_safe' w/ the --init-file option
Has anyone run into a problem with setting the root user password in
mysql using
On 2/14/06, Ravi Kumar <[EMAIL PROTECTED]> wrote:
> Starting mysql with root.I tried withn mysql user account also but still same
> error.
> thanks
Ravi,
Assuming you are starting MySQL with mysqld_safe, then it will invoke
the MySQL server as the mysql user.
I suspect the cause is that /var/l
Starting mysql with root.I tried withn mysql user account also but still same
error.
thanks
"Peter M. Groen" <[EMAIL PROTECTED]> wrote:
On Tuesday 14 February 2006 00:28, Ravi Kumar wrote:
> Permission denied 060213
I assume you are starting MySQL NOT as root..
Has the user write permiss
Hi Peter,
That will be a lot of work !
*1.* First make a back-up... it's always a good ideea !
*2.* For every table in the database alter String Types into BINARY string
types
that means:
- *(VAR)CHAR(M)* will become *(VAR)**CHAR(M) BINARY* or *(VAR)**BINARY(M)*
- *TINYTEXT, TEXT, MEDIUMTEXT,
Hi,
I have a database with around 40 tables that needs to be converted to UTF-8
to support multi languages. What is the best procedure to do this?
And is it any way to change the default charset to UFT-8 so tables by
default will become UFT-8?
And can I have one table with different fi
34 matches
Mail list logo
