重启MySQL的正确方法

如果你是从源码包安装的Mysql,那么系统中是没有红帽常用的servcie这个脚本的,

所以只好手工重启

有人建议Killall mysql。这种野蛮的方法其实是不行的,强制终止的话,可能会造成表损坏,损失是巨大的。

这里推荐安全的重启方法

$mysql_dir/bin/mysqladmin -u root -p shutdown
$mysql_dir/bin/safe_mysqld & 

mysqladmin和mysqld_safe位于Mysql安装目录的bin目录下,很容易找到的。

/usr/bin/mysqladmin -u root -p shutdown

Last modified onSaturday, 05 January 2013 13:03

( ! ) Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169
Call Stack
#TimeMemoryFunctionLocation
10.0011403864{main}( ).../index.php:0
20.17911321616Joomla\CMS\Application\SiteApplication->execute( ).../index.php:49
30.17911321616Joomla\CMS\Application\SiteApplication->doExecute( ).../CMSApplication.php:196
40.54112979928Joomla\CMS\Application\SiteApplication->dispatch( ).../SiteApplication.php:233
50.54203004448Joomla\CMS\Component\ComponentHelper::renderComponent( ).../SiteApplication.php:194
60.54413059776Joomla\CMS\Component\ComponentHelper::executeComponent( ).../ComponentHelper.php:377
70.54463076832require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ).../ComponentHelper.php:402
80.55643220920K2ControllerItem->execute( ).../k2.php:64
90.55643220920K2ControllerItem->display( ).../BaseController.php:710
100.56843490000K2ControllerItem->display( ).../item.php:78
110.56843490000K2ControllerItem->display( ).../controller.php:19
120.57123508520Joomla\CMS\Cache\Controller\ViewController->get( ).../BaseController.php:663
130.57593528936K2ViewItem->display( ).../ViewController.php:102
140.66254076304K2ViewItem->display( ).../view.html.php:742
150.66254076304K2ViewItem->loadTemplate( ).../HtmlView.php:230
160.66754250704include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ).../HtmlView.php:701
  • Published in MYSQL
  • Read 3300 times

( ! ) Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478
Call Stack
#TimeMemoryFunctionLocation
10.0011403864{main}( ).../index.php:0
20.17911321616Joomla\CMS\Application\SiteApplication->execute( ).../index.php:49
30.17911321616Joomla\CMS\Application\SiteApplication->doExecute( ).../CMSApplication.php:196
40.54112979928Joomla\CMS\Application\SiteApplication->dispatch( ).../SiteApplication.php:233
50.54203004448Joomla\CMS\Component\ComponentHelper::renderComponent( ).../SiteApplication.php:194
60.54413059776Joomla\CMS\Component\ComponentHelper::executeComponent( ).../ComponentHelper.php:377
70.54463076832require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ).../ComponentHelper.php:402
80.55643220920K2ControllerItem->execute( ).../k2.php:64
90.55643220920K2ControllerItem->display( ).../BaseController.php:710
100.56843490000K2ControllerItem->display( ).../item.php:78
110.56843490000K2ControllerItem->display( ).../controller.php:19
120.57123508520Joomla\CMS\Cache\Controller\ViewController->get( ).../BaseController.php:663
130.57593528936K2ViewItem->display( ).../ViewController.php:102
140.66254076304K2ViewItem->display( ).../view.html.php:742
150.66254076304K2ViewItem->loadTemplate( ).../HtmlView.php:230
160.66754250704include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ).../HtmlView.php:701
back to top