Archive for October, 2014

Cons of Storing Files In Mysql

October 21, 2014 Leave a comment

Actually this is a terrible idea in real world scenario and the reason is:

if you need to recover your database and/or copy to another server from a backup sql file, you can not import the sql file into mysql.

Tested with different mysql and mariadb versions on different linux platforms.

Every time i try to import the sql file mysql crashes. Only way to recover your database is removing table data which includes files (blob column) from your sql file.

Of course you have another option to backup and recover your data. Copy actual database/tables (/var/lib/mysql/) to the new server and run:

[root@mk ~]# mysql_upgrade