SOLVED Rename All The Prefix For Tables In Database: ???


Subject: Rename All The Prefix For Tables In Database: ???
Hi does anybody know if its possible to rename all the Prefix for tables in database: from Phpbb_ to ip_ at once or do they have to be done individually Example, Phpbb_categories To Ip_categories etc. ?

Last edited by batman on Mon 10 Sep, 2012 11:33; edited 1 time in total
Profile PM  
Subject: Re: SQL For Changing Example, Phpbb_categories To Ip_categories
You need to use phpMyAdmin to rename the database and then rename the tables or vice versa.

The other option is to dump the Db in an editor and do a search (phpbb_) and replace (ip_)

:mryellow:

Profile PM  
Subject: Re: Rename All The Prefix For Tables In Database: ???
Hi sorry Mort just edited my post

Profile PM  
Subject: Re: Rename All The Prefix For Tables In Database: ???
phpMyAdmin will rename all the table prefixes in one go.

select all -> with selected -> rename prefix.

Popup -> from -> to

GO!

Profile PM  
Subject: Re: Rename All The Prefix For Tables In Database: ???
thank Mort i just replaced all in notepad, thanks 8)

Profile PM  
Subject: Re: Rename All The Prefix For Tables In Database: ???
That is the easiest way and is generally what everyone does. :mryellow:

Profile PM  
Subject: Re: [SOLVED] Rename All The Prefix For Tables In Database: ???
I'm new user and I used icy phoenix 1.3 before and HP0-J67 braindumps - testking
I pass icy phoenix 2.0 and want to install the mod shop forum but I asked to modify files that are not as "includes/page_header.php" and would like to know this where it is located but nothing.

Subject: Re: [SOLVED] Rename All The Prefix For Tables In Database: ???
Hello,

to have a mod adapted, please ask in a new topic, in the "MODs Discussions" forum.

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.2687s (PHP: 10% SQL: 90%)
SQL queries: 16 - Debug Off - GZIP Enabled