![]() My ignorance is a large risk with either scenario, but is it true to say that conducting any database changes via Ruby will be safer than attempting the same changes using pg Admin4? How ever you do it, make sure you make frequent backups.Ī valid point - I will try hard to find other ways in the first instance. My benchmark for “Better” is “much less likely to leave your database in a broken state and completely broken.” Since you’re a “noob” you don’t know which tables need to be updated when you do. In such an environment, the odds of catastrophic problems when manipulating databases do seem high! Linux and Ruby both seem to be written by sadists, for masochists, both being astonishingly fragile and arcane. I wasted a week fruitlessly attempting this import myself but just could not achieve a dev environment with all prerequisites in place that would allow me to do so from either a Windows 10 instance of Ubuntu or a DigitalOcean based instance, based on the official guide for use of the MyBB import script.Īfter painfully thrashing around, solving one error message after the next, I finally struck an absolute brick wall either way when it came to getting the SQL database to be accessible when executing the final ruby on rails command that would initiate the import. Also hopefully parsing the M圜ode in some MyBB posts properly (right now the formatting codes are visible) Right now the site on the domain is essentially a clean slate placeholder while a freelancer is fine tuning the import process from old forums (tweaking the import script for MyBB in particular, so that hopefully the custom user profile fields I had set up there will import along with users and their posts. I might be able to crowd source a partial solution if I can convince some users to manually scan for and mark topics for deletion. Much of what you need is likely to be in topics already because other sites strike the same sort of problems.So you’ll just be copying someone else’s hard won knowledge. They can then advise you about the easiest and safest way to update the database. You are more likely to get a correct answer from the team and other experts if they can understand your data and what you are trying to achieve. Using Data Explorer will give you query results which are real data examples and quantifiable numbers of records. That can create a time bomb because some data corruption might not be identified in a timely manner. I’d rather run the risk of bad data on display than risk damaging the database by manually modifying it. The final option is likely to be the command-line and scripts next to modify your database. The queries you generate to identify the problem records are only a step away from SQL to modify the database. Not being able to make changes is a safety net because a few years ago there were a lot of users wrecking their data with precipitate updates. Later it will help you with reporting but it is not absolutely necessary. The Date Explorer plug-in will be useful for you so it is the next step to a better understanding of the database and to identify what might need to be done. So, how many of these automated email notifications have been converted to topics? Simply getting your forum going properly is more important than solving every data error. ![]() If they are irrelevant then they will, as designed, drop out of any prominence in Discourse as more relevant topics are created. So you might not go any further.įor example, your old email notifications might not be a big issue. ![]() ![]() You might find that you can do 99% of what you need without going any further. Get up to speed with what you need to use in Discourse. The Discourse GUI with the features that you will need to master anyway. It can be incredibly powerful when used as designed. There’s a high cost to mastering anything more than the first level which is just using Discourse itself. Given your limited time and experience I’d suggest starting with the simplest and easiest to use tools first and only moving onto the next level if you are forced. I’m in Wellington, by the way, setting up and actively using a couple of private forums for charities. I saw your domain name and checked you out first time so I somewhat understand your situation.
0 Comments
Leave a Reply. |