All geek questions in one place

Getting string creation timestamp in MySQL from metadata?

I maintain a MySQL table table inserted from PHP code for about a year and a half. Actually stupid, I know, I did not include a timestamp to insert these lines.

Is there any possible way to get a timestamp creating these lines through some metadata or some other way? (From MySQL or PHPMyAdmin or some other possible ways?)

+4
source share
3 answers

Unfortunately, in this case you cannot do anything. If MySQL had a secret temporary field, the total size of the tables would increase by 4 bytes per row .

+4
source

The only way to get this timestamp is if it is stored somewhere on one of your servers. You have a web server where you can store the log archive. Or in another place where there is a timestamp of the PHP script activity, making database queries.

Say that you have web server logs, and there is an entry for each or most of the actions of the PHP script, and then maybe you can analyze this log, get a timestamp and match it with the rows in your database. As you can see, this is quite hardworking, but not entirely impossible.

As with MySQL (or any other database), they usually do not store a large archive of past information. The main reason for this is whether the application developer or application developer decides what information should be stored or not. The database stores only the data necessary to ensure the operability of all its parts.

You just got the idea: you have a transaction log journal (which I really doubt), then you can re-run them when backing up the database and maybe they (transaction logs) contain the timestamp of the row being added or changed.

+2
source

Source: https://habr.com/ru/post/1483741/

More articles:


All Articles