Opened 3 years ago

Closed 3 years ago

#11887 closed Question/How do I...? (fixed)

Uploading large files to website and database

Reported by: Felicia Mayro Owned by: JaimeV
Priority: Medium Component: Tech
Keywords: Cc:
Sensitive: no

Description

We have several large files, over 2MB, that we would like to add our website and to our database. Is this possible? (Note: Years ago we had received directions for uploading larger files directly to the database but we have misplaced that information.) Thank you!

Change History (15)

comment:1 Changed 3 years ago by JaimeV

Owner: set to JaimeV
Status: newassigned

You can edit your php settings to allow for uploading larger files through directly through your cms or to mysql through phpmyadmin. If you can login to your host vía sftp with your main website user you can edit the php.ini file in the include include/php5 directory.

More details here: https://support.mayfirst.org/wiki/faq/server/change-php-ini-settings

However, I am curious as to what you mean exactly by uploading larger files directly to your database. You certainly would no want to insert large binary files directly into your database but importing a large mysql database dump for the purposes of restoring/recreating/updating a mysql database is reasonable.

comment:2 Changed 3 years ago by Felicia Mayro

We tried to increase the max_upload_filesize as per the instructions, but nothing seems to happen. A test page was made to show which ini file is being used, and what settings drupal sees, should I post that here to you can see it? As for how we use to do the uploads of large files to our mysql database, I am likely describing it incorrectly and it was a long time ago so maybe better to just move forward.

comment:3 Changed 3 years ago by JaimeV

The version of apache looks for a .user.ini file in your document root to load these settings. We automatically place a .user.ini file in your web folder symlinked to your include/php5/php.ini file however I just realized you have a modified document root in your web configuration. I've just added the .user.ini file in your web/drupal6/ folder symlinked to your include/php5/php.ini Does that solve the problem?

comment:4 Changed 3 years ago by Felicia Mayro

For our drupal website, it is solved. Thank you!

For our mysql database, we are still not able to upload the larger files to our "resource" database. Is this perhaps a different ticket I should post?

comment:5 Changed 3 years ago by JaimeV

I'm afraid I don't understand the details. How are you attempting to upload to your database?

comment:6 Changed 3 years ago by Felicia Mayro

Yes, our database houses pdf files.

comment:7 Changed 3 years ago by JaimeV

How are you attempting to upload the files? Is this through your drupal interface?

comment:8 Changed 3 years ago by JaimeV

Resolution: wontfix
Status: assignedfeedback

comment:9 Changed 3 years ago by Felicia Mayro

Resolution: wontfix
Status: feedbackassigned

Sorry for the long silence.

We upload through the mysql database. Should I try a screen shot?

comment:10 Changed 3 years ago by JaimeV

Yes please , sorry it is still not clear to me.

comment:11 Changed 3 years ago by Felicia Mayro

http://neighborhoodpreservationcenter.org/sites/default/files/ResourceDatabase.JPG

comment:12 Changed 3 years ago by JaimeV

Ok, now I understand. You are using the basebuilder app correct? It looks like we needed to add another symlink to the php.ini settings in the db folder. Can you try again now?

comment:13 Changed 3 years ago by Felicia Mayro

Yes! Success! Able to upload the larger files, but a couple (not many) over 20MB are not able to be uploaded. Is that a cut off?

comment:14 Changed 3 years ago by JaimeV

​I see you have set your max size to 22MB. You can keep adjusting using these instructions.

https://support.mayfirst.org/wiki/faq/server/change-php-ini-settings

Now both your drupal site and the basebuilder app should inherit those settings.

comment:15 Changed 3 years ago by Felicia Mayro

Resolution: fixed
Status: assignedclosed

We got it! Done! THANK YOU SO VERY MUCH!

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.