Tag Info

New answers tagged

9

Using GNU date : $ date -d '2015-09-26 +30 days' '+%Y-%m-%d' 2015-10-26


0

Yet another solution is to update packages. Todo on fresh centos installation (mysql is not installed yet): yum check-update yum update yum install mysql mysql-server


1

First, switch to root with sudo -i Then, nohup sh -c 'mysql -hlocalhost -P3306 -uxxxxxx -pxxxxxx < /var/lib/mysql/backups/dump.sql' &


3

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 &'


1

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


0

Is that the same source you are executing make uninstall where you previously did make install on that?. If it is the same source then make uninstall should just work as it is. If it is not the same source(If you took a fresh source again), then install it to the same path where you previously installed and then try to uninstall it. If you still get the same ...


0

Found the solution you just have to run this command : sudo mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/ source : Archlinux forums


0

Find the following line in your php.ini: ;extension=php_mysql.so Remove the semicolon, which is serving as a comment, then restart apache. If that doesn't work, report back... This has been transcribed from StackOverFlow


0

You need to redirect stderr to get the log output when using -v. You need to do something like: mysql -v mydb u- alex -p**** < please_run_me.sql 2>&1 > /tmp/file.log The 2>&1 redirects stderr to stdout, which you then redirect to /tmp/file.log. Remember that > will overwrite /tmp/file.log - use >> if you'd like to append to ...


0

I actually have the exact same processes running. What I did was this... sudo service mysql stop Then i found the pid for the rogue mysql processes and killed it... sudo kill 2650 Now I dont have any mysql processes running. So I started it up again... sudo service mysql start Now I have the 2 mysql processes that should be running. 1744 ? ...


0

In one window do - tail -f /var/log/syslog In another window do - service mysql stop If mysql is still running do pkill mysqld till it's really dead. Then do - service mysql start Post syslog entries. Also post output of the following, so exact software versions are shown. lsb_release -a dpkg -l | egrep 'mysql|mariadb'


2

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 ...


4

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


0

Sure, but this kind of thing is a bit easier to do if you plan a bit up front. Changes When you create a database migration (think schema change) you need to create a sql statement that will encapsulate the change. If you are adding a column to an existing table with data in it you should be able to create the sql statement that describes the change. For ...


0

MySQL isnt avaialble for Tiny Core, but mariadb v10.0.19 is. Mariadb is a drop-in replacement for MySQL. ClamAV isn't in the TC repository, so isn't currently available. The Apt-get and YUM package managers are for entirely different distributions and therefore not usable with TC. The TC command line app browser (tce-ab) can install mariadb in on-demand ...


1

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 ...


0

Oh, I investigated almost whole day and found solution - problem was in SELinux. If it is powered off - mariadb starts successfully. So, I just needed to configure it, and I did it!


0

I forgot to update this thread. Found the solution same day by using following mysql -u$SQLUSER -p$SQLPASS -e "use $DB; select creationdate,login,package,expirydate,mobile from users WHERE creationdate >= NOW() - INTERVAL 5 MINUTE;"



Top 50 recent answers are included