db ?: How to insert fields via phpMyadmin

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
IgnorantNewGuy
Registered User
Posts: 452
Joined: Thu Jul 14, 2005 9:27 pm

db ?: How to insert fields via phpMyadmin

Post by IgnorantNewGuy » Fri Mar 02, 2007 8:51 pm

If anybody knows how to do the following, I would greatly appreciate a little tutorial.

Through phpMyadmin I have copied all of the banned domains from one of my forums into Excel (225 of them) and I now want to insert them into another of my forums via phpMyadmin. Does anybody know how to do this?

geocator
Registered User
Posts: 16242
Joined: Fri Jan 09, 2004 11:56 pm
Location: On dry land
Contact:

Post by geocator » Fri Mar 02, 2007 8:57 pm

The better way is to do a backup of the banlist table and then restore it. With what you have you have to change each into a sql statement, in which case you might as well use the admin panel.

IgnorantNewGuy
Registered User
Posts: 452
Joined: Thu Jul 14, 2005 9:27 pm

Post by IgnorantNewGuy » Fri Mar 02, 2007 9:01 pm

I think I understand that. Just back up the banlist table and then restore that table over at the other forum's db? That makes sense.

I really don't want to sit there and type in 100+ domains again.

Locked

Return to “2.0.x Support Forum”