Cum să schimb numele bazei de date şi prefixul tabelelor?

[Sylver Cheetah 53]

Salut!

Doresc să schimb numele bazei de date şi prefixul tabelelor. Cum pot face asta?

Mulţumesc.

[Sylver Cheetah 53]

Vreau din phpMyAdmin să fac asta.

[dorin]

Vezi aici un video:

http://www.youtube.com/watch?v=PDjCuFg1Jbg

[Sylver Cheetah 53]

Vezi aici un video:

http://www.youtube.com/watch?v=PDjCuFg1Jbg

Mersi mult! A mers. Am întrebat şi pe phpBB.com şi nu m-a ajutat nimeni.
Acuma mai vreau să schimb prefixul tabelelor din phpBB3 în phpBB.

[Anișor]

Trebuie sa faci un query pentru fiecare tabel.
Exemplu :

Cod: Selectaţi tot

RENAME table `phpbb3_users` TO `phpbb_users`;  

[Sylver Cheetah 53]

Mersi mult. A mers.
Poate vor si altii:

Cod: Selectaţi tot

RENAME table `phpbb3_acl_groups` TO `phpbb_acl_groups`;
RENAME table `phpbb3_acl_options` TO `phpbb_acl_options`;
RENAME table `phpbb3_acl_roles` TO `phpbb_acl_roles`;
RENAME table `phpbb3_acl_roles_data` TO `phpbb_acl_roles_data`;
RENAME table `phpbb3_acl_users` TO `phpbb_acl_users`;
RENAME table `phpbb3_attachments` TO `phpbb_attachments`;
RENAME table `phpbb3_banlist` TO `phpbb_banlist`;
RENAME table `phpbb3_bbcodes` TO `phpbb_bbcodes`;
RENAME table `phpbb3_bookmarks` TO `phpbb_bookmarks`;
RENAME table `phpbb3_bots` TO `phpbb_bots`;
RENAME table `phpbb3_captcha_answers` TO `phpbb_captcha_answers`;
RENAME table `phpbb3_captcha_questions` TO `phpbb_captcha_questions`;
RENAME table `phpbb3_config` TO `phpbb_config`;
RENAME table `phpbb3_confirm` TO `phpbb_confirm`;
RENAME table `phpbb3_disallow` TO `phpbb_disallow`;
RENAME table `phpbb3_drafts` TO `phpbb_drafts`;
RENAME table `phpbb3_extensions` TO `phpbb_extensions`;
RENAME table `phpbb3_extension_groups` TO `phpbb_extension_groups`;
RENAME table `phpbb3_forums` TO `phpbb_forums`;
RENAME table `phpbb3_forums_access` TO `phpbb_forums_access`;
RENAME table `phpbb3_forums_track` TO `phpbb_forums_track`;
RENAME table `phpbb3_forums_watch` TO `phpbb_forums_watch`;
RENAME table `phpbb3_groups` TO `phpbb_groups`;
RENAME table `phpbb3_icons` TO `phpbb_icons`;
RENAME table `phpbb3_lang` TO `phpbb_lang`;
RENAME table `phpbb3_log` TO `phpbb_log`;
RENAME table `phpbb3_login_attempts` TO `phpbb_login_attempts`;
RENAME table `phpbb3_moderator_cache` TO `phpbb_moderator_cache`;
RENAME table `phpbb3_modules` TO `phpbb_modules`;
RENAME table `phpbb3_poll_options` TO `phpbb_poll_options`;
RENAME table `phpbb3_poll_votes` TO `phpbb_poll_votes`;
RENAME table `phpbb3_posts` TO `phpbb_posts`;
RENAME table `phpbb3_privmsgs` TO `phpbb_privmsgs`;
RENAME table `phpbb3_privmsgs_folder` TO `phpbb_privmsgs_folder`;
RENAME table `phpbb3_privmsgs_rules` TO `phpbb_privmsgs_rules`;
RENAME table `phpbb3_privmsgs_to` TO `phpbb_privmsgs_to`;
RENAME table `phpbb3_profile_fields` TO `phpbb_profile_fields`;
RENAME table `phpbb3_profile_fields_data` TO `phpbb_profile_fields_data`;
RENAME table `phpbb3_profile_fields_lang` TO `phpbb_profile_fields_lang`;
RENAME table `phpbb3_profile_lang` TO `phpbb_profile_lang`;
RENAME table `phpbb3_qa_confirm` TO `phpbb_qa_confirm`;
RENAME table `phpbb3_ranks` TO `phpbb_ranks`;
RENAME table `phpbb3_reports` TO `phpbb_reports`;
RENAME table `phpbb3_reports_reasons` TO `phpbb_reports_reasons`;
RENAME table `phpbb3_search_results` TO `phpbb_search_results`;
RENAME table `phpbb3_search_wordlist` TO `phpbb_search_wordlist`;
RENAME table `phpbb3_search_wordmatch` TO `phpbb_search_wordmatch`;
RENAME table `phpbb3_sessions` TO `phpbb_sessions`;
RENAME table `phpbb3_sessions_keys` TO `phpbb_sessions_keys`;
RENAME table `phpbb3_sitelist` TO `phpbb_sitelist`;
RENAME table `phpbb3_smilies` TO `phpbb_smilies`;
RENAME table `phpbb3_styles` TO `phpbb_styles`;
RENAME table `phpbb3_styles_imageset` TO `phpbb_styles_imageset`;
RENAME table `phpbb3_styles_imageset_data` TO `phpbb_styles_imageset_data`;
RENAME table `phpbb3_styles_template` TO `phpbb_styles_template`;
RENAME table `phpbb3_styles_template_data` TO `phpbb_styles_template_data`;
RENAME table `phpbb3_styles_theme` TO `phpbb_styles_theme`;
RENAME table `phpbb3_topics` TO `phpbb_topics`;
RENAME table `phpbb3_topics_posted` TO `phpbb_topics_posted`;
RENAME table `phpbb3_topics_track` TO `phpbb_topics_track`;
RENAME table `phpbb3_topics_watch` TO `phpbb_topics_watch`;
RENAME table `phpbb3_users` TO `phpbb_users`;
RENAME table `phpbb3_user_group` TO `phpbb_user_group`;
RENAME table `phpbb3_warnings` TO `phpbb_warnings`;
RENAME table `phpbb3_words` TO `phpbb_words`;
RENAME table `phpbb3_zebra` TO `phpbb_zebra`;