Code: Select all
SELECT concat( 'ALTER TABLE phpbb_acl_options MODIFY auth_option_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( auth_option_id ), 0 )+ 1, ';' ) AS query FROM phpbb_acl_options UNION
SELECT concat( 'ALTER TABLE phpbb_acl_roles MODIFY role_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( role_id ), 0 )+ 1, ';' ) AS query FROM phpbb_acl_roles UNION
SELECT concat( 'ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( attach_id ), 0 )+ 1, ';' ) AS query FROM phpbb_attachments UNION
SELECT concat( 'ALTER TABLE phpbb_banlist MODIFY ban_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( ban_id ), 0 )+ 1, ';' ) AS query FROM phpbb_banlist UNION
SELECT concat( 'ALTER TABLE phpbb_bots MODIFY bot_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( bot_id ), 0 )+ 1, ';' ) AS query FROM phpbb_bots UNION
SELECT concat( 'ALTER TABLE phpbb_disallow MODIFY disallow_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( disallow_id ), 0 )+ 1, ';' ) AS query FROM phpbb_disallow UNION
SELECT concat( 'ALTER TABLE phpbb_drafts MODIFY draft_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( draft_id ), 0 )+ 1, ';' ) AS query FROM phpbb_drafts UNION
SELECT concat( 'ALTER TABLE phpbb_extension_groups MODIFY group_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( group_id ), 0 )+ 1, ';' ) AS query FROM phpbb_extension_groups UNION
SELECT concat( 'ALTER TABLE phpbb_extensions MODIFY extension_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( extension_id ), 0 )+ 1, ';' ) AS query FROM phpbb_extensions UNION
SELECT concat( 'ALTER TABLE phpbb_forums MODIFY forum_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( forum_id ), 0 )+ 1, ';' ) AS query FROM phpbb_forums UNION
SELECT concat( 'ALTER TABLE phpbb_groups MODIFY group_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( group_id ), 0 )+ 1, ';' ) AS query FROM phpbb_groups UNION
SELECT concat( 'ALTER TABLE phpbb_icons MODIFY icons_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( icons_id ), 0 )+ 1, ';' ) AS query FROM phpbb_icons UNION
SELECT concat( 'ALTER TABLE phpbb_lang MODIFY lang_id tinyint(4) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( lang_id ), 0 )+ 1, ';' ) AS query FROM phpbb_lang UNION
SELECT concat( 'ALTER TABLE phpbb_log MODIFY log_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( log_id ), 0 )+ 1, ';' ) AS query FROM phpbb_log UNION
SELECT concat( 'ALTER TABLE phpbb_modules MODIFY module_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( module_id ), 0 )+ 1, ';' ) AS query FROM phpbb_modules UNION
SELECT concat( 'ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( post_id ), 0 )+ 1, ';' ) AS query FROM phpbb_posts UNION
SELECT concat( 'ALTER TABLE phpbb_privmsgs MODIFY msg_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( msg_id ), 0 )+ 1, ';' ) AS query FROM phpbb_privmsgs UNION
SELECT concat( 'ALTER TABLE phpbb_privmsgs_folder MODIFY folder_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( folder_id ), 0 )+ 1, ';' ) AS query FROM phpbb_privmsgs_folder UNION
SELECT concat( 'ALTER TABLE phpbb_privmsgs_rules MODIFY rule_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( rule_id ), 0 )+ 1, ';' ) AS query FROM phpbb_privmsgs_rules UNION
SELECT concat( 'ALTER TABLE phpbb_profile_fields MODIFY field_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( field_id ), 0 )+ 1, ';' ) AS query FROM phpbb_profile_fields UNION
SELECT concat( 'ALTER TABLE phpbb_ranks MODIFY rank_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( rank_id ), 0 )+ 1, ';' ) AS query FROM phpbb_ranks UNION
SELECT concat( 'ALTER TABLE phpbb_reports MODIFY report_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( report_id ), 0 )+ 1, ';' ) AS query FROM phpbb_reports UNION
SELECT concat( 'ALTER TABLE phpbb_reports_reasons MODIFY reason_id smallint(4) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( reason_id ), 0 )+ 1, ';' ) AS query FROM phpbb_reports_reasons UNION
SELECT concat( 'ALTER TABLE phpbb_search_wordlist MODIFY word_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( word_id ), 0 )+ 1, ';' ) AS query FROM phpbb_search_wordlist UNION
SELECT concat( 'ALTER TABLE phpbb_sitelist MODIFY site_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( site_id ), 0 )+ 1, ';' ) AS query FROM phpbb_sitelist UNION
SELECT concat( 'ALTER TABLE phpbb_smilies MODIFY smiley_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( smiley_id ), 0 )+ 1, ';' ) AS query FROM phpbb_smilies UNION
SELECT concat( 'ALTER TABLE phpbb_styles MODIFY style_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( style_id ), 0 )+ 1, ';' ) AS query FROM phpbb_styles UNION
SELECT concat( 'ALTER TABLE phpbb_topics MODIFY topic_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( topic_id ), 0 )+ 1, ';' ) AS query FROM phpbb_topics UNION
SELECT concat( 'ALTER TABLE phpbb_users MODIFY user_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( user_id ), 0 )+ 1, ';' ) AS query FROM phpbb_users UNION
SELECT concat( 'ALTER TABLE phpbb_warnings MODIFY warning_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( warning_id ), 0 )+ 1, ';' ) AS query FROM phpbb_warnings UNION
SELECT concat( 'ALTER TABLE phpbb_words MODIFY word_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= ', coalesce( max( word_id ), 0 )+ 1, ';' ) AS query FROM phpbb_words
ORDER BY 1;
The output should look like this (with the actual values at the end being different, of course):
Code: Select all
ALTER TABLE phpbb_acl_options MODIFY auth_option_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 194;
ALTER TABLE phpbb_acl_roles MODIFY role_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 30;
ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_banlist MODIFY ban_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 617036;
ALTER TABLE phpbb_bots MODIFY bot_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 386;
ALTER TABLE phpbb_disallow MODIFY disallow_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_drafts MODIFY draft_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 99;
ALTER TABLE phpbb_extensions MODIFY extension_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 67;
ALTER TABLE phpbb_extension_groups MODIFY group_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 10;
ALTER TABLE phpbb_forums MODIFY forum_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 405;
ALTER TABLE phpbb_groups MODIFY group_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 23;
ALTER TABLE phpbb_icons MODIFY icons_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 12;
ALTER TABLE phpbb_lang MODIFY lang_id tinyint(4) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 5;
ALTER TABLE phpbb_log MODIFY log_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 674569;
ALTER TABLE phpbb_modules MODIFY module_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 343;
ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1403168;
ALTER TABLE phpbb_privmsgs MODIFY msg_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 53856;
ALTER TABLE phpbb_privmsgs_folder MODIFY folder_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 51;
ALTER TABLE phpbb_privmsgs_rules MODIFY rule_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_profile_fields MODIFY field_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_ranks MODIFY rank_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 44;
ALTER TABLE phpbb_reports MODIFY report_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 3884;
ALTER TABLE phpbb_reports_reasons MODIFY reason_id smallint(4) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 14;
ALTER TABLE phpbb_search_wordlist MODIFY word_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_sitelist MODIFY site_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_smilies MODIFY smiley_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 520;
ALTER TABLE phpbb_styles MODIFY style_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 8;
ALTER TABLE phpbb_topics MODIFY topic_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 325367;
ALTER TABLE phpbb_users MODIFY user_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 4895;
ALTER TABLE phpbb_warnings MODIFY warning_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 22;
ALTER TABLE phpbb_words MODIFY word_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 16;
These are (obviously) 31 separate queries, which you can either execute one by one (better) or all at once (risky). Tables with many rows may take quite a while, so waiting for 10 minutes on one table might still be normal.
That's a different problem which we will advance after everything else was successfully (which you can verify when
directive afterwards.