[Ask God] How to copy discuz X3.2 database? ---- Attachment appears 'Appears, the attachment cannot be read.

discuz x3.2 ---- The attachment appears "Sorry, the attachment cannot be read"

[The reason has been found. It is due to the database. Manual copying of table information is too complicated. I hope the master can give me a trick to automatically batch commands and copy simultaneously]

The reason why the attachment cannot be read:
The aid tid, pid uid and tableid in pre_forum_attachment_0 to pre_forum_attachment_9 are missing in the pre_forum_attachment part (attachments uploaded later can be downloaded, but previously uploaded attachments cannot be downloaded)

Several old attachments have been repaired manually - they can be downloaded normally

The reason why I can find this is all based on guessing. Since I don’t understand databases and database commands at all, I can only repair them one by one manually. This kind of repair is inefficient and afraid of missing.

Now I ask the master to give me a way to automate batch commands, which can quickly and efficiently copy the sub-tables from pre_forum_attachment_0 to pre_forum_attachment_9 (only need aid tid pid uid tableid) to pre_forum_attachment (copy the ones that are not there, skip the existing ones) )】

Reply content:

discuz x3.2 ---- The attachment appears "Sorry, the attachment cannot be read"

[The reason has been found. It is due to the database. Manual copying of table information is too complicated. I hope the master can give me a trick to automatically batch commands and copy simultaneously]

The reason why the attachment cannot be read:
The aid tid, pid uid and tableid in pre_forum_attachment_0 to pre_forum_attachment_9 are missing in the pre_forum_attachment part (attachments uploaded later can be downloaded, but previously uploaded attachments cannot be downloaded)

Several old attachments have been repaired manually - they can be downloaded normally

The reason why I can find this is all based on guessing. Since I don’t understand databases and database commands at all, I can only repair them one by one manually. This kind of repair is inefficient and afraid of missing.

Now I ask the master to give me a way to automate batch commands, which can quickly and efficiently copy the sub-tables from pre_forum_attachment_0 to pre_forum_attachment_9 (only need aid tid pid uid tableid) to pre_forum_attachment (copy the ones that are not there, skip the existing ones) )】