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
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)
alenguav are you logged in root on the server the db is hosted?
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
check if you have not messed up MSQL configs and MYSQL working 🙂
Just check that it isn't proxied by Cloudflare, which has a 100MB upload limit
Don't, restore the the SQL file using SSH.
It will be far faster and more reliable