Re: [Trac] Converting from sqlite to mariadb/mysql

Hi,

On Fri, Feb 6, 2026 at 10:37=E2=80=AFAM Bruce Dubbs <[email protected]>=
 wrote:
>
> At the linuxfromscratch project we have been using Trac for a very long t=
ime.  The last time we updated Trac was in 2021 using the latest developmen=
t system at that time.  Over the years our sqlite databases have grown quit=
e large: 287M, 884M, and 642M respectively.
>
> We have noticed some response problems and want to update to the latest T=
rac and convert to mariadb.
>
> Doing some testing on a test server we installed python3.13, Trac-1.6, Py=
MySQL, and mariadb-11.8.5. We then copied a current trac.db to the test sys=
tem and ran sqlite3mysql to copy the trac.db into mariadb.
>
> We can log into mariadb with  'mariadb -u tracuser -p trac_db' and all lo=
oks good.  We do have a symlink  /usr/bin/mysql -> mariadb
>
> We then edited the  trac.ini file to read:
>
> #[sqlite]
> #extensions =3D
> ...
> [trac]
> ...
> #database =3D sqlite:db/trac.db
> #database =3D mysql://tracuser:password/trac_db?unix_socket=3D/run/mariad=
b/
>     mariadb.sock
> database =3D mysql://tracuser:password@localhost/trac_db
>
> but no matter what we try after restarting apache get the error message:
>
> TracError: Unable to check for upgrade of trac.db.api.DatabaseManager: Tr=
acError: Unsupported database type "mysql"
>
> What are we missing?

I'd suggest to check errors in trac.log. The pymysql library is
required for MySQL but it is unavailable in your environment.

See also: https://trac.edgewall.org/wiki/SqLiteToMySql

--=20
Jun Omae <[email protected]> (=E5=A4=A7=E5=89=8D =E6=BD=A4)

--=20
You received this message because you are subscribed to the Google Groups "=
Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to trac-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected]
To view this discussion visit https://groups.google.com/d/msgid/trac-users/=
CAEVLMagfr%3DjuR3WLixobDB9A4RXRy6gRjRRXo%3DHADU31T7FRTQ%40mail.gmail.com.