On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
>
> In that case, i would highly recommend using mysqldump to backup
> your databases. Simply compressing the actual DB's could give you
> tables in inconsistent states, UNLESS you first shut down your DB
> server, then run the back
On Sun, 2002-02-17 at 02:54, Alex Charlton wrote:
> Hi all,
>
> I was wondering if there is any chance that table information is compatible
> between Windows and Linux?
Hi Alex,
MyISAM tables are (mostly) OS and platform independent. You should be
able to copy them between Linux and Windo
Hi all,
I was wondering if there is any chance that table information is compatible
between Windows and Linux?
IE. If I copy windows data files to a linux server, can mySQL on the linux
server read this data?
I don't believe this is possible, but I couldn't find any posts and wanted
to confirm.
At 22:47 -0500 2/16/02, John Fulton wrote:
>Would someone please tell me how to insert sets into a MySQL DB?
>e.g. insert into table_name (x) values ("'a', 'b', 'c', 'd'"); ,
>where x is a set. I am unsure on what should be inside of the second
>set of parentheses.
A SET value is a single strin
At 23:29 16/02/2002 -0500, Loretta wrote:
Hi!
>Hello everyone:
>
>I am hoping you can help me. I have Windows 98 SE as my operating system.
>I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but
>could not make them work together. Hopefully, someone will be able to help
>m
Hello,
I'm sure this is a rehash of a common benchmark installation problem, but my
searches have not yielded a satisfactory answer. I've been digging through
some old threads related to this subject, but I'm still unable to find
MySQL-DBI-perl-bin that is required by MySQL-bench-3.23.48-1.i38
Hello everyone:
I am hoping you can help me. I have Windows 98 SE as my operating system.
I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but
could not make them work together. Hopefully, someone will be able to help
me.
The error I am getting is
InnoDB: Warning: ope
Would someone please tell me how to insert sets into a MySQL DB?
e.g. insert into table_name (x) values ("'a', 'b', 'c', 'd'"); ,
where x is a set. I am unsure on what should be inside of the second
set of parentheses.
Sorry to be posting a syntax question to the list, but I don't see it
s
> I am new to the subject. I am experimenting in mysql via PHP with a nice
> book (PHP and MySQL
> Web development). My question is how many queries to mysql, made via
> PHP, should considered
> ok for efficiency. I know it has much to do with the size of databases,
> but I would like to get an
>
Hello
I am new to the subject. I am experimenting in mysql via PHP with a nice
book (PHP and MySQL
Web development). My question is how many queries to mysql, made via
PHP, should considered
ok for efficiency. I know it has much to do with the size of databases,
but I would like to get an
idea
> Hello,
> Just recently I started having problems creating and deleting databases...
> When I login as the user root I get this error when I try and create or
> delete a DB.
>
> ERROR 1006: Can't create database 'tier2'. (errno: 13)
>
> I am fully aware that the errno: 13 is a permissions denied
I currently have a PHP script performing the following query
mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1)
It works great except that the search is coming out case sensitive.
According to the MySQL Docs all searches are done without case sensitivity.
I just have
Hello,
Just recently I started having problems creating and deleting databases...
When I login as the user root I get this error when I try and create or
delete a DB.
ERROR 1006: Can't create database 'tier2'. (errno: 13)
I am fully aware that the errno: 13 is a permissions denied error
In that case, i would highly recommend using mysqldump to backup your
databases. Simply compressing the actual DB's could give you tables in
inconsistent states, UNLESS you first shut down your DB server, then run the
backup.
Something to think about.
j- k-
On Saturday 16 February 2
Sorry, I forgot to ask the folowing as well. When considering the amount
by which text can be compressed as compared to other data types, would
it be better to store numerical values as text or to store them as
integer/float values. If the db needs to be compressed and backed up on
a bi-weekly bas
would probably be very dependent on the data within the database. if it's
a lot of text data, then very compressable, as text typically compresses
nicely. if you store a bunch of binary data (images or something), then
probably not as much...
tar your mysql dir and gzip it, or gzip -9 or bzip2
Hi list,
How compressible is a typical MySQL database? Is this more dependent on
the type of columns used i.e. a lot of text columns as opposed to a lot
of columns containing integer values?
The uncompressed size of the database is in the region of about 800-MB.
Also will it suffice to only comp
well I am running suse linux 7.3 and well to be honest I am a real
newbie, so here I go> I am gettingh this error msg>
cant connect to local mysql server through socket
/var/liv/mysql/mysql.sock
so what should I do_ what does this error msg mean_ cheers
-
At 17:59 16/02/2002 +0100, Roger Baklund wrote:
Hi,
>Thanks for the detailed reply. :)
>
>I did my tests on a pretty old version, 3.23.30-gamma, on a win2k machine. I
>was not aware of the lower_case_table_names variable. (This explains why I
>got lower case filename in my error message, while Fr
Hi Shankar,
This is your old buddy Scott S.
Try order by rather than group byThis will get you what you are looking
for
Scott Salisbury
- Original Message -
From: "SankaraNarayanan Mahadevan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2002 3:42 PM
hi all,
i have a problem in mysql query...
lemme state the scenario...
i have a table 'UploadDetails' in which i am storing
data regd files...
the fields are:
FileName, Title, Designer, UploadedBy, SubmittedDate
i want to get details about whose files are designed
by who..etc...
that is i need
hi all,
i have a problem in mysql query...
lemme state the scenario...
i have a table 'UploadDetails' in which i am storing
data regd files...
the fields are:
FileName, Title, Designer, UploadedBy, SubmittedDate
i want to get details about whose files are designed
by who..etc...
that is i need
> tar -xvfz mysql-3.23.32.tar.gz
> tar: Cannot open z: No such file or directory
> tar: Error is not recoverable: exiting now
> Any Help? Should there be a z: directory? And where?
Try:
tar zxvf mysql-3.23.32.tar.gz
z = gzipped
x = eXtract
v = verbose
f = file
You had a 'z'
On Fri, 2002-02-15 at 02:44, Alex Aulbach wrote:
> Wednesday, from David Axmark:
> > > Your other point about exact vs. approximate answers is unclear, I expect
> > > that Google's answers are exact for their currently available indexes at any
> > > given time. But even if they are approximate, I
While untarring MySQL on a RAQ3 using:
tar -xvfz mysql-3.23.32.tar.gz
I recieved the following errors:
tar: Cannot open z: No such file or directory
tar: Error is not recoverable: exiting now
Any Help? Should there be a z: directory? And where?
Doug Cotton <[EMAIL PR
On Tuesday 12 February 2002 09:16, Rich wrote:
> David yahoo wrote:
> > hi all,
> >
> > This question is a little like the suse update.
> > But perhaps I could find answer.
> >
> > I have a mandrake distrib with rpm support, u know that mandrake is
> > derive from redhat.
> >
> > Can I install a m
I just reinstalled MySQL 4.01 (Mandrake 8.1) and am having a problem
using the GRANT statement. When trying to grant privileges in a
database, I get an error message that the User table is read only. I've
checked the permissions and they're OK, includes read and write.
Am I looking at the right
* [EMAIL PROTECTED]
> In Re: Selecting records with the highest value no greater than
> x, <[EMAIL PROTECTED]> wrote:
> >
> >IMO, there is one, if I did understand the question correctly:
> >
> >SELECT * FROM NEWS WHERE RATING <= 4 ORDER BY RATING DESC,
> > RAND() LIMIT 1;
> >
> >This give back a
* Miguel Angel Solorzano
> * Roger Baklund
>> mysql> rename table U1 to U2;
>> ERROR 7: Error on rename of '.\test\u1.MYI' to '.\test\u2.MYI' (Errcode:
13)
>> mysql> alter table U1 rename as U2;
>> Query OK, 0 rows affected (0.01 sec)
> How you can see we don't have a constant behavior of th
>
>You're stumped!? Where does that leave us? Unfortunately (AFAIK) the sample data you
>have enclosed does not
>demonstrate the condition you seek to describe - perhaps it would have been better if
>you gave us a replicable
>example, so that we can UNDERSTAND the problem before we try to help
Martin,
-Original Message-
From: "Martin Bratbo" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Date: Saturday, February 16, 2002 4:46 PM
Subject: Re: Re: Foreign keys in InnoDB tables
>Heikki
>here is the statements that i cant get to work:
>first I create one innoDB table: fk
Michael,
Friday, February 15, 2002, 4:08:42 PM, you wrote:
MH> Hi mysql list members,
MH> We use the following statements to setup users and rigts for a mysql
MH> server which is accessible locally and via internet:
MH> INSERT INTO mysql.user VALUES
MH> ('%','xyz00',PASSWORD('...'),
MH> 'N',
Lonnie,
Friday, February 15, 2002, 8:11:59 PM, you wrote:
LC> Hello All,
LC> I am new to this list and hope that someone could answer this
LC> question for me.
LC> I am running on a fresh install of Redhat 7.2 and am trying to
LC> connect to MySQL from a program that I have to test the connect
Søren,
Saturday, February 16, 2002, 2:59:02 PM, you wrote:
SN> I'm a total newbie to MySQL, so I'm reading the documentation right
SN> now. In "General Security" I read that "SHOW GRANTS" should give me a
SN> picture of who has what rights, but if I use "SHOW GRANTS" I get the
SN> following erro
Søren,
Saturday, February 16, 2002, 3:11:40 PM, you wrote:
SN> I want to try out MySQL-GUI from my workstation, and I want to connect
SN> to my database server, but it says that root has no access rights from
SN> this host. How do I give root this kind of acccess?
You should set privileges for
Søren,
Saturday, February 16, 2002, 3:11:40 PM, you wrote:
SN> I want to try out MySQL-GUI from my workstation, and I want to connect
SN> to my database server, but it says that root has no access rights from
SN> this host. How do I give root this kind of acccess?
You should set privileges for
Heikki
here is the statements that i cant get to work:
first I create one innoDB table: fk1
create table fk1( noegle integer primary key, tekst varchar(20))type=InnoDB;
then I create a second InnoDB table: fk2which references the first:
create table fk2( prim integer primary key, frem intege
> Have you optimized the settings in my.cnf and checked your slow
> queries?
No, I haven't optimized my.cnf - looking at it now. Thanks.
Well, that was pretty much what I was hoping this "tool" could do; go though
the trace log and print out the slow queries. Is the only way to go manually
thoug
You can SHOW GRANTS FOR foo which gives you information about user 'foo'.
To show info about everyone, use SELECT * FROM user;
hth
Doug
On Sat, 16 Feb 2002 13:59:02 +0100, Søren Neigaard wrote:
>I'm a total newbie to MySQL, so I'm reading the documentation right
>now. In "General Security" I re
Hi,
I'm very new to database design and have developed an application running on
M$ Access and am currently in the process of moving the back end to MySQL,
mainly to make use with a website easier.
All is fine except for one query which contains a sub select so therefore
will not work.
The quer
Søren Neigaard writes:
> I want to try out MySQL-GUI from my workstation, and I want to connect
> to my database server, but it says that root has no access rights from
> this host. How do I give root this kind of acccess?
>
> --
> Med venlig hilsen/Best regards,
> Søren Neigaard mailto:[EMAIL P
I want to try out MySQL-GUI from my workstation, and I want to connect
to my database server, but it says that root has no access rights from
this host. How do I give root this kind of acccess?
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
"Sometimes I think we'r
I'm a total newbie to MySQL, so I'm reading the documentation right
now. In "General Security" I read that "SHOW GRANTS" should give me a
picture of who has what rights, but if I use "SHOW GRANTS" I get the
following error: ERROR 1064: You have an error in your SQL syntax near '' at line 1
What a
Vipul Kotecha writes:
> Hi List,
>
> I am new to the MySql C++ API and I am compiling one file it gives me error
> saying
>
> Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected
> Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
> Error E2275 ..\..\include\sqlplus\re
Hi Benjamin,
> > INSERT INTO mysql.db VALUES
> > ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>
> Has the second line anything to do with the behaviour? It shouldn't as
> you use "xyz00" below and user field will match only the user name
> 'xyz00_%'.
nope, has nothing to do
Luie,
> Wouldn't replace change all the entries in your table row, same effect as update?
> I believe the question is how to test which entry in a form has a new value and
>replace/update only that value
in the table.
> If I have a form...
>
> __
> |Employee Reco
In Re: Selecting records with the highest value no greater than x,
<[EMAIL PROTECTED]> wrote:
>
>IMO, there is one, if I did understand the question correctly:
>
>SELECT * FROM NEWS WHERE RATING <= 4 ORDER BY RATING DESC, RAND() LIMIT 1;
>
>This give back a random news entry of the highest score
Richard,
> I'm stumped -- which isn't saying much because I'm hardly a scientist.
> I am struggling to write a query that will tell me how many times a new
> volunteer ( defined as a volunteer who has never worked a shift ) did
> not show up for his shift (first shift). From my data I would
> ev
Hi.
A little explanation of the table usage would have been nice.
E.g. it's not clear to me, if shift 232 is also listed in the "shifts"
table or not. I presume the latter from now (in which case "shifts"
is more like a "did_show_shifts").
Also, you did not specify what special cases are to be t
I want to run a query like:
select * from table order by rand() limit 3
in MySQL it would work but I need to run it in MSSQL. I've been searching
for a limit function in MSSQL and I can't find a way to do it. I'm
experienced with MySQL but know nothing about MSSQL. If someone could point
me i
50 matches
Mail list logo
