Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-28 Thread Joseph
On 12/28/12 13:00, Michael Orlitzky wrote: On 12/28/12 12:51, Joseph wrote: Yes, I run osCommerce on my server. Is the manuall command: mysqldump --opt -ppassword catalog > catalog_backup.sql I think --opt is on by default, but yes, that should do it. If you would like to automate the backu

Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-28 Thread Michael Orlitzky
On 12/28/12 12:51, Joseph wrote: > > Yes, I run osCommerce on my server. > Is the manuall command: > > mysqldump --opt -ppassword catalog > catalog_backup.sql > I think --opt is on by default, but yes, that should do it. If you would like to automate the backup (say, nightly), you can add the f

Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-28 Thread Joseph
On 12/28/12 11:06, Michael Orlitzky wrote: On 12/28/12 10:56, Joseph wrote: Your are correct, when I removed the quotes it worked. I'm backing it up through the backup.php sript that came with osCommerce, I can post it but it is a long one. I am... familiar... with osCommerce. You will be m

Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-28 Thread Michael Orlitzky
On 12/28/12 10:56, Joseph wrote: > > Your are correct, when I removed the quotes it worked. > > I'm backing it up through the backup.php sript that came with > osCommerce, I can post it but it is a long one. > I am... familiar... with osCommerce. You will be much better off doing a mysqldump if

Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-28 Thread Joseph
On 12/28/12 02:00, Michael Orlitzky wrote: On 12/28/2012 01:44 AM, Joseph wrote: I'm not a PHP programmer but I'll try to explain my problem. I've create table in my php database: DROP TABLE IF EXISTS visual_verify_code; CREATE TABLE visual_verify_code ( oscsid varchar(32) NOT NULL, code

Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-27 Thread Michael Orlitzky
On 12/28/2012 01:44 AM, Joseph wrote: > I'm not a PHP programmer but I'll try to explain my problem. > I've create table in my php database: > > DROP TABLE IF EXISTS visual_verify_code; > CREATE TABLE visual_verify_code ( >oscsid varchar(32) NOT NULL, >code varchar(6) NOT NULL, >dt TIM

[gentoo-user] php CURRENT_TIMESTAMP vs NOW()

2012-12-27 Thread Joseph
I'm not a PHP programmer but I'll try to explain my problem. I've create table in my php database: DROP TABLE IF EXISTS visual_verify_code; CREATE TABLE visual_verify_code ( oscsid varchar(32) NOT NULL, code varchar(6) NOT NULL, dt TIMESTAMP(12) NOT NULL DEFAULT NOW(), PRIMARY KEY (oscsid