By vikramy on

Hi,

I need to know what tables gets inserted when a page is created?

I think node and also node_revisions.

Thanks.

Comments

dnuss’s picture

dnuss commented

I have been using the following procedure to determine what database changes are made when doing anything in Drupal (or other database driven system):
1. Using phpMyAdmin ( or similar database client ), make an export of your database as a “before snapshot”
2. execute whatever page / process in Drupal that you want to test
3. make an export of your database as an “after snapshot”
4. compare the before and after snapshots using a file compare program and you will see with great detail all changes made to the database

I use the file compare program “Beyond Compare” from Scooter Software (http://www.scootersoftware.com ). You will not find a better compare program anywhere, and it is reasonably priced. It will quickly become a valuable part of your everyday toolkit.

When creating your snapshot backups, you may want to “Unselect” the cache tables, etc. to keep the size of the files small. I would also suggest that you only use this technique against your local test system (sandbox) so you control the test and guarantee that you are the only one using Drupal at the time of the test.

vikramy’s picture

vikramy commented

Thanks