Hi everyone,
I am trying to capture my server time automatically using php and insert it in
a mysql table.
Can the timestamp or time data type capture this information automatically
without having me code anything else?
into a regular datetime
field, how can I do that?
In the last episode (May 09), Alla-amin said:
I am trying to capture my server time automatically using php and
insert it in a mysql table.
Can the timestamp or time data type capture this information
automatically without having me code anything else
Thanks guys,
It worked - thank you all so very much.
Michael,
You are very correct - I renamed those fields and boom
- it started working like magic, thank you so much.
I have another question - the database in question
that got crashed had mysql root password but the guys
I took over from forgot the password and didn't do any
mysql dump. So, I
So far this was what I did,
Took all files i.e frm, MYI and MYD files from the new
server. Created a database like on another box running
the version of mysql the old server was running and
pasted them in the data folder of the database I
created and viola - they all showed up, so i think it
was
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy these files to the the
Hi everyone,
I just subscribed to the list and some of the articles
are very helpful. I'm facing some problem on my mysql
database server.
One of our Raid drives crashed and we had to backup
the whole data to another drive (only files), we did
no mysqldump. Now I want to restore a certain
