Hello Sam,
Thursday, March 28, 2002, 10:21:39 AM, you wrote:
SI> > The good solution for this would be to put OOPS behind of apache.
SI> What is OOPS ?
The OOPS is squid-like PROXY application which mostly used as WEB
accelerator (server side proxy). The main idea of using it with
PHP/MYSQL
Hi there
The database is now running, i've created my tables and put the data
inside. This is fine.
Next step is to create a PHP-Website which communicates with the
database, but i am not able to connect over my apache (this is what it
seems to me).
to log into the database I use
> mysq
Hi!
Check your my.cnf file for the line :
socket =
Then change the path to /tmp/mysql.sock or create a symbolic link
/tmp/mysql.sock to the path that was inthere.
Restart mysql and that should get you going.
EG
>
> Hi there
>
> The database is now running, i've created my table
Correction!
Look for the line socket in the [mysqld] section!
EG
Hi!
Check your my.cnf file for the line :
socket =
Then change the path to /tmp/mysql.sock or create a symbolic link
/tmp/mysql.sock to the path that was inthere.
Restart mysql and that should get you going.
EG
>
* Chetan Lavti
> > Is it possible to run the MySQL Server from the remote machine..??
> > Mysql provides a Api's for shutting down the server from the remote
> > place i.e. ( mysql_shutdown(mysqlhadler))
> > but I can't see any api for starting the Mysql server from the remote
> > machine.
The cl
Hi can someone confirm that one does not need to create a tld file ie
tag lib descripter and deploy to my META-INF subdirectory of my root
application. Also does one need to add the taglib element to my web.xml
file and a jsp page directive.
The reason is i didn't require any of these procedur
Thank you very much
it workes now.
Could you tell me, how come, that the search-path points to /tmp/mysql.sock?
I've just created a link, but isn't it possibly to change the apache of
trying to connect to /tmp/mysql.sock?
thnax
dcp
Me& wrote:
>Correction!
>
>Look for the line socket in the [
Hi!
I was running an application that connected to a MySql server on the same
computer (workstation W2K). There was no problem.
However, I've tried to install the same system (application and MySql
server) on a Windows server, and the application fails to connect to the
server.
With the workstatio
Hi can someone confirm that one does not need to create a tld file ie
tag lib descripter and deploy to my META-INF subdirectory of my root
application. Also does one need to add the taglib element to my web.xml
file and a jsp page directive.
The reason is i didn't require any of these procedur
On 27-Mar-2002 Ken Anderson wrote:
>
>
>
>
>
> What is the fastest way to check if a table exists?
> Do a select and catch the error?
> Try to create the table, and catch the error?
> Other options?
> Thanks,
> Ken
Yes, in php:
function tableexists($tbl) {
$res = @mysql_query( "
Hi!
I'm not very used to php but its in php.ini :
mysql.default_socket
EG
- Original Message -
From: "Dennis Peyerl" <[EMAIL PROTECTED]>
To: "Me&" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 1:00 PM
Subject: Re: New Problem with LAMP (CORRECTIO
Ryan,
Thursday, March 28, 2002, 7:22:47 AM, you wrote:
RC> I'm working on a MySQL permissions problem, and would welcome some
RC> suggestions and/or comments, or to be pointed in the right direction. The
RC> goals I have are:
RC> a) Limit users to specific db's (no access to mysql.*/etc.)
You
thien,
Thursday, March 28, 2002, 11:05:27 PM, you wrote:
t> I am a developer of My SQL, and I am developing an application use unicode
t> so I would like to ask you which version that support Unicode and where can
t> I get it.
t> Now I am using My SQL version 3.23.49
t> thanks alots
MySQL doesn'
Voytek,
Thursday, March 28, 2002, 6:54:13 PM, you wrote:
VE> I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came with
VE> it,
VE> the installed MySQL did NOT have InnoDB support;
VE> I then d/l off mysql.com
VE> MySQL-Max-3.23.49a-1.i386.rpm
VE> I installed it using:
VE> rpm
I am a new comer to the sql world. I have some but brief knowledge of perl.
here goes!
I am using mysql on a Winnt platform and I have perl 5 installed on it. I
did setup dbi in perl and I know that mod is working. I have been trying to
get one of the scripts that came with the copy of mysql
(
Hi all,
I am in the process of designing a MySQL database that will run on Redhat
7.1, but I am fairly sketchy on MySQL and performance.
What I want to do is have a database that keeps track of large distribution
lists. Each list has a unique ID, an owner (which is a reference to an ID in
anothe
On Thu, 28 Mar 2002 14:46:01 +0200, Egor Egorov wrote:
>You must first install original MySQL (rpm) package and then you can
>install MySQK-max RPM. You can read about mysqld-max at:
> http://www.mysql.com/doc/m/y/mysqld-max.html
>
>If you want to use InnoDB tables you should specify InnoDB
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
- Original Message -
From: "Harry Rorarius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 7:46 AM
Subject: sql
> I am a new comer to the sql world. I have some but brief knowledge of
perl.
> here goes!
>
> I am using mysql on a Winnt platform and I have per
rpm -e the mysql product from the CD's to uninstall the originals.
then rpm -ivh MySQL-Max-3.23.49a-1.i386.rpm to install the mysql-max
product and you're golden.
Curtis
Voytek Eymont said:
> I need some newbie help...
>
> I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that cam
- Original Message -
From: "Harry Rorarius" <[EMAIL PROTECTED]>
To: "Mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 9:18 AM
Subject: Fw: sql
>
> - Original Message -
> From: "Harry Rorarius" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 28
On 3/28/02 1:39 PM [EMAIL PROTECTED] wrote:
>
> What I want to do is have a database that keeps track of large distribution
> lists. Each list has a unique ID, an owner (which is a reference to an ID in
> another table) and a creation date.
>
> My question is this: Would it be more efficient to
You can try to force an index with:
SELECT * FROM Posts USE INDEX(index4) WHERE Board = 'board1' ORDER BY
Board DESC, Number DESC
Mike
-Original Message-
From: Michael Bonfert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Problem w
Hi,
assume a table as follows:
CREATE TABLE Posts (
Board varchar(100) NOT NULL,
Number int(11) unsigned NOT NULL auto_increment,
Posted int(11) unsigned DEFAULT '0' NOT NULL,
Subject text,
Body text,
PRIMARY KEY (Number),
KEY index1 (Number, Board),
KEY index2 (Board),
> -Original Message-
> From: Ben Holness [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
...
> My question is this: Would it be more efficient to have each entry in the
> list stored in this table in the database, or would I be better
> off having a
> reference to a file tha
Hi Ben:
Performance would definitely be better if you store the data in the
database as opposed to simply storing references to files. Sounds like you
could solve this with 2 tables with one for the actual lists (assuming the
structure of all your list is the same) and the other for the list
J,
Wednesday, March 27, 2002, 4:46:08 PM, you wrote:
JvDBKA> I'm running RH Linux 7.0,and Mysql Version: 3.23.22-beta, and the
JvDBKA> mysqld.log grows very rapidly.
JvDBKA> Is there a way to turn it off ?
JvDBKA> Logrotation is not really an option in this case, the only
JvDBKA> possibilities a
erich,
Wednesday, March 27, 2002, 5:22:00 PM, you wrote:
e> Does anybody have an idea how to select data from a local database into another
e> host server ?
e> For information, I'm currently using mySQL 3.23.
mysqldump?
You can read about mysqldump utility at:
http://www.mysql.com/doc/m/y/m
voytek,
Thursday, March 28, 2002, 3:45:48 PM, you wrote:
>>You must first install original MySQL (rpm) package and then you can
>>install MySQK-max RPM. You can read about mysqld-max at:
>> http://www.mysql.com/doc/m/y/mysqld-max.html
>>
>>If you want to use InnoDB tables you should specify
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Bonjour,
J'utilise Mysql 3.23... sous un environnement Solaris 7. La taille de la
base de donnée est de 1Go 5.
Quelles sont les limites pour le bon fonctionnment de mysql ?
Existe il un moyen plus rapide de faire des copies de bases que le dump ?
Merci
Cordialement,
Tony Jarriault
--
At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said :
>?http://www.mysql.com/doc/C/R/CREATE_INDEX.html
Granted, I should have looked before I spoke for the first question.
> > 2 - Do I have to do anything special like stop requests to the
>> server while I add the index.
>
having problems working out sql where exists syntax.
Tried
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 269 5
Here we speak english.
Ici on parle anglais.
Tu peut copier les fichiers binaires des tables de mysql (*.MYD *.MYI *.frm)
dans le DATADIR
ex : linux /var/lib/mysql
par contre il doit y avoir
des problemes avec l intégrité des données.
Je te conseil de lire la doc de mysql en francais ss nex
I use putty:
http://www.chiark.greenend.org.uk/~sgtatham/putty/
This software has a local tunnel feature so I can tunnel port 3306
requests on the local machine through the ssh port and back to 3306 on
the remote machine. This isn't ssl, but it answers your problem. Of
course sshd must be runn
having problems working out sql where exists syntax.
Tried query
select *
from sections s
where exists (
select 0
from pages s
where s.page = p.page
)
Any ideas,
Ben
--
[EMAIL PROTECTED]+44 (0)7970 26
Ok, first, please send only e-mail, we saw it the first time. Second, MySQL
does not support nested queries or sub selects or what you are using.
Please see the JOIN syntax in the MySQL documenation:
http://www.mysql.com/doc/J/O/JOIN.html
nickg
-Original Message-
From: [EMAIL PROTECT
Whoa,
I've had this message 3 times now. Is there a problem somewhere?
George
- Original Message -
From: "Ben Edwards" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 3:38 PM
Subject: where exists sql problem
> having problems working out sql where exists syn
Since I never saw much people speaking french using
this mailing list I though translating this message
for english users
Hi,
I use MySQL 3.23 under Solaris 7. The size of the Database
is 1Gig 5.
What are the limits for propoer MySQL operation.
Is there a faster way to copy a DB than using Dump
Ben,
Thursday, March 28, 2002, 5:07:49 PM, you wrote:
BE> having problems working out sql where exists syntax.
BE> Tried
BE> select *
BE> from sections s
BE> where exists (
BE> select 0
BE> from pages s
BE> where s.page = p.page
B
* Harry Rorarius
> > The specified CGI application misbehaved by not returning a complete set
> of
> > HTTP headers. The headers it did return are:
> >
> >
> > syntax error at F:\web\cgi-bin\mysql_setpermission.pl line 71, near
I don't think mysql_setpermission.pl is a CGI script... you should ru
mySQL does not support nested 'selects'. Read the manual, please :)
Ben Edwards wrote:
> having problems working out sql where exists syntax.
>
> Tried
> select *
> from sections s
> where exists (
> select 0
> from pages s
> where s.pag
Hi Chris/Nick/Scalper,
Thanks for the replies. I am not too sure how to implement this in tables,
so I will give an example:
Let's say I have three lists - a,b and c. List a contains 10,000 entries,
list b contains 2,500 entries and list c contains 75,000 entries.
I have a table of lists, with
> -Original Message-
> From: Ben Holness [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 28, 2002 7:43 AM
> Have I understood the two table concept correctly?
> How does the third table fit in?
>
> I guess that if two (or more) of the entries overlap, I could make things
> even
ok
I thought Mysql was a server that could be used as a online database?
If it is, is there some material I have not read that tells me how to do
this?
I understood most of the information I read about Mysql. I was under the
understanding sql is the way to make a online database
Harry
---
Dmitry Grigoryev writes:
> Hello
>
> I have followed problem:
>
> Table:
> CREATE TABLE test (
> field1 mediumtext
> );
>
> Insert:
> INSERT INTO test VALUES ('222(100 Kb of '2')222');
>
> Select1:
> SELECT field1 FROM test;
> OK. I get 100 Kb of '2'.
>
> Select2:
> SET CHARACTER SET cp12
On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote:
> I thought Mysql was a server that could be used as a online database?
Yes
> If it is, is there some material I have not read that tells me how to do
> this?
What are you trying to do? You have not been at all clear in y
hi,
I've downloaded mysql-max-nt v.3.23.49, have setup InnoDB startup support. I
am now in the process of creating tables. When these are standard tables no
problem, eg:
create table test (id integer not null, primary key(id)) type=InnoDB;
works fine !
I have problems when I have tables with f
Harry,
It is you need to make a WEB front end to access it
-Original Message-
From: Harry Rorarius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 10:49 AM
To: Mysql list
Subject: hmm
ok
I thought Mysql was a server that could be used as a online database?
If it is, is ther
I have a simple search form that allows the user to search a contact db
based on criteria that they choose.
Search by -
first name - text box
last name - text box
region - drop down
loan officer - drop down
I want the user to be able to receive results if they choose all possible
criteria or jus
Hi all,
I d like to sql a huge sql that I have before submitting to the server.
I notice that when 1 erreor is encounter the serveru stop to precess.
I d like to list all the errors that are in that sql file.
Because I generate it n want to know all my erreors at one time in order to
repair all
* Harry Rorarius
> I thought Mysql was a server that could be used as a online database?
Yes, it is...
> If it is, is there some material I have not read that tells me how to do
> this?
Probably :o)
> I understood most of the information I read about Mysql. I was under the
> understanding sql
Hi
$query = 'SELECT *
FROM Table
WHERE
FirstName LIKE "%'.$firstname.'%"' ;
if($lastname)$query.= ', AND LastName LIKE "%'.$lastname.'%"';
if($region)$query.= ', AND Region LIKE "%'.$region.'%"';
if($loan_officer)$query.
Is there something similar for Greeks too?
(not that matters very much as I run on internet host but in case..)
Makis
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 10:25 PM
> To: Philip Semanchuk
> Cc: [EMAIL PROTECTED]
> Subject: Re
By the way you're using the terms, I would guess you're hoping
to make a new database, and place it "on the web".
In that case, Mysql is probably at too low a level of
detail for your needs. To solve your problem you
would need to learn:
HTML
CGI
middleware (ASP, PHP, etc)
MySQL
SQL
database
Well after some pondering I found a pretty easy work around:
SELECT main.id, description, maincat.name, subcat.name from main
LEFT JOIN maincat ON maincat.id=main.maincatid
LEFT JOIN subcat ON subcat.id=main.subcatid
WHERE MATCH (description) AGAINST ('keywords')
OR
WHERE MATCH (maincat.name) AGA
I am quite new to coding and have managed so far but, i've been havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out, and
haven't found any helpfull documentation
I have a mysql database, and i want to sort a table by date Where the
resulting records wi
Hey David.
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending order..)
Replace 'table' with the name of your table and date_column with the
name of the column that contains the dat
Sorry to repost. I got one answer and stumped the guy trying to help (thanks
again btw). If anyone has seen this or has any ideas, any help would be
greatly appreciated.
---
RH 7.2.
mysql-3.23.44
I have a single server running mysql. I have added one database I use. For
some unknown
Hi,
I have setup a table with user login name and password. The password is
encrypted with the MySQL's password(). How do I compare these info with the
user's input.
I had
$query = "select * from auth where
usrname='$logname' and usrpass=password('$logpass')";
mysql_query($query);
But I can'
David, Steven,
> I think this is what you want?
>
> select * from table order by date_column ASC; ( for ascending order..)
> select * from table order by date_column DESC; ( for descending
order..)
>
> Replace 'table' with the name of your table and date_column with the
> name of the column that
Is there a master.info file somewhere?
What's your my.cnf look like?
If you want, you can email me the file and I'll be happy to try and
help.
--
sh
On Thu, 2002-03-28 at 10:40, Jonathan Wilzig wrote:
> Sorry to repost. I got one answer and stumped the guy trying to help (thanks
> again btw).
D'oh. Forgot he wanted after now :)
Thanks.
On Thu, 2002-03-28 at 10:46, DL Neil wrote:
> David, Steven,
>
> > I think this is what you want?
> >
> > select * from table order by date_column ASC; ( for ascending order..)
> > select * from table order by date_column DESC; ( for descending
> ord
Mark, Peter,
The query below assumes that the user will search of FirstName and none
or more of the other fields - which was not how the question reads (to
me).
To answer the question it would be useful to know how you are accessing
MySQL - are you using PHP (as per example code below) for examp
In your situation (or any situation, IMHO),
multi-value fields defeat the purpose of good database
design.
I think you are on the right track if you are willing
to tolerate a little redundancy for the sake of
simplicity (as a one-to-many relationship). If you
really want to structure it as a many
DL -
Points well taken -
I am using php and doing simple validation
EX - if ($fname !="") {
add fname string to search variable;
}
And if none of the fields have been filled out I'll return an error msg.
As you mentioned, Peter's logic still applies here and it has given me
enough to work wit
Nick,
> This is pretty familiar to me because I'm analyzing the behavior of
people
> in on-line discussions, so I'm gathering such data.
Which begs the questions:
- in what way are you analyzing "behavior"? and
- in what way are you analyzing this list-community?
=dn
MySQL list busting
---
Hi Makis,
default-character-set = greek
Try that, best wishes,
Ken
P.S. also for anyone else asking here are all the charsets included
in MySQL by default. You can also create your own.
mysql> show variables like "char%";
++
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
...
> Which begs the questions:
> - in what way are you analyzing "behavior"? and
> - in what way are you analyzing this list-community?
"There's too much to read," is the simple answer to the first question.
Over the las
Mark,
Tutorials: Start at the PHP home page and look for the links page.
DevShed would be a good start.
Regards,
=dn
- Original Message -
From: "Mark Stringham" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>; "Peter Lovatt"
<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: 28
Suppose I want to select items 10 to 30 from a table tab, which has 36 rows.
What could be the sql query ?
Thank you.
Aman
PS: I am using cgi-perl.
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.
Olivier,
please check that the data types of corresponding columns in the referenced
tables are the same, and that you have created the necessary indexes in also
the referenced tables.
I tested the following:
C:\m\client_debug>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
This worked for me:
SELECT * FROM table ORDER BY id ASC LIMIT 9,21;
There's probably a better way to do that though.
tyler
- Original Message -
From: "Aman Raheja" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 2:04 PM
Subject: select a certain num of items i
Hey thanks i got it to work sort of
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date DESC LIMIT
3";
that works
but i want it to show them ascending and when i change it to
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC; DESC
LIMIT 3";
it doesn't work
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC LIMIT
3";
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = "SELEC
From: "Aman Raheja" <[EMAIL PROTECTED]>
> Suppose I want to select items 10 to 30 from a table tab, which has 36
rows.
> What could be the sql query ?
> Thank you.
> Aman
>
> PS: I am using cgi-perl.
How are these items identified as "items 10 to 30" in the table?
Does that mean that when you
If you only want it ascending, take out the DESC as in:
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC LIMIT
3";
- Original Message -
From: "David Rice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part
Thanks very much to every who helped me with my MySQL problem!
I will probably go with the three table solution as it also eliminates the
need for yet another table!
Cheers,
Ben
-
Before posting, please check:
http://www.my
Hey Guys,
I'm working on a script that displays reviews by a category for my site and
I want the pull-down menu to be ordered by the amount of hits each category
or review
has, is it possible to sort by the amount of hits for a row value?
My table is structured as follows:
Name, Url, Author, E-
UPDATE tbl SET Number = Number + 1 WHERE blah;
Alex Behrens wrote:
>
> Hey Guys,
>
> I'm working on a script that displays reviews by a category for my site and
> I want the pull-down menu to be ordered by the amount of hits each category
> or review
> has, is it possible to sort by the amoun
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
Yeah, but thats not what I'm asking, how can I get this info from the table?
Does mysql have a built-in feature that stoes the hit information and if so,
how do I pull this info from the table?
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
U
Hi all,
I ve got a database with the name
db-name
when making :
select * from db-name.table;
I get a error.
something is wrong in your syntex near : -name ...
How can I tell mysql that db-name is a database name ?
Thanks.
_
Do You
we have to escape name
select * from `db-name`.`table-name`;
works.
great mysql.!
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Bef
I am trying to configure mysql for redundancy using replication and the
built-in mysql master/slave configuration. What I don't understand, even
after much reading, is how to recover from a failure. If host B is slave to
host A, and A goes down, B could then be manually or automatically
configured
You need to use the use command
Mysql> \u [databasename]
Now you may run the query
Mysql> select * FROM dbname.table;
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:25 PM
Cc: [EMAIL PROTECTED]
Subject: pb while querying in strange db n
Ok thanks guys.
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimite
Hi all,
I make a huge sql dump to mysql client
ie :
mysql < dump.sql
the dump.sql is nearly 650 MB.
I get some strange file near my table files :
12 -rw-rw1 mysqlmysql8678 mar 28 22:26
/var/lib/mysql/doz/#sql-9a8_17.frm
63428 -rw-rw1 mysqlmysql64880640
I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you will need to make another table to count the hits per category.
Then do a join between the two tables to get the results you want.
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]
Let's say A and B are running together.
Then someone does a large update query and A is done with, while B is in
the middle of it, and A crashes.
You can switch over to B, which won't contain the data, but it'll have a
good snapshot of what the data was before the crash.
When you recover the A
At 06:20 AM 3/28/2002, you wrote:
>On 27-Mar-2002 Ken Anderson wrote:
> >
> >
> >
> >
> >
> > What is the fastest way to check if a table exists?
> > Do a select and catch the error?
> > Try to create the table, and catch the error?
> > Other options?
> > Thanks,
> > Ken
>
>Yes, in php:
>
>
Joe,
Replication is pretty much instantaneous (depending on network speed),
since the servers communicate using the binary log files. Having said that,
there is no replication scheme for any database product that can guarantee
(over asynchronous replication) that some data won't be lost or m
Hi all,
I have a uge table data about 700mb pii 333 200mb ram. mysql 4.02.
I try to add a full text index
alter table listing add fulltext (about,title,description);
but it seems to do noit effect the ib files in the datadir seems to keep the
same length no grow.
when querying it say no full tex
Ian Linekrans <[EMAIL PROTECTED]> writes:
> Hi All !
> The configuration:
>
> - Redhat 7.2 (Enigma) pre-build installation.
> - Mysql with the following rpms installed:
> MySQL-3.23.49a-1.i386.rpm
> MySQL-client-3.23.49a-1.i386.rpm
>
> The installatio
This is my first time posting to this list, so please forgive me if I am not
doing this correctly. I will break this into post into two parts: what i
want to know and why. Is there a way to get auto_increment fields to fill
in gaps in the numbering sequence if some records have been deleted?
He
Hi. How can I import a text file containing all fixed-length records into
MySQL? Is there a way to do it with LOAD INFILE? The text file was
originally designed for import into Oracle. Thanks.
David
-
Before posting, please
On Thu, Mar 28, 2002 at 09:37:47AM +0300, Peter Zaitsev wrote:
> Also a good thing with DRBD you will not have to store and track
> replication log files and the setup will not require to take MySQL
> down to copy the snapshot of database.
Why would you need to take down MySQL for a backup (assu
Hello mysql,
So nobody here (even at MySQL AB) knows how to set a timezone for a
MySQL client ? Not for whole server but per client? (or maybe for
database???)
I already posted this question here few days ago - and didn't get any
reply.
Please! Somebody help!
--
Best regards,
Maxim
I have a new client that wants to use filemaker on his mac to enter data
for site information. I'm sure that I can take that and export the
files and import into the site's MySQL database...but I'm wondering if
it is possible to link his filemaker database to the MySQL database
using ODBC? I hav
Per client? Per database? The only timezone setting in the MySQL manual is
for the server (tz), and permits you to set it to your local timezone so it
does not return values in GMT.
If you want clients to have different timezones, perhaps you should write
that capabilty into your front-end applic
1 - 100 of 111 matches
Mail list logo
