-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 On Saturday 12 July 2003 11:10, Tim Legant wrote: > Robin Lynn Frank <[EMAIL PROTECTED]> writes: > > Here comes the hard part. I know nothing about MySQL. Is there some > > kind of howto that would understandable by the clinically brain-dead, > > like me? I looked at the documentation on the tmda site and it doesn't > > look too difficult. > > The tutorial at > > http://www.mysql.com/doc/en/Tutorial.html > > looks decent, particularly with regard to creating databases and > tables. For a "gentle introduction to SQL", see > > http://sqlzoo.net/ > > Note: I've not read either of these. I just Googled and glanced > through the list for something relevant. > > I recommend that you get comfortable with MySQL administration and SQL > syntax this week and wait for TMDA 0.81 to be released. With 0.81 > comes SQL support for any SQL database with a Python DB API 2.0 > module, using the {from,to}-sql rules in the filters. With the new > rules, the schema of your database is not restricted, i.e., your > columns don't have to be called 'ADDRESS' and 'ACTION' and you don't > need to have a table for each user. > > Also, there are two new configuration variables, DB_BARE_APPEND and > DB_CONFIRM_APPEND, that can be set to a SQL INSERT statement to update > your database just like BARE_APPEND and CONFIRM_APPEND update local > text files. > > > Tim
Okay, saw Terminator 3 to clear my mind (what a blast). Thru a combination of webmin, and command line, I got the database and table created and some data added to test with. Now I will go play with my incoming filter and see if plays nice. To those folks who recommended phpmyadmin, the only reason I haven't gone that route yet is there would just be too much stuff to add on the machine we are currently working on. - -- Robin Lynn Frank | Director of Operations | Paradigm-Omega, LLC � 2003 Paradigm-Omega, LLC. All rights reserved. Unauthorized reproduction or dissemination is prohibited. If the PGP signature is missing, please forward it to [EMAIL PROTECTED] Incoming mail with S/MIME or detatched PGP Signatures will be considered unsigned. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/EH7kmq9pLlRaCV8RA7PkAKCRa97CKXlsPYi/Qovk+kQ0Yrwb0QCfYZ7a SyDBXNMgdqVJQx8IUhFyPT8= =ax/d -----END PGP SIGNATURE----- _____________________________________________ tmda-users mailing list ([EMAIL PROTECTED]) http://tmda.net/lists/listinfo/tmda-users
