Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
The Britain Posted July 30, 2022 Posted July 30, 2022 We have a database with a bunch of entries, around 1300. I need to change the owner of all of those entries to another owner. How do I run a query against this database to easily do this? Is there a query window or terminal? What should the statement/code/format look like and where should I set this one-shot up? Thank you for any guidance.
Kjell Iver Johansen Posted July 30, 2022 Posted July 30, 2022 If you’re on a previous version and not the very latest you’ll have the sql toolbox in acp. This nice feature was removed on the latest release 4.7.0. The Britain 1
Miss_B Posted July 30, 2022 Posted July 30, 2022 7 hours ago, The Britain said: We have a database with a bunch of entries, around 1300. I need to change the owner of all of those entries to another owner. How do I run a query against this database to easily do this? Is there a query window or terminal? What should the statement/code/format look like and where should I set this one-shot up? Thank you for any guidance. A word of advice if I may, make first a backup of the dataabase before you run any queries. The best place to run queries would be at the SQL Tab for the forum 's database at phpmyadmin.
The Britain Posted July 30, 2022 Author Posted July 30, 2022 1 hour ago, Miss_B said: A word of advice if I may, make first a backup of the dataabase before you run any queries. The best place to run queries would be at the SQL Tab for the forum 's database at phpmyadmin. Definitely, I do several backups a day. Ideally I don’t want to install PHPMyAdmin on my VPS. Is there a way to craft the query in IPB? 5 hours ago, Kjell Iver Johansen said: If you’re on a previous version and not the very latest you’ll have the sql toolbox in acp. This nice feature was removed on the latest release 4.7.0. I wasn’t aware of this tool I’ll check it out. Thank you.
The Britain Posted July 30, 2022 Author Posted July 30, 2022 (edited) @Kjell Iver Johansen I found the tool you referenced and this will save a lot of time. I'm not sure why they would remove something this useful from the software but I'm sure there was a good reason. Luckily I haven't updated yet. For anyone else stumbling on this, it's under "Get Support" in the ACP and then "SQL Toolbox" on the right. Edited July 30, 2022 by The Britain
Randy Calvert Posted July 30, 2022 Posted July 30, 2022 A nice alternative to phpMyAdmin is Adminer. It’s a single file upload as well. https://www.adminer.org
Recommended Posts