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. Does dbDelta delete columns as well?
  7. How to fetch Data in WordPress using MySQLi or $wpdb
  8. wpdb->insert multiple record at once
  9. WordPress Unit Testing – Cannot Create Tables
  10. How to define composite keys with dbDelta()
  11. Does wpdb add considerable overhead on queries with large result sets?
  12. $wpdb->prepare() warning in WordPress 3.5
  13. Hook into $wpdb
  14. Display data from a non wordpress database on a page template
  15. How does $wpdb handle COUNT(*)
  16. WordPress database error: [Query was empty] [closed]
  17. Inserting Post Meta From SQL
  18. Why does dbDelta() not catch MysqlErrors?
  19. Connecting to external oracle database
  20. Can’t save ajax value to database
  21. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  22. Updating all rows of table with $wpdb
  23. How to execute mulitple statement SQL queries using $wpdb->query?
  24. Is $wpdb->prepare escaping to much? How to use it properly?
  25. When and why should I use $wpdb different return types?
  26. How wordpress accesses its own database
  27. Remove database entries where post_date > expiration date
  28. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  29. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  30. Get data from database using $WPDB
  31. How to use a different database to list and manage comments in the backend
  32. Getting all the users who have author privilege
  33. WP Database Table to CSV file
  34. Cannot update custom database table row
  35. wpdb_prepare with multiple or condition
  36. $wpdb->insert is not working
  37. Extracting the post_id via the wp_insert_post action (external db query)
  38. In what part of the WordPress core does the users table and usermeta table get joined?
  39. Modify Database in Multi-Site wp_usermeta table
  40. Advanced SELECT query with condtional statements
  41. $wpdb doesn’t like to store arrays
  42. WordPress choose wrong database
  43. Redirecting to old domain after migration website
  44. Create table from array with prepare
  45. Update from 4.5 to 4.6 failing
  46. Does WordPress $wpdb functions wait when table is locked?
  47. How Can I Put Meta_Compare in the Database-Query?
  48. $wpdb->insert Giving duplicates
  49. I’m not able to get access to $wpdb [duplicate]
  50. Have working sql query… trying to adjust it to use $wpdb
  51. Is it important to have integers inserted using %d rather than %s?
  52. Problem in using wpdb
  53. $wpdb->query can’t insert data
  54. How to fetch records from database WordPress
  55. Best practice to import user base (subscribers) from one website to another?
  56. AJAX wp-mysql running too slow
  57. Problem migrating to localhost
  58. Clear Terms from Taxonomy for Specific Post IDs?
  59. Connecting to a different database
  60. Query Column of Specific ID from Database Table
  61. How to delete a particular row in a database table
  62. How to create more than one new wpdb object?
  63. Update multiple rows in one query
  64. How to connect and insert data in database of wordpress?
  65. Should I use an additional column in the DB?
  66. access JSON results from wordpress database with wpdb
  67. Getting value from database table depending on field value
  68. wpdb->insert not inserting first variable
  69. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  70. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  71. wpdb Insert unknown post data dynamic foreach loop
  72. How do I get database rows from a custom table using wpdb?
  73. Help with $wpdb on custom code
  74. “BS_” rows in postmeta table
  75. How to rerieve comments and their replies from DB
  76. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  77. Help posting values to DB on submit using $wpdb->query
  78. WordPress Database Query works in phpMyAdmin but not in the code
  79. How to add download link from database on custom page template?
  80. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  81. insert data from a form:: Warning Empty query mysqli::query()
  82. How can I get $wpdb to show MySQL warnings?
  83. About wp database hooks (error establishing connection)
  84. How to get specific table by current user login
  85. How To connect to the same WordPress database with different database user
  86. Accessing content from third party as native posts in WordPress
  87. Should I Use only wpdb Class to Write Custom Queries?
  88. Call to a member function insert()
  89. I have include wp-config, should I add global $wpdb also?
  90. Processing a lot of $wpdb isn’t insert all the data
  91. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  92. using same mysql user with many databases
  93. Pulling values from a sepcific row in table
  94. Creating Tables in WordPress Database
  95. Inserting into data into external DB using WPDB
  96. Insert Extra fields added in the front end registration form to DB
  97. How to use remote db tables in current config? [duplicate]
  98. $wpdb->insert not working for last select option
  99. $wpdb->prepare returns empty array
  100. Uploading to WordPress Database
deneme bonusu veren sitelerbahis casinomakrobetceltabetpinbahispolobetpolobet girişpinbahis girişmakrobet girişpulibet girişmobilbahis girişkolaybet giriş