PDA

View Full Version : Copy attachments and put in other board?


Jain Farstrider
03-08-2014, 02:40 AM
Is there a way to copy the attachment extensions and set size/content type and put it into another board's attachment management.

Took me a while to put all the attachment extensions such as .ods, .odt, .tiff and so on into the attachment manager list and do not really want to re-do the whole thing one by one again for my second board.

tbworld
03-08-2014, 02:52 AM
This information is stored in a table named "attachmenttype" in your database. You can simply copy the table from your old database to your new database as there are know indexes/ID's or field linkages involved.

Jain Farstrider
03-08-2014, 03:14 AM
I get error when I try to import it into my other board.

tbworld
03-08-2014, 03:23 AM
First of all picture was hard to read (Just letting you know for the future). Drop the table and just insert the new table from the other database. You are trying to insert onto an already existing row that is indexed.

Please make a backup of your sites before proceeding. :)

Jain Farstrider
03-08-2014, 07:59 AM
Yes, it works perfectly.

The reason I did not delete at first is that it is 2014 and all files either just overwrite the existing ones or at least ask me if I wish to overwrite.

Just a minor thing but really, need to get up with the times :)

tbworld
03-08-2014, 09:50 AM
I am glad it worked for you. Thanks for letting me know the outcome.:)