On Jan 20, 2020, at 16:41, Peter Claes <[email protected]> wrote:
> So now I decided to go for the root cause of this. My guess would be the
> database.
>
> I ran some checks (See Below) and it turns out some tables are still in
> innoDB.
>
> If so, would this command suit my needs :
>
> SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,'
> ENGINE=MyISAM;')
> FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'DBNAME' AND ENGINE =
> 'InnoDB' AND TABLE_TYPE = 'BASE TABLE'
>
> Of course i will take a back-up of the DB before trying anything.
If you look in the ‘scripts/‘ directory in the Rivendell source tree, you’ll
find a Python script called ‘engine_conv.py’ that does precisely what you’re
trying to do. Just run it like this:
engine_conv.py MyISAM
And YES, make a DB backup before doing ANYTHING like this.
Cheers!
|---------------------------------------------------------------------|
| Frederick F. Gleason, Jr. | Chief Developer |
| | Paravel Systems |
|---------------------------------------------------------------------|
| A room without books is like a body without a soul. |
| |
| -- Cicero |
|---------------------------------------------------------------------|
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
