On Thu, 12 Jan 2012 17:53:03 +1100, Jesse Stevens <noodlepringle@gmail.com> wrote:
I've been using phpmyadmin to browse the tables and check out the structure as I'm really not that much of a MySQL admin, so does anyone know what I could use to change the contents of every single entry for "robot_subscriber" in the table "subscriber_table" in the database "sympa" ?
$ mysql sympa mysql> UPDATE substriber_table SET robot_subscriber=FOO;
Also this raises another question - why is grabbing a subscriber list so difficult? To me it would be a vital thing to be able to dump this list in whatever format you'd like for easy backups and fail safe restoration. Sometimes these lists can be thousands of entries!
worst case scenario... check out SELECT INTO OUTFILE -- Stewart Smith