I will explain myself a bit more:
I wrote my own session handler function so I could use session files. I
have been able to specify a directory for session files as well as their
life expectancy is +- 90 minutes, not to exceed 99 minutes from
inactivity.
My purpose in setting auto_increment back to 1 is that I won't exceed
the auto_increment maximum integer value and that the table is
maintenance free when I am able to get this working with a cron.
I have noticed that when putting a script onto a cron sometimes requires
minor tweaking from how it runs when called on the web. I am able to
change the value to 1 using the original syntax I posted to the list ---
not with the cron. I changed AUTO_INCREMENT to be in capital letters
and will see if this works tomorrow when the cron runs.
I have been using the session_regenerate_id(); command to keep the
logins secure with session variables controlling which account is being
accessed. There are a few other things running in the background to
help protect the sessions. It is feasible that when a user accessed
their account they use 10 to 15 entries in the mySQL table. I just want
to keep bringing the auto_increment field back to 1 because of this. Am
I making sense? I am trying to get ready for a marketing campaign for a
home based business I have started so I may eventually quit my day job
do when I have a passion for (caring for people.)
Ron
On Tue, 2007-04-17 at 08:20 -0400, Michael Keyser wrote:
You could also use phpMyAdmin if no one else has mentioned it. It's
pretty simplistic and is a collaboration of PHP scripts specifically for
maintaining MySQL databases. I think you should check it out:
http://www.phpmyadmin.net
-Original Message-
From: Buesching, Logan J [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 8:17 AM
To: [EMAIL PROTECTED]; PHP DB
Subject: [PHP-DB] RE: auto_increment
One of two things comes to my mind:
1.) auto_increment *might* have to be AUTO_INCREMENT, as that is how the
manual states it and *some* things in MySQL are case-sensitive (such as
table names).
2.) Make sure you have satisfied the following (From the MySQL manual):
--
You cannot reset the counter to a value less than or equal to any that
have already been used. For MyISAM, if the value is less than or equal
to the maximum value currently in the AUTO_INCREMENT column, the value
is reset to the current maximum plus one. For InnoDB, you can use ALTER
TABLE ... AUTO_INCREMENT = value as of MySQL 5.0.3, but if the value is
less than the current maximum value in the column, no error message is
given and the current sequence value is not changed.
--
If neither of these help, the actual error message may be of use.
-Logan
-Original Message-
From: Ron Piggott [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 10:04 PM
To: PHP DB
Subject: auto_increment
Does anyone see anything wrong with the $query syntax? Ron
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( Unable to select database);
$query=ALTER TABLE sessions auto_increment = '1';
mysql_query($query);
mysql_close();
