Category: MySQL

Convert MSSQL database to MySQL database

December 22, 2015 by Linux Guru

Filed under Database, MySQL

Last modified June 15, 2016

Convert MSSQL database to MySQL database Some time ago, I had to convert a Microsoft SQL Server database to a MySQL database. The main reason was the cost of the SQL Server license for such a small database. Looking on the web, I found the following open source application: Name: mssql2mysql URL: http://sourceforge.net/projects/mssql2mysql/ Description: mssql2mysql is a python script used to create a SQL dump …

MySQL-fix “table is marked as crashed and should be repaired”

December 17, 2015 by Linux Guru

Filed under MySQL

Last modified June 15, 2016

MySQL-fix “table is marked as crashed and should be repaired” How to fix “table is marked as crashed and should be repaired” ? Power outage or a buggy mysql version could cause this error to appear: Stops any php scripts from running etc.. mysql: Table ‘database/table’ is marked as crashed and should be repaired To fix this, I ran this command via a shell: $ …