if I switch name to TINYTEXT and index 'name' to (name(255),ppathref),
will it handle utf8? that is the prefix of 255 chars or 255 bytes?
CREATE TABLE paths (
id int(11) NOT NULL auto_increment,
typeref tinyint(4) NOT NULL default '1',
name varchar(255) NOT NULL default '',
ppathref i
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
google pulls up many instances of this error from several
'different' servers, you might lookinto the software.
http://www.google.com/search?num=50&hl=en&lr=lang_en&safe=off&q=%
27kessler%2Fproducts.frm%27&btnG=Search&lr=
The reason for that
FIXED...
I did a chmod +rwx on the directory, and now all is well.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all the parent dirs +x ?
what is the ouput is the show databases?
On Sat, 3 Sep 2005, Brian Dunning wrote:
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
it could be that the permissions are wrong, too.
The permissions for all the files in there are -rwxrwxr-x ...I don't know if
that's w
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
it could be that the permissions are wrong, too.
The permissions for all the files in there are -rwxrwxr-x ...I don't
know if that's what they should be or not.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
google pulls up many instances of this error from several
'different' servers, you might lookinto the software.
http://www.google.com/search?num=50&hl=en&lr=lang_en&safe=off&q=%
27kessler%2Fproducts.frm%27&btnG=Search&lr=
The reason for that is
There are no backups, unfortunately. I do have admin access. It's a
RaQ if that makes any difference. I did find the database files at
another location,
/vol/hdd/mysql/kessler/products.frm and everything else.
On Sep 3, 2005, at 1:24 PM, Jason Pyeron wrote:
are there backups of this mach
what portal software is this?
google pulls up many instances of this error from several 'different'
servers, you might lookinto the software.
http://www.google.com/search?num=50&hl=en&lr=lang_en&safe=off&q=%27kessler%2Fproducts.frm%27&btnG=Search&lr=
it could be that the permissions are wrong
are there backups of this machine?
do you have administrator access?
does kessler/products.frm still exist? [likely:
/var/lib/mysql/kessler/products.frm]
On Sat, 3 Sep 2005, Brian Dunning wrote:
My web site has always worked, I didn't change anything, so whatever is
causing this error happened
My web site has always worked, I didn't change anything, so whatever
is causing this error happened all by itself:
#1017 - Can't find file: './kessler/products.frm' (errno: 13)
In phpMyAdmin, it shows the tables are "in use" and there's no way to
execute a repair or anything. I don't know wh
Raymond,
>I am new to Mysql and am working a project where I want a user
to
>be able to see some records but not all records in a particular
table.
That's what the WHERE clause of SQL's SELECT statement is for. Read the
MySQL tutorial (http://dev.mysql.com/doc/mysql/en/tutorial.html) and
the
At 15:39 -0400 9/3/05, Jason Pyeron wrote:
I have found out that some files on the system, have trailing spaces...
To make matters worse I have found 'file ' and 'file ' both exist,
breaking constraint "name".
So am I better off going to TINYTEXT or VARBINARY(255) for the name field?
VARBI
Hi,
This is a design question.
the selection of data types must be intergrated to your application.
If you have a table with :
name type
apple fruit
redcolor
a simple query like
select * from tbl where type ='fruit' will give only fruits to the users.
You can if you have mysql 5.x create
I have found out that some files on the system, have trailing spaces...
To make matters worse I have found 'file ' and 'file ' both
exist, breaking constraint "name".
So am I better off going to TINYTEXT or VARBINARY(255) for the name field?
That said another way, will TINTTEXT break the in
> Trouble is, I dont start mysqld with the --log= option,
> and yet it still insists on logging. How do I disable this?
> (My current method is to use --log=/dev/null but I'm sure
> this cant be the best way). I cant find any evidence of
> a my.cnf anywhere, so I dont think it is due to an unexpect
I am new to Mysql and am working a project where I want a user to be able to
see some records but not all records in a particular table.
I am assuming that I would need to create a subset table based on the original
table and give the user access to only the subset table.
Is it possible to do thi
Hi,
I hacked the Makefile so that it would recompile it with
-debug on the version. I started it with "--debug" as part of the
extra args passed to safe_mysqld. It started, and created a
/tmp/mysqld.trace where its logging to.
So far, no one with a broken reverse DNS has tried t
YL,
>Thansk Peter. find_in_set does the job. column 'options' is odd from
>database design point of view. While from app developers' view, it's
>much easier to retrieve the option id array from one column. where
>the order matters (although this can be done with an option
association
>table).
Someone kindly replied to my log query today, but I unfortunately
deleted the message.
They referred me to this URL:
http://dev.mysql.com/doc/mysql/en/query-log.html
Trouble is, I dont start mysqld with the --log= option,
and yet it still insists on logging. How do I disable this?
(My current met
Privet.
> SELECT SQL_CACHE id, program_name, categor, subcategor, subsubcategor,
> subsubsubcategor, source_url, rating, short_description, long_description,
> when_modifed+0, author, searched_words, size_in_kb, licence, language,
> install, win95, win98, winme, winnt, win2000, winxp, wince
Hello.
> I've also discovered that its generating log entries (I've got a
> 3 Gbyte log file) even though I havent asked for them.
You may want to disable the general log where errors are written. See:
http://dev.mysql.com/doc/mysql/en/query-log.html
http://dev.mysql.com/doc/mysq
Hello.
There is an example:
http://lists.mysql.com/mysql/175004
"Alvaro Cobo" <[EMAIL PROTECTED]> wrote:
> Hi guys:
>
> This is probably an off-topic, and more related to PHP, but it is related to
> mysql as well
>
> I need to execute two insert queries into a single statement fr
Thansk Peter. find_in_set does the job. column 'options' is odd from
database design point of view. While from app developers' view, it's
much easier to retrieve the option id array from one column. where
the order matters (although this can be done with an option association
table).
mysql> select
Hello.
To make the suggestions, we should have enough amount of information.
If your MySQL server isn't heavy loaded, create a trace file and find
out the place where the new connections hang. See:
http://dev.mysql.com/doc/mysql/en/making-trace-files.html
Tuc at T-B-O-H <[EMAIL PRO
Hi there,
I am running MySQL 4.1 on Linux.
I have some problems sorting records with german umlauts.
MySQL is configured to have character set "UTF8" as default.
I have created a table like this:
CREATE TABLE tblmembers (
memberid int(11) NOT NULL auto_increment,
lastname varchar(255) NOT N
>
> Hello.
>
> In my opinion, we're a little kinked in this issue. Let's start over.
>
:( Sorry. I've been told by the GF that I have a habit of
doing it to her too.
>
> In one of your posts you mentioned that the server runs lots
> of other services besides the database.
>
Yes,
Alan Williamson wrote:
>>I have made a user with the following command:
>>GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
>
> Silly question Morten, and I am sure you have probably done it, but
> you are definitely running:
>
> % mysql> FLUSH PRIVILEGES;
You only need to FLUSH PR
Hello.
In my opinion, we're a little kinked in this issue. Let's start over.
In one of your posts you mentioned that the server runs lots
of other services besides the database. Why do you think that
the cause of the server's weird behavior is MySQL? Is server still
working, but you are unab
Hi,
Yes I want only 24 hours of business program, and like you've said I
do not want to include Saturday and Sunday, since nobody is working in
the week-end.
Thank you very much for the help.
Best regards and have a nice week-end,
Cristi Stoica
Michael Stassen wrote:
inferno wrote:
>
I think that your solution is also a generic one.
But i thought that since saturday and sunday are not business days, the query
will not be played.
On monday 08h00, we know that there is no new records in the table.
I encourage Crisiti to study this solution also.
Mathias
Selon Michael Stassen
30 matches
Mail list logo
