how can I increase the allowed size of uploaded files in phpmyadmin?

alenguav

Hello,
I need to upload a zip file of 500MB into phpmyadmin but it is configured by default with 100MiB
as maximum, so I was wondering how can I increase that size

alenguav

The original option was (obviously) the command line, but I am receiving the following error message when I try to use the mysql command to restore the sql file
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

twest

alenguav are you logged in root on the server the db is hosted?

cPFence

alenguav The original option was (obviously) the command line, but I am receiving the following error message when I try to use the mysql command to restore the sql file
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

The correct way to restore your SQL file is:

su username
mysql -u db_username -p database_name < your_backup.sql

Isaia-Arknet_PTY_LTD

check if you have not messed up MSQL configs and MYSQL working 🙂

MediaLabz

Just check that it isn't proxied by Cloudflare, which has a 100MB upload limit

cosmoshosting

Don't, restore the the SQL file using SSH.

It will be far faster and more reliable