recentpopularlog in

therobyouknow : restart   18

How to reload/restart php7.0-fpm / php5.0-fpm service – nixCraft
for php 5.6:
- sudo service php5.6-fpm restart
- sudo service apache2 restart

(needed after adjusting xdebug settings, e.g. xdebug.remote_autostart=1 )
php  restart  fpm  web  dev  computing  cms  howto  5.6  php5.6  php7.0  process  service  command 
august 2017 by therobyouknow
How Do I Restart MySQL Server?
Needed if you have changed my.cnf to pick-up/re-read changes
admin  centos  command  commandline  database  howto  linux  mysqld  mysql  restart  server  start  tutorial  my.cnf  computing  work 
july 2010 by therobyouknow
how to change Mysql packet size? - Server Fault
On linux, well CentOS at least, you would edit /etc/my.cnf and add the same text as randy melder says.

You would then need to restart the MySQL server (mysqld) as otherwise it won't know about your change since it only reads it when it starts up.

To restart mysqld: /etc/init.d/mysqld restart

Why would you want to increase your packet size? If you want to import a large file: mysql -u username -p -h localhost databasename < data.sql

With that default setting you might not be able to do the import and you would therefore be presented with the error message: "ERROR 1153 (08S01) at line 53: Got a packet bigger than 'max_allowed_packet' bytes".

So setting max_allowed_packet as described in the answer above can cure that problem, provided your setting is larger than the file you want to import.
mysql  packet  size  change  import  mysqldump  enable  large  error  solution  my.cnf  mysqld  restart  re-read  howto  max_allowed_packet  computing  setting  configuration  dos  denial  service  file  sql  plaintext  export 
july 2010 by therobyouknow

Copy this bookmark:





to read