lyricnz:drupal-7.7 simonroberts$ cd ../drupal-6.22 lyricnz:drupal-6.22 simonroberts$ drush sql-drop Do you really want to drop all tables? (y/n): y lyricnz:drupal-6.22 simonroberts$ drush si -y You are about to DROP your 'drupal6' database and then CREATE a new one. Do you want to continue? (y/n): y ERROR 1044 (42000) at line 1: Access denied for user 'drupal6'@'localhost' to database 'drupal6' No tables to drop. [ok] lyricnz:drupal-6.22 simonroberts$ ### enable primary/secondary links blocks Login to new site as admin, create enable primary+secondary links blocks Set custom titles on these (so I can tell). Add a menu item to each, linking to Take screenshot ### install drupal 7.2! lyricnz:drupal-6.22 simonroberts$ cd .. lyricnz:htdocs simonroberts$ drush dl drupal-7.2 Project drupal (7.2) downloaded to /Users/simonroberts/htdocs/drupal-7.2. [success] Project drupal contains: [success] - 3 profiles: testing, standard, minimal - 4 themes: stark, seven, garland, bartik - 47 modules: drupal_system_listing_incompatible_test, drupal_system_listing_compatible_test, user, update, trigger, translation, tracker, toolbar, taxonomy, system, syslog, statistics, simpletest, shortcut, search, rdf, profile, poll, php, path, overlay, openid, node, menu, locale, image, help, forum, filter, file, field_ui, text, options, number, list, field_sql_storage, field, dblog, dashboard, contextual, contact, comment, color, book, blog, block, aggregator lyricnz:htdocs simonroberts$ cp drupal-7.7/sites/default/settings.php drupal-7.2/sites/default/ lyricnz:htdocs simonroberts$ cd drupal-7.2 lyricnz:drupal-7.2 simonroberts$ drush updatedb The following updates are pending: system module : 7000 - Rename blog and forum permissions to be consistent with other content types. 7001 - Generate a cron key and save it in the variables table. 7002 - Add a table to store blocked IP addresses. 7003 - Update {blocked_ips} with valid IP addresses from {access}. 7004 - Remove hardcoded numeric deltas from all blocks in core. 7005 - Remove throttle columns and variables. 7007 - Convert to new method of storing permissions. This update is in system.install rather than user.install so that all modules can use the updated permission scheme during their updates. 7009 - Rename the variable for primary links. 7011 - Split the 'bypass node access' permission from 'administer nodes'. 7013 - Convert default time zone offset to default time zone name. 7015 - Change the user logout path. 7016 - Remove custom datatype _unsigned in PostgreSQL. 7017 - Change the theme setting 'toggle_node_info' into a per content type variable. 7018 - Shorten the {system}.type column and modify indexes. 7020 - Enable field and field_ui modules. 7021 - Change the PHP for settings permission. 7027 - Enable field type modules. 7029 - Add new 'view own unpublished content' permission for authenticated users. Preserves legacy behavior from Drupal 6.x. 7032 - Alter field hostname to identifier in the {flood} table. 7033 - Move CACHE_AGGRESSIVE to CACHE_NORMAL. 7034 - Migrate the file path settings and create the new {file_managed} table. 7036 - Split the 'access site in maintenance mode' permission from 'administer site configuration'. 7042 - Upgrade the {url_alias} table and create a cache bin for path aliases. 7044 - Drop the actions_aid table. 7045 - Add expiration field to the {flood} table. 7046 - Switch from the Minnelli theme if it is the default or admin theme. 7047 - Normalize the front page path variable. 7048 - Convert path languages from the empty string to LANGUAGE_NONE. 7049 - Rename 'Default' profile to 'Standard.' 7050 - Change {batch}.id column from serial to regular int. 7051 - make the IP field IPv6 compatible 7052 - Rename file to include_file in {menu_router} table. 7053 - Upgrade standard blocks and menus. 7054 - Remove {cache_}.headers columns. 7055 - Converts fields that store serialized variables from text to blob. 7057 - Increase the size of session-ids. 7058 - Remove cron semaphore variable. 7059 - Create the {file_usage} table. 7060 - Create fields in preparation for migrating upload.module to file.module. 7061 - Migrate upload.module data to the newly created file field. 7062 - Replace 'system_list' index with 'bootstrap' index on {system}. 7063 - Delete {menu_links} records for 'type' => MENU_CALLBACK which would not appear in a fresh install. 7064 - Remove block_callback field from {menu_router}. 7065 - Remove the default value for sid. 7066 - Migrate the 'file_directory_temp' variable. 7067 - Grant administrators permission to view the administration theme. 7068 - Update {url_alias}.language description. 7069 - Remove the obsolete 'site_offline' variable. @see update_fix_d7_requirements() 7070 - Remove the obsolete 'drupal_badge_color' and 'drupal_badge_size' variables. 7071 - Add index missed during upgrade, and fix field default. block module : 7000 - Set system.weight to a low value for block module. Block should go first so that other modules can alter its output during hook_page_alter(). Almost everything on the page is a block, so before block module runs, there will not be much to alter. 7002 - Rename {blocks} table to {block}, {blocks_roles} to {block_role} and {boxes} to {block_custom}. 7003 - Change the weight column to normal int. 7004 - Add new blocks to new regions, migrate custom variables to blocks. 7005 - Update the {block_custom}.format column. 7006 - Recreates cache_block table. Converts fields that hold serialized variables from text to blob. Removes 'headers' column. 7007 - Change {block_custom}.format into varchar. 7008 - Update database to match Drupal 7 schema. color module : 7001 - Warn site administrator if unsafe CSS color codes are found in the database. comment module : 7000 - Rename comment display setting variables. 7001 - Change comment status from published being 0 to being 1 7002 - Rename {comments} table to {comment} and upgrade it. 7003 - Split {comment}.timestamp into 'created' and 'changed', improve indexing on {comment}. 7004 - Upgrade the {node_comment_statistics} table. 7005 - Create the comment_body field. 7006 - Migrate data from the comment field to field storage. 7007 - Add an index to the created column. 7008 - Update database to match Drupal 7 schema. dblog module : 7001 - Update the {watchdog} table. filter module : 7000 - Upgrade the {filter_formats} table and rename it to {filter_format}. 7001 - Break out "escape HTML filter" option to its own filter. 7003 - Upgrade the {filter} table for core filters. 7005 - Integrate text formats with the user permissions system. This function converts text format role assignments to use the new text format permissions introduced in Drupal 7, creates a fallback (plain text) format that is available to all users, and explicitly sets the text format in cases that used to rely on a single site-wide default. 7008 - Grant usage of all text formats to user roles having the 'administer filters' permission. 7009 - Converts fields that store serialized variables from text to blob. 7010 - Change {filter_format}.format and {filter}.format into varchar. node module : 7000 - Upgrade the node type table and fix node type 'module' attribute to avoid name-space conflicts. 7001 - Rename {node_revisions} table to {node_revision}. 7002 - Extend the node_promote_status index to include all fields required for the node page query. 7003 - Remove the node_counter if the statistics module is uninstalled. 7004 - Extend the existing default preview and teaser settings to all node types. 7005 - Add statuscommentpromote and sticky columns to the {node_revision} table. 7006 - Convert body and teaser from node properties to fields, and migrate statuscommentpromote and sticky columns to the {node_revision} table. 7007 - Remove column min_word_count. 7008 - Split the 'administer nodes' permission from 'access content overview'. 7009 - Convert node languages from the empty string to LANGUAGE_NONE. 7010 - Add the {block_node_type} table. 7011 - Update the database from Drupal 6 to match the schema. taxonomy module : 7001 - Rename taxonomy tables. 7002 - Add {vocabulary}.machine_name column. 7003 - Remove the related terms setting from vocabularies. This setting has not been used since Drupal 6. The {taxonomy_relations} table itself is retained to allow for data to be upgraded. 7004 - Move taxonomy vocabulary associations for nodes to fields and field instances. 7005 - Migrate {taxonomy_term_node} table to field storage. @todo: This function can possibly be made much faster by wrapping a transaction around all the inserts. 7006 - Add {taxonomy_term_data}.format column. 7007 - Add index on {taxonomy_term_data}.name column to speed up taxonomy_get_term_by_name(). 7008 - Change the weight columns to normal int. 7009 - Change {taxonomy_term_data}.format into varchar. 7010 - Change {taxonomy_index}.created to support signed int. update module : 7000 - Create a queue to store tasks for requests to fetch available update data. 7001 - Recreates cache_update table. Converts fields that hold serialized variables from text to blob. Removes 'headers' column. user module : 7000 - Increase the length of the password field to accommodate better hashes. Also re-hashes all current passwords to improve security. This may be a lengthy process, and is performed batch-wise. 7001 - Remove the 'threshold', 'mode' and 'sort' columns from the {users} table. These fields were previously used to store per-user comment settings. 7002 - Convert user time zones from time zone offsets to time zone names. 7003 - Update user settings for cancelling user accounts. Prior to 7.x, users were not able to cancel their accounts. When administrators deleted an account, all contents were assigned to uid 0, which is the same as the 'user_cancel_reassign' method now. 7005 - Changes the users table to allow longer e-mail addresses. 7006 - Add module data to {role_permission}. 7007 - Add a weight column to user roles. 7008 - If 'user_register' variable was unset in Drupal 6, set it to be the same as the Drupal 6 default setting. 7009 - Converts fields that store serialized variables from text to blob. 7010 - Update the {user}.signature_format column. 7011 - Updates email templates to use new tokens. This function upgrades customized email templates from the old !token format to the new core tokens format. Additionally, in Drupal 7 we no longer e-mail plain text passwords to users, and there is no token for a plain text password in the new token system. Therefore, it also modifies any saved templates using the old '!password' token such that the token is removed, and displays a warning to users that they may need to go and modify the wording of their templates. 7012 - Add the user's pictures to the {file_managed} table and make them managed files. 7013 - Add user module file usage entries. 7014 - Rename the 'post comments without approval' permission. In Drupal 7, this permission has been renamed to 'skip comment approval'. 7015 - Change {users}.signature_format into varchar. 7016 - Update the database to match the schema. Do you wish to run all pending updates? (y/n): y Some user time zones have been emptied and need to be set to the correct values. Use the new time zone options to choose whether to remind [warning] users at login to set the correct time zone. The default time zone has been set to UTC. Check the date and time configuration page to configure it correctly. [warning] A new Plain text format has been created which will be available to all users. You can configure this text format on the text format [status] configuration page. Finished performing updates. [ok] lyricnz:drupal-7.2 simonroberts$ ## check it works screenshot # upgrade to 7.7 lyricnz:drupal-7.2 simonroberts$ cd ../ lyricnz:htdocs simonroberts$ sudo rm -rf drupal-7.7 Password: lyricnz:htdocs simonroberts$ drush dl drupal-7.7 Project drupal (7.7) downloaded to /Users/simonroberts/htdocs/drupal-7.7. [success] Project drupal contains: [success] - 3 profiles: testing, standard, minimal - 4 themes: stark, seven, garland, bartik - 47 modules: drupal_system_listing_incompatible_test, drupal_system_listing_compatible_test, user, update, trigger, translation, tracker, toolbar, taxonomy, system, syslog, statistics, simpletest, shortcut, search, rdf, profile, poll, php, path, overlay, openid, node, menu, locale, image, help, forum, filter, file, field_ui, text, options, number, list, field_sql_storage, field, dblog, dashboard, contextual, contact, comment, color, book, blog, block, aggregator lyricnz:htdocs simonroberts$ cp drupal-7.2/sites/default/settings.php drupal-7.7/sites/default/ lyricnz:htdocs simonroberts$ cd drupal-7.7 lyricnz:drupal-7.7 simonroberts$ drush updatedb The following updates are pending: menu module : 7000 - Migrate the "Default menu for content" setting to individual node types. 7001 - Rename "Primary Links" and "Secondary Links" to their Drupal 7 equivalents. user module : 7017 - Update email templates to use new tokens. This function upgrades customized email templates from the old !token format to the new core tokens format. Additionally, in Drupal 7 we no longer e-mail plain text passwords to users, and there is no token for a plain text password in the new token system. Therefore, it also modifies any saved templates using the old '!password' token such that the token is removed, and displays a warning to users that they may need to go and modify the wording of their templates. Do you wish to run all pending updates? (y/n): y Finished performing updates. [ok] lyricnz:drupal-7.7 simonroberts$ ## check it works screenshot