Hi,
Is there a way to create a schedule to optimise my MySQL tables automatically? The
overhead of some of my tables can reach 355,548 bytes over 3 working days!
Please help me!
Thanks.
Hwee
yep, check http://www.phpclasses.org/browse/package/1527.html
And you can run this using a cron job, so it just fit with your needs.
Regards,
Hatem
- Original Message -
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "DBList" <[EMAIL PROTECTED]>
Sent: Monday, May 03, 2004 11:19 AM
Subject:
You could set up a PHP cron job to do this.
Regards, Torsten
"Ng Hwee Hwee" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
Is there a way to create a schedule to optimise my MySQL tables
automatically? The overhead of some of my tables can reach 355,548 bytes
over 3 working day
Use a cron job
Like:
0 0 * * * php Optimize.php > /dev/null
This is an example for optimizing every table in all databases on your mysql
server.
Optimize.php :
-Original Message-
From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03,
sorry, what do you mean by _cron_ job?
I'm hoping to optimise my tables, for example on, every Monday 9.30am.
by the way, is there a problem if I optimise my tables too frequently? i
mean, i was told not to defragment or format my harddisk too often cos it
will cause wear and tear to the hardwar
Am Montag, 3. Mai 2004 11:50 schrieb Ng Hwee Hwee:
> sorry, what do you mean by _cron_ job?
unix-operating-system offers you a great thing called "cron-job`s"
like "sheduled-tasks" under windows.
4 more information follow this link
http://weather.ou.edu/~billston/crontab/
sebastian
>
> I'm hop
Hi guys..
Wich is the diference between if ($var == '1') or if ($var === '1')
== means equality and what does the === means ?!
Thanks!
Bruno
Hello Bruno,
Monday, May 3, 2004, 2:16:29 PM, you wrote:
BB> Wich is the diference between if ($var == '1') or if ($var === '1')
BB> == means equality and what does the === means ?!
Forced-type equality. I.e. it checks that $var is not only equal to 1,
but is an integer also (as opposed to a s
Nope.
Access' version of SQL is a slight bit different from ANSI SQL. All he
needs to do in his statement is change it to this:
$query="DELETE * FROM Test_Table WHERE name='franco';";
(notice the wildcard in there-- Access isn't smart enough to realize
that the deletion of any information in
[EMAIL PROTECTED] wrote :
>
> Fatal error: Call to undefined function: open() in
> D:\Inetpub\webs\metagenonlinecom\canc.php on line 11
>
I assume the error is match case in open function...
Should be $db->Open... etc.
-Original Message-
From: Michael Forbes [mailto:[EMAIL PROTECTED]
If your ID is an autoincremented field, try not including it in your
insert statement.
I.E.:
$sql = "INSERT INTO underskrifter (type, navn, epost, tid, ip, domain,
sted) " . " VALUES ('$_POST[type]', '$_POST[navn]', '$_POST[epost]',
'$tid', '$ip', '$host', '$_POST[sted]' );"
-Mike Forbes
Ma
From: "Bruno Braga" <[EMAIL PROTECTED]>
> == means equality and what does the === means ?!
It matches the variable type, too.
$a = 1;
if($a == '1') => TRUE
if($a === '1') => FALSE
Most often used for function that can return a number including zero and
FALSE. If you're expecting a number to b
The PHP manual (a useful read btw !) states that === tests for equality and
*exact* equivalence, that is:
If you test for ==='1' then $var must be a string for the result to be true
if you test for ===1 then $var must be an integer or double type for the
result to be true
Usually its used in te
Rafi --
...and then Rafi Sheikh said...
%
% Hi List. A quick question. I have some categories that are really long
% and I would like to re-word or re-format them when I am bring data in from a
% DB. Now which would be better:
Can you describe an algorithm for doing so? Your example appears
What you wrote will give you the list of users who also happen to have
comments. What you really want is more like this:
SELECT Users.ID, Users.UserName, Comments.Description
FROM Users LEFT JOIN Comments
ON Users.ID = Comments.UserID;
(note that you'll need to have the UserID foreign key in you
Heh, yeah, I didn't read far enough-- and boy do I feel like a troll
now. My apologies, case inconsistencies probably are causing his
problem-- but he'll also have a problem with the SQL statement when it
gets that far, if he doesn't tell it what to delete (i.e., wildcard),
simply b/c that's t
I have these tables.
Users ( id,name,etc )
Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id)
from
comments)
Expected result:
List of users:
* User1
See comments
Hey.
I have these tables.
Users ( id,name,etc )
Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id) from
comments)
Expected result:
List
Thanx for this enlightening insight about cron jobs...
just a question.. when i run Optimize.php, i realise that you will echo some
statements. where will these statements be shown? since you put " >
/dev/null " instead of " > /dev/null 2>&1 ", does it mean that your echo
statements will be ref
Anyone?
- Original Message -
From: "Dan Bowkley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 02, 2004 1:21 AM
Subject: [PHP-DB] lamer noob with repeat question
> Hello everyone,
>
> I've been working on (read:tearing my hair out over) my mom's website for
> some time no
Try
$result_insert = @mysql_query ($query_insert) or die(mysql_error);
-Original Message-
From: Dan Bowkley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 08:37
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] lamer noob with repeat question
Anyone?
- Original Message -
From:
21 matches
Mail list logo
