The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Mysql Setting - how do I change it??
Hi
I'm pretty sure that this has been asked already but done a search and couldn't find anything in the forums. I have a max_allowed_packets error when uploading attachments. I have googled my heart out trying to find out how to change this. When I follow the directions given it doesn't work. I SSH onto my server and type a mysql command - tried this but it came back with an authentication error despite using the root login. I change the my.cnf file in the /etc folder manually by editing it in notepad++ - which is something else suggested but there is no setting in that file for max packet upload. I am not technical but I do need to change this setting myself, can someone give me an idiot proof way of doing this please? Help would be very much appreciated |
#2
|
||||
|
||||
If it wasn't in the my.cnf file, then you just need to add it like this:
Code:
max_allowed_packet = 64M (Change 64M to what you want.) You need to restart mysql after you do the change. |
#3
|
||||
|
||||
Quote:
Use nano or pico to edit the files, and make sure to back them up first before making changes. Code:
cp my.cnf my.cnf.bak Code:
cp my.cnf.bak my.cnf Lynne gave the correct code for changing the setting you need to change so good luck. |
#4
|
|||
|
|||
Thanks for the help guys, my.cnf file did read:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid It now reads: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_allowed_packet = 1028M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid is this ok? |
#5
|
||||
|
||||
That is the correct format for adding in the max_allowed_packet setting.
|
#6
|
|||
|
|||
1028 MB might be too much.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|