Rob, 1. I get into MYSQL no problem, prompt, etc. with mysql- u -p mysql Rivendell.
2. I have a sql backup already from last week. 3. How do I rename the database (then run rdadmin)? I'm a bit confused with that step. Rename the db in mysql or elsewhere? -Terry On Wed, Dec 7, 2011 at 11:40 AM, Rob Landry <[email protected]> wrote: > > > On Wed, 7 Dec 2011, Terry LeTourneau wrote: > > > When I run RDAdmin from the terminal, this is the error I get: > > root@RFM-01420:/home/renewfm# rdadmin > > Session management error: None of the authentication protocols specified > are > > supported > > What happens if you type: mysql -uroot -pwhatever Rivendell > > (substituting your MySQL root password for "whatever")? > > > SQL: alter table VERSION add column LAST_ISCI_XREFERENCE datetime default > > "1970-01-01 00:00:00" after LAST_MAINT_DATETIME > > SQL Error: Duplicate column name 'LAST_ISCI_XREFERENCE' > > In your shoes, I would shut down the Rivendell daemons and use mysqldump > to make a .sql file of your database, then rename the database and run > rdadmin. That should force it to create a new, empty, database. I would > then compare that, table by table, to your database, noting all the > differences, and verrify that the two databases have identical structures. > > If they do, there's probably something in one of the tables that > identifies the schema. I'd look for that and compare the value in the two > databases. They should of course be the same. You might need to make > manual alterations to your database if it has a different structure than > the empty one (i.e. missing columns, different field types, etc.). After > doing so, delete the empty database, rename yours to Rivendell, and try > rdadmin again. > > Because you've got the .sql file you created with myseqldump, it should be > easy to get back to where you are now if you mess up. > > If Fred Gleason should happen to materialize, he probably knows a much > better way to address your problem than the one I've outlined above. > > > Rob > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
