oh no! I've broken my drupal (on wamp) trying to downgrade from 6.4 to 5.10. Now it won't work as 6 or 5. "The more I fix it - the worse it gets :-(("

I thought I was covered - having monthly backups and indeed one called 'manualpreupgradebackup'.

'manualpreupgradebackup' is a folder with two objects in it
1) a folder called 'copy of drupal', and
2) a file called 'copyofdrupaldatabase.sql'

My 'restore' procedure is from 4.6 and I don't think it was really written for this major an upgrade.

To recover I
- copy folder 'copy of drupal' (from 1 above) to C:\www\webapps\
- rename the 'drupal' folder already there to 'drupal6', rename the 'copy of drupal' folder to 'drupal'
- copy file 'copyofdrupaldatabase.sql' (from 2 above) to C:\www\mysql5\bin\
- open a command-prompt and navigate to C:\www\mysql5\bin\
- enter the command 'mysql -u root -p rootpw drupal < copyofdrupaldatabase.sql' (with the real root password)

and voila ... a big pink box of select statement errors

user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 66 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.menu' doesn't exist query: SELECT m.mid, m.* FROM menu m ORDER BY m.mid ASC in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 50 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 132 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 131 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 122 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 121 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 119 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 118 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 117 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 116 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.
user warning: Table 'drupal.file_revisions' doesn't exist query: SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 115 ORDER BY f.fid in C:\www\webapps\drupal\includes\database.mysql.inc on line 172.

Comments

richard102’s picture

Ok, I've 4 years of blog back-ups.

This weekend I'm blowing away my "self-made Drupal 6/5 mess", and starting from scratch - with 5.10.

Then, (cross fingers) I should be able to restore from one of my old monthly backups (which I'll save off first to memory-stick).