MySQL-last updated? location?

[Vasudevelopa]

I have some MySQL db's on my system. On my php page I want to show when the db was last updated. Is there a way to get that timestamp? Also, where is the db file located? If I wanted to upload the database to a server, where would I find it in my dir structure? Thanks.

[DR_LaRRY_PEpPeR]

you can't see when a database was updated that i know of. however, you can see when a table was. use this query:

SHOW TABLE STATUS LIKE 'table'

and look at the Update_time column.


MySQL databases are directories in the data directory. to see where your data directory is, use this query:

SHOW VARIABLES LIKE 'datadir'

BTW though, usually to "upload the database to a server," you have a dumpfile that you import with the mysql client. you don't usually manually copy the database files to the data directory.

[Vasudevelopa]

Thanks for the reply I really appreciate it. I already got the update time thing working thanks to you. Now I gotta read about dump files