Community

Database Not Uploaded

DK
DIlip Kr Sarma #1

Website setup with php 7.3 and post_max_size = 800M also setup but not able to upload the database of 26mb

Always display

500

Internal Server Error

need support to host the new site

ML
Muhammad Laraib Yameen #3

Changing default settings of PHP works for your website but not for phpMyAdmin which is why you’re still unable to upload database. there is a way to increase upload size for phpMyAdmin. But, I suggest you upload .sql file in root directory of your website and use shell to upload your database like this:

sudo mysql -u database_username -p database_name < /home/domain.tld/database_file.sql

Example: sudo mysql -u mysite_db -p mysite_db < /home/mysite.com/sql_backup2022.sql

when you enter this command it will ask for a password, enter password of same database user you put in the command.

Sign in to reply