As Robin said, be sure to make a backup first. You can always install a tool like mysqldumper (my personal favourite) to do it. Yes, the command could be run via the Database Query Form.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
May 29, 2008 9:36am
Subscribe [2]#16 / May 29, 2008 5:47pm
As Robin said, be sure to make a backup first. You can always install a tool like mysqldumper (my personal favourite) to do it. Yes, the command could be run via the Database Query Form.
#17 / May 30, 2008 10:13am
The delete worked, and the problem appears to be solved. Thanks for your help!
#18 / Jun 01, 2008 12:36pm
Hm- hope that gets it squared for you, Scott. Though that other post has me concerned.
OK- Jamie, you still poking this? For you, we need to do a query to create the new fields in exp_weblog_data. NOTE- if there was already data in those fields? We can’t get it back this way. It will just allow new data to be entered.
So- back things up and let me know when you need the queries to alter the exp_weblog_data table.