My drupal install got messed up somewhere along the way when I tried to go from 6.4 -> 6.5. I discovered that I accidently copied all of drupal6.4 into the /sites/all/modules folder, and somehow that folder had become an integral part of my install. When I tried to delete it, I got all sorts of errors. I did a search for drupal6.4 in my database, and edited all examples into the proper directory, but it wasn't enough. I've tried a few methods to determine where the errors are in the database, but I'm out of ideas.
Now, I want to restart with a fresh database. I'm fine with dropping most of the tables since I've been working off essentially the same database since 4.x. I know I have a ton of redundant and unneeded tables. My old database 167 tables, and one of my trials with installing all the modules I currently use has only around 85. What tables I need to migrate to my shiny database to maintain: users, comments, nodes, and image content?
Thanks a bunch for any help.
Comments
Nobody can have a ready
Nobody can have a ready answer for how to keep some database tables and replace some others. Theoretically someone with good knowledge of the database could extract your data/users/comments/categories and import them to a new Drupal installation, but only after spending several hours working on that.
Don't you have a backup of your 6.4 database?
One thing you could try, after removing those misplaced old files, empty (truncate) all the cache tables in the database and run update.php again.
Unfortunately, I do not have
Unfortunately, I do not have a recent backup of my 6.4 database. It appears, however, that the errors were introduced when I installed 6.4 anyway. A reversion to my last 6.4 backup would have not helped.
With some experimentation, I think I've managed to import all the tables that are absolutely essential.