How can I export a MySQL table with a different name using phpmyadmin?

[jaks]

How can I export a MySQL table with a different name using phpmyadmin?

I want to export
nuke_bbsearch_w ordmatch
and all it contents to
phpbb_search_wo rdmatch
This table in a different db. Fields are the same just the name needs to be
changed. When exporting. I have been editting the rest of the table I need
manually bt editting them in notepad but the table 4 columns and has 170,000
entries.

Example:
I need to change entires like these 170,000 times
INSERT INTO `nuke_bbsearch_ wordmatch` VALUES (4146, 192, 0);
to
INSERT INTO `phpbb_search_w ordmatch` VALUES (4146, 192, 0);

Any help would be greatly appreciated.
Thanks in advance

Jaks

[Bill Karwin]

jaks wrote:

How can I export a MySQL table with a different name using phpmyadmin?
I have been editting the rest of the table I need
manually bt editting them in notepad but the table 4 columns and has 170,000
entries.

I have a couple of possible solutions.

You could copy the table to the name you want and then back up that table:
CREATE TABLE phpbb_search_wo rdmatch SELECT * FROM nuke_bbsearch_w ordmatch;

Another solution is to use an editing solution other that Notepad (which
I eschew for a variety of reasons). Have you ever used Perl or sed?
I realize by mentioning notepad you must be on Windows. Stream-oriented
editing tools are not installed by default on Windows. But there are
several ports of UNIX-originating tools including Perl and sed available
for free:
http://www.activestate.com/Products/ActivePerl/
http://unxutils.sourceforge.net/
http://www.cygwin.com/

For instance, you could output your table dump using mysqladmin (or
mysqldump or whatever), and end up with a file "wordmatch. sql"
containing references to table "nuke_bbsearch_ wordmatch".

Then filter it with Perl:
C:> perl -pi -e 's/\bnuke_bbsearch _wordmatch\b/phpbb_search_wo rdmatch/g'
wordmatch.sql

The command above should use Perl to edit the file in place,
substituting the table names (the \b is to make sure that string is at a
word boundary).

Regards,
Bill K.

[steve]

"nospamhere " wrote:

How can I export a MySQL table with a different name using
phpmyadmin?

I want to export
nuke_bbsearch_w ordmatch
and all it contents to
phpbb_search_wo rdmatch
This table in a different db. Fields are the same just the
name needs to be
changed. When exporting. I have been editting the rest of the
table I need
manually bt editting them in notepad but the table 4 columns
and has 170,000
entries.

Example:
I need to change entires like these 170,000 times
INSERT INTO `nuke_bbsearch_ wordmatch` VALUES (4146, 192, 0);
to
INSERT INTO `phpbb_search_w ordmatch` VALUES (4146, 192, 0);

Any help would be greatly appreciated.
Thanks in advance

Jaks

copy it to the similar named table, then rename the resulting table in
phpmyadmin (in operations tab).

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-export...ict224317.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=773240