Have just attempted a reinstall of XF, in order to attempt fixing CPU usage issues (earlier install was the product of several install/overwrite cycles, so felt like trying to reproduce on a clean version). Process followed was: back up database, according to instructions here. Back up forum, simply by moving the install directory away from the httpd's watch path. Install XF according to the instructions provided in the docs, letting it delete the old database. After install, restore database from backup. At the end of this process, I realized that the database backup had been truncated near the end. The backup contains the entire table 'xf_user' but cuts off near the beginning of the table 'xf_user_alert'. The backup mostly restores correctly, and I can verify the presence of all the appropriate tables and rows (before xf_user_alert) via phpMyAdmin. However, with this backup I cannot log in as an admin, which seems as if it would necessarily be the first step of any recovery. In retrospect I should have run the install to a new database and let the old one remain. Failing this, however, is there a way of recovering from the partial backup? It seems pretty clear that all the relevant data is present, of posts, threads and users anyway.