I want to install the same set of plugins on an empty forum that I had before. This way, after connecting the new database, the plugin files will already be in the system. How can I see in the MySQL database which plugins and their versions were installed before the crash?
Thank You
I have a question.SELECT addon_id, title, version_string FROM xf_addon;
What is "second import"?You can't import attachments and avatars without also importing users and user groups.
Unfortunately, though you'll be able to retain ids in the first import, when you try do a second import with the hope of matching ids, you won't be able to since Xenforo's importer will not allow the retain content id setting to be on after the first import.
Merging multiple imports so their users, attachments, avatars and threads/posts match up properly requires custom work. If you need that kind of service, contact me via conversation message. @Slavik can probably handle something like this as well.
I am buying a server on Hetzner without administration, and I am responsible for the administration myself.
The backup scheme was taken from here "Backup VM without downtime"
https://b14esh.com/virtualization/kvm/backup-vm-qemu-kvm-libvirt.html.
However, it turned out to have significant shortcomings
The files were corrupted. After converting from qcow2 to raw, it was possible to partially access the file system. However, only a very small portion of the files could be retrieved...
To clarify:
And something I commented on.. and got burned because highlighting that failure to do some upset some... Oh well.. reality frequently decides to bit folks.A timely reminder to us all, me included. Not only to check that your backups are being produced, but also periodically to ensure that you can actually restore from them.
No it will not delete anything "important" to the site.. it simply rebuilds the core. It's a reliable option to try if your site is having issues.View attachment 290964
This button?
Will it not delete anything?
Will it not reset the forum to its initial settings?
The directory number is based on the number of attachments.
Each directory contains 1,000 files.
The files within the directory are numbered sequentially starting from 0 to 999, prefixed with the directory number.
The file name is created randomly.
mysql> SELECT * FROM xf.xf_attachment_data WHERE file_hash = '5a6fba36d78b7d95e643a0e70bf79d26';
+---------+---------+-------------+----------+-----------+----------------------------------+-----------+-------+--------+-----------------+------------------+--------------+
| data_id | user_id | upload_date | filename | file_size | file_hash | file_path | width | height | thumbnail_width | thumbnail_height | attach_count |
+---------+---------+-------------+----------+-----------+----------------------------------+-----------+-------+--------+-----------------+------------------+--------------+
| 1211358 | 294933 | 1617441709 | 1.jpg | 80199 | 5a6fba36d78b7d95e643a0e70bf79d26 | | 1200 | 900 | 200 | 150 | 1 |
+---------+---------+-------------+----------+-----------+----------------------------------+-----------+-------+--------+-----------------+------------------+--------------+
1 row in set (0,23 sec)
mysql> SELECT * FROM xfn.xf_attachment_data WHERE file_hash = '5a6fba36d78b7d95e643a0e70bf79d26';
+---------+---------+-------------+----------+-----------+----------------------------------+-----------+-------+--------+-----------------+------------------+--------------+
| data_id | user_id | upload_date | filename | file_size | file_hash | file_path | width | height | thumbnail_width | thumbnail_height | attach_count |
+---------+---------+-------------+----------+-----------+----------------------------------+-----------+-------+--------+-----------------+------------------+--------------+
| 1212223 | 294933 | 1617441709 | 1.jpg | 80199 | 5a6fba36d78b7d95e643a0e70bf79d26 | | 1200 | 900 | 200 | 150 | 1 |
+---------+---------+-------------+----------+-----------+----------------------------------+-----------+-------+--------+-----------------+------------------+--------------+
1 row in set (0,13 sec)
mysql>
We use essential cookies to make this site work, and optional cookies to enhance your experience.