janroe

every drupal version contains an upgrade.txt file with basic instructions, or in case tehre are any deviations from standard procedure.

backup = save the database with cpanel
open cpanel, go to phpmyadmin, click on the database name (in blue, with numeber of tables in parenthesis next to it), click export (on the right side), make sure all tables are selected (select all), select sql, keep structure and data at deafult checkmarks, checkmark save database, checkmark gzipped, click go - download starts, save on computer

backup = save the filesystem
open cpanel, go to file manager, go to public html, checkmark select all, click compress, checkmark gzipped, choose a name, click save - download starts, save on computer. alternative: save the entire site, include site settings and server email files by saving the "home" directory instead of just public html.

keep those safe, you'll need those in case something goes wrong.

from the above file system backup, or directly from the site, download .htaccess, robots.txt files from the drupal root, and the entire sites directory into your current file system directory on your computer - this to ensure you have a working copy of these files.

give the current file system directory on your computer a new name with current date. start a new empty directory for the new file system.

copy the following directories from the previous directory to the new emtpy file system directory:

- cgi-bin (if you have it)
- sites

and these files:

- .htaccess
- fantastico-fileslist.txt (if you installed by fantastico)
- robots.txt
- php.ini (if you made one)

download the new core form the drupal site, i.e. Drupal 6.32, save and extract it.

compare .htaccess and robots.txt files in the root, and settings.php in sites, between the new core version and the coresponding files in your new current file system version.

synchronise the new versions of standard code of the new files with your specific modifications from previous versions (compare your settings.php file with the new version default.settings.php). overwrite the files in the newly made current filesystem folder with the synchronised versions. - now you have all important user files that are part of the system update in the new directory on your computer.

from new core version that you downloaded and extracted, make a copy and delete the following directory from the copy:

- sites

delete the following files:

- .htaccess
- robots.txt

rename this modified core directory to something like Drupal-6.32-minus-sites-htaccess-robots, and compress it with gzip.

log in to your site as user1. you need to be user1 in order to finish the update later. remain logged in as user1.

set the site theme to Garland. put the site into maintenance mode.

you are about to delete most of the old core files. go to the cpanel file manager and select all drupal directories and files (usually in public_html). then, you must deselect (unmark) the following, so that you will *not delete* them:

- cgi-bin (if you have it)
- sites
- fantastico-fileslist.txt (if you installed by fantastico)
- php.ini (if you made one)
- that should be it, but check for any non-Drupal files that you might have

prepare to delete the entire selected lot: double check that you are not deleting the unchecked items above or something else that you want to keep.

delete the entire selection. refresh a few times to ensure deletion.

upload the gzipped modified Drupal file, in this example the Drupal-6.32-minus-sites-htaccess-robots file. reload page. extract the file. it creates a directory with the same name. enter this directory, select all files, move all files up one directory, that is into the main drupal location (public_html). remove the remaining empty directory.

upload the modified .htaccess, robots.txt, settings.php files.

update the site by entering domain.com/update.php in the address bar. follow the site update/upgrade screens.

this completes the file system update. Note that the core has been replaced, but you have kept sites, .htaccess (possibly updated), robots.txt (possibly updated). You have also kept non-Drupal files, in case there were any.

when all is ok, copy an unzipped version of the new core files minus sites, htaccess and robots (your Drupal-6.32-minus-sites-htaccess-robots) into your computer's new current file system directory. double check that server and computer files are identical.

core update is done. that leaves any module updates.

ps: there surely are other ways to go about it, i found this the fastest and most foolproof.

the sites directory must stay in place. it is not removed and re-uploaded because cpanel appears to disallow removal (better said, after deletion it reappears), unless a number of file permissions are changed, exclusively in cpanel. So it's faster and safer just to let it remain while being sure not to upload the Drupal-supplied sites directory.