If you have forget the mysql root password and you are not able to access your mysql service then you need to reset the password of mysql root user by using following steps Ans : 1)root@server /etc/init.d/mysqld stop 2) Start...
Category: mysql
upgrade mysql version on linux server
You can upgrade your mysql version from 5.0 to 5.5 by using following steps 1. Enable remi repository for yum wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm sudo rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm 2. Run mysqldump to export data out from MySQL 5.0 mysqldump...
daily mysql databases backup on cpanel server
Question: How to back up MySQL databases using cron jobs on cpanel server ? Ans: You can take the mysql backup of all databases for last 10 days and keep on the server. You need to add the cron to create...
Script to automatically start mysql
The following script is used to start mysql automatically when it is failed or stopped on the server. You can set 2 min cron "*/2 * * * * /bin/sh /root/automysqlstart.sh" and it restart the mysql automatically. ============================ #!/bin/bash #Checking whether MySQL...