Is it possible to back up the DB by simply making copies of a few files somewhere? (And "restore" by copying them back to their production names?) If so, which are the DB files?
I'm still new to Drupal, and trying to get oriented as to ongoing maintenance procedures. I haven't been in charge of DB maintenance in the past, and am not familiar with the details of mysql. I think the web host does regular file backups, but it's not my domain so I haven't confirmed. In any case, for module installations that involve custom DB tables, I want to make sure I can revert if anything is screwed up, and I'm looking for an easy way to do it. I do have admin access and server access.
I did read the backup handbook, and it describes various possible strategies. I'm drawn to the BASH script, but looking for something even easier than that. I don't think locking is necessary, because there are no external users (just two internal admins right now and we can coordinate). Really quick/simple is a big plus.
Any quick/overall-level advice would be useful, plus a specification of the actual DB files themselves (are there any other than the 3 "database" files in the /includes/ directory?).
Thanks for any help anyone can provide.
Comments
=-=
no, the database has nothing at all to do with files. the files interact with the database.
goto the handbooks tab at the top of this page
click on videocasts
watch the videocast on upgrading to Drupal 5.x , this will show you the steps necessary to back up and restore the database through a database tool called PHPMyAdmin, which is common on most hosts.