Posts Tagged ‘mysql blob’
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
Categories: php
mysql blob, mysql blob cons, mysql store files