Hi,
I tried to set it in mysqld and it still alphabetize the tables...
my mysqldump syntax is this.
mysqldump -acr c:\backup.sql prism
where prism is the database.
All I wanted to happen is for the the tables to be in order of referential integrity
NOT alphabetical
Heikki Tuuri <[EMAIL PROTEC
Hello,
Newbie. Be nice now it is the holidays or Santa will poop in your stocking
:-)
I am running snort. It was working fine.
I installed some other programs that use the mysql also. (can't recall
which or what I may have done) and now on a reboot I get this error :
Nov 27 23:07:06 spiderman sn
>
> From: "Paul F" <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri PM 04:35:04 CST
> To: "'mysql users'" <[EMAIL PROTECTED]>
> Subject: RE: Please analyze my project table design
>
>
> Thanks guys. I thought that normalization would refer to redundant info not
> necessarily the same column names? I
Hi again,
I have stored UTF-8 encoded usernames in a table and need a properly sorted
output. I tried with 'ORDER BY Name', but it won't sort extended ASCII
characters correctly by their values but rather by some similarity with
other letters. In my example, the Unicode character starts with a val
>
> From: Stefan Hinz <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri PM 04:45:24 CST
> To: [EMAIL PROTECTED]
> CC: David T-G <[EMAIL PROTECTED]>, mysql users <[EMAIL PROTECTED]>
> Subject: Re[3]: Please analyze my project table design
>
> >> % I don't know of a DB theory rule that says it's a bad i
If I understand correctly, the MySQL source is available. If you are familiar
with the code that registers/starts/stops services you might want to take a
look at it. You might even try sending that section of the code to the vendor
and challange him to tell you how it is non-standard.
Robert Rowe
In the last episode (Nov 29), David Garamond said:
> >It seems the string in CHAR/VARCHAR is stored as null-terminated ala
> >C. But why is record 3 rejected too?
>
> Ugh, never mind. I forgot about the automatic trailing blanks removal
> feature. Well, since trailing blanks are always removed, i
David Garamond wrote:
insert into t1 values (3,char(32));
Record 3, 5, and 7 is rejected due to duplicate value.
++--+--+
| id | length(code) | code |
++--+--+
| 1 |0 | |
| 2 |1 | 0|
| 4 |2 | 0 0 |
| 6 |
Can CHAR/VARCHAR store strings with nul (ASCII 0) in them? It seems it
can't. [I've used CHAR(2), VARCHAR(2), CHAR(2) BINARY, VARCHAR(2) BINARY].
===
create table t1 (
id int not null primary key,
code varchar(2) not null, un
Stefan:
I think you have just reinforced my position ... our contention is that
MySQL works the same way as any other application that installs as a
service.
We have a number of applications (written by our own programming staff) that
all use exactly the same procdure used in MySQL to install the
[EMAIL PROTECTED] wrote:
>> From: Bruce Therrien <[EMAIL PROTECTED]>
>> Date: 2003/11/28 Fri PM 01:42:14 CST
>> To: [EMAIL PROTECTED]
>> Subject: Retrieving info from a Joined column
>>
>> We have a column in our table that has
>> new info added each time using a JOIN function.
The data sample make
Gerald,
> How closely does the MySQL Service on Win32 platforms conform to any known
> standard for installing/removing services?
> I raise the question because the vendor that provides the utility we use to
> create our installation package claims that MySQL uses non-standard commands
> for inst
Paul,
> Thanks guys. I thought that normalization would refer to redundant info not
> necessarily the same column names? I would further see the problem with the
> design if say phone_number in the agent table and lawyer table contained the
> same data, which of course they won't.
The layout woul
>> % I don't know of a DB theory rule that says it's a bad idea to have the same
>> columns in many tables, but it might make the design more compact to take the
>> common stuff and put it into one table.
>> Oh, there is, indeed. CF "normalization" :-)
> Well of course, but that begs the quest
How closely does the MySQL Service on Win32 platforms conform to any known
standard for installing/removing services?
I raise the question because the vendor that provides the utility we use to
create our installation package claims that MySQL uses non-standard commands
for installing and removing
Thanks guys. I thought that normalization would refer to redundant info not
necessarily the same column names? I would further see the problem with the
design if say phone_number in the agent table and lawyer table contained the
same data, which of course they won't.
I thought about the "persons"
>
> From: David T-G <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri PM 03:49:17 CST
> To: mysql users <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED]
> Subject: Re: Please analyze my project table design
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi!
>
> ...and then [EMAIL PROTECTED] said.
If you are using the Load Data function then it doesn't matter. Load Data turns
indexing off and then rebuilds them at the end. If you are using normal inserts then
add the indexes after the import.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
...and then [EMAIL PROTECTED] said...
%
...
% I don't know of a DB theory rule that says it's a bad idea to have the same columns
in many tables, but it might make the design more compact to take the common stuff and
put it into one table.
Oh,
>
> From: "Paul Fine" <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri AM 11:14:25 CST
> To: <[EMAIL PROTECTED]>
> Subject: Please analyze my project table design
>
> Greetings, my "hands on" school project is a small real estate database.
>
> I am using MySQL 3.23 without InnoDB, but would like to m
>
> From: Bruce Therrien <[EMAIL PROTECTED]>
> Date: 2003/11/28 Fri PM 01:42:14 CST
> To: [EMAIL PROTECTED]
> Subject: Retrieving info from a Joined column
>
> We ahve a column in our table that has
> new info added each time using a JOIN function.
> The data is separated using a : separator.
Use GRANT ___your_permissions on database[s] to 'username'@'%'
IDENTIFIED BY 'his/her password'
% will be used if you don't want to restrict that user on a given host or
network
Otherwise, use 'username'@'host_name_or_ip_address' like
'emery'@'192.168.0.50'
if you omit the @ part, MySQL will
Hi Greg,
> Here's my situation. I'm implementing radiusd on a solaris box using
> a mysql database that's on a remote windows host. I've managed to get
> a user authenticaed (still with the CLID unknown message, but I'll
> move on. Hope that's OK to do.)
It's OK. Moreover, since that message i
Hi!
On Nov 27, Director General: NEFACOMP wrote:
> Hi groups,
>
> does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new
> passwords?
>
> When I create a password using PASSWORD( ), I can only login using the MySQL client
> (the one that comes with MySQL).
> But if I cr
We ahve a column in our table that has
new info added each time using a JOIN function.
The data is separated using a : separator.
How does one retrieve this info from the colomn and put it
into list format, or check for duplicates, or do a search
in the column for a certan string.
We use PERL f
Hi group,
I have a problem that I think is not very serious.
All the MySQL 4.1 binaries I downloaded from the MySQL website appear to be
max versions!!!
Ok, their names are mysqld-nt, mysqld, ... but when I do
SELECT version() I always get something containing a MAX thing.
I remember
Hi groups,
does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new
passwords?
When I create a password using PASSWORD( ), I can only login using the MySQL client
(the one that comes with MySQL).
But if I create the password using OLD_PASSWORD( ), I can login from both my
The Manual does not talk about that problem.
For example I have been forced to no longer use GRANT because it creates a
password with * thing at the beginning.
Instead, when I access the user table directly and use OLD_PASSWORD instead
of using PASSWORD, my clients login with no problem.
It seems
I would mysqldump it, tar it up and send it as an attachment
(hope it isn't too big.) Make sure to tell him to delete the
illegal line of --- before he tries to import it.
michael johnson wrote:
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
michael johnson wrote:
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)870 922 0247
Fax +44(0)1323 419554
email [EMAIL PROTECTED]
URL www.bpenet.
-> Subject: Send someone a database
->
-> Dear All
->
-> I want to send a MySQL database to a client by email. Which is the best
-> way
-> to do it?
Michael,
I usually just dump the database to a file, zip/rar/arj it and send as a
file attach.
Use mysqldump like this;
mysqldump -u USER -h HOS
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)870 922 0247
Fax +44(0)1323 419554
email [EMAIL PROTECTED]
URL www.bpenet.net
Also in Dublin & Lu
How are you starting mysql? as a service? I dont think it keeps a log
file by default.
If you are not starting mysql as a service, start it with the
--log-error=/var/log/mysqld --log-warnings
flags. If you are starting it as a service, add those flags to your
mysql file inside /etc/rc.d/init.
Hi
Im a more than a lil confused about how to set up multiple
users for EXTERNAL access to MySQL.
Ive granted permissions to the Local user, but how to I grant permissions
to external users ?
Sincerely,
--
M i l e s
President & Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 41
Hi
I am a webdesigner/hosting reseller
my question is this:
I am hosting various different CMS attached to mysql databases and hope
to host more in the future
How many different tables can I safely store in the same database?
I am currently storing tables from three different CMS on the same
data
May be this not the good mailing list. I have recently installed maxdb. I have create
succefully a database instance but when I try to launch it (admin or onlyne mode) I
have a runtime environment error saying I must have a look to the application event
log. Where could I found this apllication
Hi,
> I created a table as follows:
>
> mysql> CREATE TABLE test (
> -> age INT(3),
> -> CONSTRAINT CHECK (age > 0)
> -> );
> Query OK, 0 rows affected (0.00 sec)
>
> I then inserted -1 into the table, which it shouldn't
> have let me do.
>
> mysql> insert into test values (-1);
> Que
Greetings, my "hands on" school project is a small real estate database.
I am using MySQL 3.23 without InnoDB, but would like to migrate to 4.x
w/InnoDB at some point.
I would greatly appreciate any feedback on this design.
These are the business rules:
1) 1 matter may have several vendors and/
I created a table as follows:
mysql> CREATE TABLE test (
-> age INT(3),
-> CONSTRAINT CHECK (age > 0)
-> );
Query OK, 0 rows affected (0.00 sec)
I then inserted -1 into the table, which it shouldn't
have let me do.
mysql> insert into test values (-1);
Query OK, 1 row affected (0.00 sec)
m
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand clearly reading MySQL
manual.
Thanks for helping me :)
Hello
I recently downloaded 4.1beta
when i run the DB initialisation utilities I get
D:\MySQL\mysql\bin>mysqld-opt --skip-grant-tables
031128 16:18:09 Can't find messagefile 'I:\MySQL\share\english\errmsg.sys'
I:\MySQL was my old (now deleted) folder
I suspect that I can set the MySQL path via
Here's my situation. I'm implementing radiusd on a solaris box using a
mysql database that's on a remote windows host. I've managed to get a
user authenticaed (still with the CLID unknown message, but I'll move
on. Hope that's OK to do.) I had added that user manually from a mysql
command l
First off, I'd like to say hello. I just signed up for the list today.
I'm having some weird things happen on my slave server. I'll give more
details in a second, but to sum it up, its creating thousands of
'host-relay-bin' files and the 'host.err' file is getting filled with
what looks like
Sorry about the double posts...
But I forgot something...
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
> Can something be done so that mysql be case sensitive ?
If you only need case-sentivitity on selects read this:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
" The B
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
> Hello,
Hi
> The first think is that I cannot add a primary constraint on test because
> Mysql do not make the difference between 'bla' and 'BLA'. It is case
> insensitive. I have the same problem when I do: select * from test where
> valu
Hello,
I have a simple table test like
create table test (value varchar(10));
in witch I have insert two lines:
insert into test values('bla');
insert into test values('BLA');
The first think is that I cannot add a primary constraint on test because M
I have just moved from MS Access to MySQL, I haven't really got going
yet, and I am a little confused at how I interact with a db created in
MySQL. In the past I have always kept my database in its associated
website folder within wwwroot. However, I have been advised to keep it
in C:\mysql\dat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Binay --
Saw your post over in php-general but it's better over here :-)
...and then Binay said...
%
% Hi all !
Hi!
%
% I have two systems.
% one with mysql-version: 3.23.37
% other with mysql-version: 3.23.58
OK.
%
% now i want to take the
SQL
I have the same situation.
I set skip-name-resolve in my.cnf.
But sometimes mysqld get all CPU.
I can't notice strong dependences between name resoving and mysqld stuped.
> Hello,
>
> Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
> system. However, today, unexplicably
Hi all !
I have two systems.
one with mysql-version: 3.23.37
other with mysql-version: 3.23.58
now i want to take the backup of 3.23.37 data and copy to 3.23.58 ...
i know i can take backup using mysqldump command ... and then copy using mysql
commands
but as mysql create folder for ea
"Curley, Thomas" <[EMAIL PROTECTED]> wrote:
>
> Platform RH linux on Dell with MySql 4
>
> I changes the directory to where the data file was picked up from to a sy=
> mbolic link and now get the error
>
> Can't get stat of '/home/test/data_in/TEST.TXT' (Errcode: 13)
>
> So all I did was to cha
[EMAIL PROTECTED] wrote:
>>Description:
>
> The included sql test script (output of mysqldump 10.2 (create table statement and
> insertion of 250 records into this table) with added check for table integrity)
> results in corrupted table and error message 'Found key at page 36864 that poi
Hi all,
Platform RH linux on Dell with MySql 4
I changes the directory to where the data file was picked up from to a symbolic link
and now get the error
Can't get stat of '/home/test/data_in/TEST.TXT' (Errcode: 13)
So all I did was to change ~test/data_in to a sym link to ~txn/data_in
Anyo
Hi Dean,
>
> I have populated the database, which has 6319 records in the list_rank
table
> and 2472 records in the entry table. Everything looks fine, and I can
easily
> do the simple queries such as:
> mysql> select * from list_rank;
>
> However, when I run the following simple join, mysqld
Hi Dean,
If I'm not mistaken, it looks like you are just joining the two tables
(list_rank and entry) and not specifying which matching records you want
(with a "where..." clause), so mysql is matching each row in one table with
each row in the other table. That will be a HUGE result set, so it w
I am running mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
on redhat 9. I have defined a simple database as follows:
DROP DATABASE IF EXISTS xhistory;
CREATE DATABASE xhistory;
USE xhistory;
CREATE TABLE category
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
parent_id INT,
IND
hi all,
I've searched a bit, but didn't find any documentation on how to use unicode in mysql
4.0.14 or 4.0.X. Any ideas or links?
Thanx in advance
Nitin
57 matches
Mail list logo
