1
Create a table to store files, but all the life I send a file above 128mb all the columns are null except the id. I also realized that it saves only pictures, other type of file it doesn’t want to save, like zip file for example.
CREATE TABLE Arquivo (
id int(11) NOT NULL auto_increment,
nome varchar(100) DEFAULT NULL,
binario longblob,
tipo varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
The file really needs to be saved within dB, would you not just save the file in a folder and add the saved path in dB?
– Guilherme Nascimento
It would not, because the server used has a small hard disk limit,and the Mysql server has a much higher limit.
– Pedro Soares
Offtopic: our horrible server, I had a server that disk is "unlimited" and paid well 8 dollars a month, today I use a VPS, but the cost benefit is still great. I hope someone can answer you
– Guilherme Nascimento
I thought the same thing, but I paid $1.50, so not to complain too much, I’m seriously considering paying more for a VPS.
– Pedro Soares