Hot answers tagged mysql
Using GNU date : $ date -d '2015-09-26 +30 days' '+%Y-%m-%d' 2015-10-26
On CentOS 6.6 you can check if mysql-server is installed with: rpm -qi mysql-server And you can install it with: yum install mysql-server or reinstall it: yum reinstall mysql-server
sudo probably asks for a password and nohup disconnects the process from the controlling terminal. Use that instead: sudo sh -c 'nohup mysql -hlocalhost -P3306 -uxxxxxx -pxxxxxx < /var/lib/mysql/backups/dump.sql &'
Swap is needed for: Hibernation, and to swap out memory from RAM to avoid RAM exhaustion. So if you have enough RAM to keep your working set, then you will only need swap for hibernation. If your working set is very big then swap may be needed. However whether swap is a good idea will depend on the work pattern. Some patterns will cause swap thrash, others ...
First, switch to root with sudo -i Then, nohup sh -c 'mysql -hlocalhost -P3306 -uxxxxxx -pxxxxxx < /var/lib/mysql/backups/dump.sql' &
I 'may' have solved this by leaving out the &, and then running nohup . . ., then pressing ctrl-z, then exiting from putty. So far the MySQL connection appears to be still running
This is more a find "start/running" or something similar which is better formatted as if (system("service mysql status") =~ /start\/running/) Next thing is that you will match the return code of the system command instead of the output. Use backticks (`) instead: if (`service mysql status` =~ /start\/running/) There is no not in this condition as you ...
Only top voted, non community-wiki answers of a minimum length are eligible