Is there an easy way to find identical tables, i.e. same structure and data, using MySQL and PHP? I doubt there is a MySQL command for it, but how would you recommend doing this?
Without more information about the structure or size of your data, you could do this:
SELECT IF(COUNT(*) = (SELECT COUNT(*) FROM table1) AND COUNT(*) = (SELECT COUNT(*) FROM table2),1,0) AS result FROM ( SELECT * FROM table1 UNION SELECT * FROM table2 ) tables_joined
But be warned, it's not an ideal solution. For large datasets, it could take a while
This is untested, but the general premise of the answer is: