One of my friends asked some asp developer to make online application where user can upload files also. jpg, doc, pdf and all these files are saved in SQL database as flat file. Now, my friend asked me to do everything in PHP and he want to migrate all the data which he has in SQL database to MySQL database. I can do it. text can be migrated easily but the files which are saved in SQL database can be migrated to MySQL as flat files. Is it possible?
Mysql – How to migrate data from SQL database to MySQL including flat files
MySQL
Related Question
- Mysql – Images, PDF, audio and video files in MySQL
- MySQL – Creating Database Without .sql File
- MySQL – Cannot Access Database After Moving Files in Data Directory
- SQL Server to MySQL – Migrating Backup for a WordPress Site
- PostgreSQL to MySQL Migration for WordPress Site – How To’s
- Sql-server – Problems during migration from SQL Server to MySQL via MySQL Workbench
- Mysql – How does MySQL store data, can I detach a thesql Database
Best Answer
According to this you should be able to store files in a blob or text field. I don't actually work with mysql so I googled "mysql datatypes".