Creating a synonym for a MYSQL-linked server within SQL Server 2008 and above

In a current project it was a requirement to setup synonyms for tables that reside in a MySQL database. This MySQL database was added as “linked server” into SQL Server (via ODBC). If you do this for other SQL Server objects the syntax is like so CREATE SYNONYM app.EX_tbl_foobar FOR [LinkedServerName].[dbname].[schema].[tbl_foobar];CREATE SYNONYM app.EX_tbl_foobar FOR [LinkedServerName].[dbname].[schema].[tbl_foobar]; […]

Fixing TYPOlight-error #145 – Table ‘./tl_search’ is marked as crashed and should be repaired

Today a website of a customer running with TYPOlight stopped working. The friendly “there is an error”-message appeared. Even the administration-backend was not working anymore. Enabling the “display-error” setting revealed that there was a database-problem (perhaps due to a crash of mysql). #145 – TABLE ‘./tl_search’ IS marked AS crashed AND should be repaired#145 – […]