Однако оный был для двойки.
Изменить префикс можно при помощи phpMyAdmin или любого другого средства администрирования БД, либо при помощи php-скрипта. В первом случае вам понадобится выполнить такие запросы:
Код: Выделить всё
ALTER TABLE phpbb_acl_groups RENAME phpbb2_acl_groups;
ALTER TABLE phpbb_acl_options RENAME phpbb2_acl_options;
ALTER TABLE phpbb_acl_roles RENAME phpbb2_acl_roles;
ALTER TABLE phpbb_acl_roles_data RENAME phpbb2_acl_roles_data;
ALTER TABLE phpbb_acl_users RENAME phpbb2_acl_users;
ALTER TABLE phpbb_attachments RENAME phpbb2_attachments;
ALTER TABLE phpbb_banlist RENAME phpbb2_banlist;
ALTER TABLE phpbb_bbcodes RENAME phpbb2_bbcodes;
ALTER TABLE phpbb_bookmarks RENAME phpbb2_bookmarks;
ALTER TABLE phpbb_bots RENAME phpbb2_bots;
ALTER TABLE phpbb_config RENAME phpbb2_config;
ALTER TABLE phpbb_confirm RENAME phpbb2_confirm;
ALTER TABLE phpbb_disallow RENAME phpbb2_disallow;
ALTER TABLE phpbb_drafts RENAME phpbb2_drafts;
ALTER TABLE phpbb_extensions RENAME phpbb2_extensions;
ALTER TABLE phpbb_extension_groups RENAME phpbb2_extension_groups;
ALTER TABLE phpbb_forums RENAME phpbb2_forums;
ALTER TABLE phpbb_forums_access RENAME phpbb2_forums_access;
ALTER TABLE phpbb_forums_track RENAME phpbb2_forums_track;
ALTER TABLE phpbb_forums_watch RENAME phpbb2_forums_watch;
ALTER TABLE phpbb_groups RENAME phpbb2_groups;
ALTER TABLE phpbb_icons RENAME phpbb2_icons;
ALTER TABLE phpbb_lang RENAME phpbb2_lang;
ALTER TABLE phpbb_log RENAME phpbb2_log;
ALTER TABLE phpbb_moderator_cache RENAME phpbb2_moderator_cache;
ALTER TABLE phpbb_modules RENAME phpbb2_modules;
ALTER TABLE phpbb_poll_options RENAME phpbb2_poll_options;
ALTER TABLE phpbb_poll_votes RENAME phpbb2_poll_votes;
ALTER TABLE phpbb_posts RENAME phpbb2_posts;
ALTER TABLE phpbb_privmsgs RENAME phpbb2_privmsgs;
ALTER TABLE phpbb_privmsgs_folder RENAME phpbb2_privmsgs_folder;
ALTER TABLE phpbb_privmsgs_rules RENAME phpbb2_privmsgs_rules;
ALTER TABLE phpbb_privmsgs_to RENAME phpbb2_privmsgs_to;
ALTER TABLE phpbb_profile_fields RENAME phpbb2_profile_fields;
ALTER TABLE phpbb_profile_fields_data RENAME phpbb2_profile_fields_data;
ALTER TABLE phpbb_profile_fields_lang RENAME phpbb2_profile_fields_lang;
ALTER TABLE phpbb_profile_lang RENAME phpbb2_profile_lang;
ALTER TABLE phpbb_ranks RENAME phpbb2_ranks;
ALTER TABLE phpbb_reports RENAME phpbb2_reports;
ALTER TABLE phpbb_reports_reasons RENAME phpbb2_reports_reasons;
ALTER TABLE phpbb_search_results RENAME phpbb2_search_results;
ALTER TABLE phpbb_search_wordlist RENAME phpbb2_search_wordlist;
ALTER TABLE phpbb_search_wordmatch RENAME phpbb2_search_wordmatch;
ALTER TABLE phpbb_sessions RENAME phpbb2_sessions;
ALTER TABLE phpbb_sessions_keys RENAME phpbb2_sessions_keys;
ALTER TABLE phpbb_sitelist RENAME phpbb2_sitelist;
ALTER TABLE phpbb_smilies RENAME phpbb2_smilies;
ALTER TABLE phpbb_styles RENAME phpbb2_styles;
ALTER TABLE phpbb_styles_imageset RENAME phpbb2_styles_imageset;
ALTER TABLE phpbb_styles_imageset_data RENAME phpbb2_styles_imageset_data;
ALTER TABLE phpbb_styles_template RENAME phpbb2_styles_template;
ALTER TABLE phpbb_styles_template_data RENAME phpbb2_styles_template_data;
ALTER TABLE phpbb_styles_theme RENAME phpbb2_styles_theme;
ALTER TABLE phpbb_topics RENAME phpbb2_topics;
ALTER TABLE phpbb_topics_posted RENAME phpbb2_topics_posted;
ALTER TABLE phpbb_topics_track RENAME phpbb2_topics_track;
ALTER TABLE phpbb_topics_watch RENAME phpbb2_topics_watch;
ALTER TABLE phpbb_users RENAME phpbb2_users;
ALTER TABLE phpbb_user_group RENAME phpbb2_user_group;
ALTER TABLE phpbb_warnings RENAME phpbb2_warnings;
ALTER TABLE phpbb_words RENAME phpbb2_words;
ALTER TABLE phpbb_zebra RENAME phpbb2_zebra;
Финальный шаг - редактирование файла config.php. Откройте его в простейшем текстовом редакторе, найдите там строку $table_prefix = 'phpbb_'; или подобную ей и замените ваш старый префикс на новый.
Текст честно стырил со статьи 2.0.