Problem with uploading to database
Posted: Tue Jan 13, 2009 9:00 am
Hello,
I am facing this problem while uploading a big file to my database.
The problem i am facing is that when i upload a big file like more than 1 MB.. it does not upload the file and shows the following error.
"Failed to execute SQL. Error: MySQL server has gone away"
This is my table structure
what should i do?
please solve my problem..
thanks and regards,
Anshu
I am facing this problem while uploading a big file to my database.
The problem i am facing is that when i upload a big file like more than 1 MB.. it does not upload the file and shows the following error.
"Failed to execute SQL. Error: MySQL server has gone away"
This is my table structure
Code: Select all
CREATE TABLE tbl_Files (
id_files tinyint(3) unsigned NOT NULL auto_increment,
bin_data longblob NOT NULL, <<< this is where the files gets uploaded
description tinytext NOT NULL,
user_name varchar(50) NOT NULL,
subuser_name varchar(50) NOT NULL,
PRIMARY KEY (id_files)
);please solve my problem..
thanks and regards,
Anshu