SMF Support > vBulletin

Converting VBulletin 3.8?

<< < (2/2)

Antes:

--- Quote ---You probably have to change it for both the client (you are running to do the import) AND the daemon mysqld that is running and accepting the import.

For the client, you can specify it on the command line:


--- Code: ---mysql --max_allowed_packet=100M -u root -p database < dump.sql
--- End code ---
Also, change the my.cnf or my.ini file under the mysqld section and set max_allowed_packet=100M or you could run these commands in a mysql console connected to that same server:


--- Code: ---set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
--- End code ---

--- End quote ---

maybe this helps quoted from someone.

Dan2331:
Increase your mysql memory size, that helps...if you dont have access to ssh, you can ask your host to do that.

Navigation

[0] Message Index

[*] Previous page