Old Support Topics - Rename All The Prefix For Tables In Database: ???
batman [ Mon 10 Sep, 2012 10:48 ] Post 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. ?
mort [ Mon 10 Sep, 2012 11:30 ] Post 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_)
batman [ Mon 10 Sep, 2012 11:34 ] Post subject: Re: Rename All The Prefix For Tables In Database: ???
Hi sorry Mort just edited my post
mort [ Mon 10 Sep, 2012 11:41 ] Post 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!
batman [ Mon 10 Sep, 2012 11:45 ] Post subject: Re: Rename All The Prefix For Tables In Database: ???
thank Mort i just replaced all in notepad, thanks
mort [ Mon 10 Sep, 2012 11:49 ] Post subject: Re: Rename All The Prefix For Tables In Database: ???
That is the easiest way and is generally what everyone does.
runtoo75 [ Fri 19 Dec, 2014 13:01 ] Post 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.
Informpro [ Fri 19 Dec, 2014 19:27 ] Post subject: Re: [SOLVED] Rename All The Prefix For Tables In Database: ???