Edgewall Software

Opened 7 years ago

Last modified 2 years ago

#12097 new enhancement

Add a script to contrib for converting MySQL storage engine

Reported by: Ryan J Ollos Owned by:
Priority: normal Milestone: next-stable-1.4.x
Component: database backend Version:
Severity: normal Keywords: mysql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


User in SO:29982115/121694 claims to get an error The current storage engine is MyISAM. It must be InnoDB or NDB storage engine to support transactions after upgrading to Trac 1.0.2. That is what I'd expect after #10993.

I see that we've documented a fix in MySqlDb#Conversion. Would it be feasible to provide a script in contrib for fixing the storage engine and collation? That might help less experienced users.

I'm requesting feedback on whether this is a good idea before trying to create a script.

Attachments (1)

innodb.sql (808 bytes ) - added by figaro 7 years ago.
Native MySQL script to change MyISAM tables to InnoDB tables.

Download all attachments as: .zip

Change History (3)

by figaro, 7 years ago

Attachment: innodb.sql added

Native MySQL script to change MyISAM tables to InnoDB tables.

comment:1 by Ryan J Ollos, 5 years ago

Milestone: next-stable-1.0.xnext-stable-1.2.x

Moved ticket assigned to next-stable-1.0.x since maintenance of 1.0.x is coming to a close. Please move the ticket back if it's critical to fix on 1.0.x.

comment:2 by Ryan J Ollos, 2 years ago

Milestone: next-stable-1.2.xnext-stable-1.4.x

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.