Mysql Longblob only accepts file up to 128mb

Asked

Viewed 215 times

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?

  • It would not, because the server used has a small hard disk limit,and the Mysql server has a much higher limit.

  • 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

  • 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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.