Show last modified date of database

There’s an UPDATE_TIME column in the TABLES table in the information_schema database.

So you can try to get the max from that column with e.g.:

SELECT MAX(`UPDATE_TIME`) 
FROM information_schema.TABLES
WHERE  TABLE_SCHEMA = 'dbname'

where we replace 'dbname' with the corresponding database name.

More related info here on SO.

From the MySQL 5.7 docs:

UPDATE_TIME displays a timestamp value for the last UPDATE, INSERT, or
DELETE performed on InnoDB tables that are not partitioned. For MVCC,
the timestamp value reflects the COMMIT time, which is considered the
last update time. Timestamps are not persisted when the server is
restarted or when the table is evicted from the InnoDB data dictionary
cache.

The UPDATE_TIME column also shows this information for partitioned
InnoDB tables.

There seems to have been a bug, that UPDATE_TIME wasn’t updated for InnoDB tables in MySQL <= 5.6, but should be fixed for 5.7+

Related Posts:

  1. Using wpdb to connect to a separate database
  2. WPDB Insert or if exists Update
  3. get_results using wpdb
  4. $wpdb won’t insert NULL into table column
  5. Get error messages when $wpdb->insert() returns false?
  6. Detecting errors generated by $wpdb->get_results()
  7. Does dbDelta delete columns as well?
  8. wpdb update add current timestamp not working
  9. How to fetch Data in WordPress using MySQLi or $wpdb
  10. wpdb->insert multiple record at once
  11. WordPress Unit Testing – Cannot Create Tables
  12. How to define composite keys with dbDelta()
  13. Does wpdb add considerable overhead on queries with large result sets?
  14. Why does $wpdb return strings for mysql integer values?
  15. $wpdb->prepare() warning in WordPress 3.5
  16. Inserting data into custom tables
  17. Hook into $wpdb
  18. Display data from a non wordpress database on a page template
  19. How does $wpdb handle COUNT(*)
  20. How might I retrieve a featured post image from an external WP site and display it as a link back?
  21. WordPress database error: [Query was empty] [closed]
  22. Export wordpress table to excel
  23. How to close wpdb connection? [duplicate]
  24. Inserting Post Meta From SQL
  25. Why does dbDelta() not catch MysqlErrors?
  26. Connecting to external oracle database
  27. Can’t save ajax value to database
  28. What causes the “max_user_connections” warning on WordPress frontend?
  29. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  30. Updating all rows of table with $wpdb
  31. Safe way to find last inserted id in a table?
  32. How to execute mulitple statement SQL queries using $wpdb->query?
  33. Is $wpdb->prepare escaping to much? How to use it properly?
  34. Database slowdown after update to 3.4.1
  35. When and why should I use $wpdb different return types?
  36. How wordpress accesses its own database
  37. Remove database entries where post_date > expiration date
  38. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  39. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  40. Get data from database using $WPDB
  41. How to use a different database to list and manage comments in the backend
  42. Getting all the users who have author privilege
  43. Multiple postmeta with same name for one post in wp_postmeta table
  44. WP Database Table to CSV file
  45. Cannot update custom database table row
  46. wpdb_prepare with multiple or condition
  47. $wpdb->insert is not working
  48. Extracting the post_id via the wp_insert_post action (external db query)
  49. WordPress database error – Error in SQL syntax – I can’t identify any error?
  50. In what part of the WordPress core does the users table and usermeta table get joined?
  51. Modify Database in Multi-Site wp_usermeta table
  52. Multiple wp_options tables to share content across installs
  53. Advanced SELECT query with condtional statements
  54. $wpdb doesn’t like to store arrays
  55. Select two sums with single get_var statement
  56. WordPress choose wrong database
  57. Redirecting to old domain after migration website
  58. Create table from array with prepare
  59. Update from 4.5 to 4.6 failing
  60. Does WordPress $wpdb functions wait when table is locked?
  61. How Can I Put Meta_Compare in the Database-Query?
  62. WordPress running SQL query to update database from form
  63. $wpdb->insert Giving duplicates
  64. I’m not able to get access to $wpdb [duplicate]
  65. WPDB SQL query with prepare() returning variable, not db value
  66. $wpdb error (Call to a member function insert() on a non-object)
  67. Have working sql query… trying to adjust it to use $wpdb
  68. Is it important to have integers inserted using %d rather than %s?
  69. Problem in using wpdb
  70. $wpdb->query can’t insert data
  71. Custom WordPress Table wpdb
  72. How to fetch records from database WordPress
  73. Best practice to limit results in get_row()?
  74. Best practice to import user base (subscribers) from one website to another?
  75. AJAX wp-mysql running too slow
  76. CreateOrUpdate in WordPress
  77. Problem migrating to localhost
  78. Clear Terms from Taxonomy for Specific Post IDs?
  79. Trouble running $wpdb->query() with last_insert_id
  80. How to get a list of WordPress default database tables?
  81. Connecting to a different database
  82. Using $wpdb | checking entered email against existing emails in db
  83. Query Column of Specific ID from Database Table
  84. How to delete a particular row in a database table
  85. How to create more than one new wpdb object?
  86. Optimizing function that automatically creates internal links based on post title string
  87. Update multiple rows in one query
  88. How to connect and insert data in database of wordpress?
  89. Get results from wordpress data custom table
  90. Should I use an additional column in the DB?
  91. Outputting query results
  92. access JSON results from wordpress database with wpdb
  93. Getting value from database table depending on field value
  94. add_post_meta — not working
  95. Select From wpdb – Author/User Directory page
  96. Creating and Using Tables in the WordPress Database
  97. wpdb->insert not inserting first variable
  98. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  99. $wpdb->insert not inserting all rows
  100. How to escape percentage sign(%) in sql query with $wpdb->prepare?