Hi, How to take full MySQL backup daily using shell script ? First we need to create the shell script on the server and add below code in it. After creating the shell script. After this you can add this shell script to daily crons to perform daily backup automatically. You can directly put […]
Sometimes you may face the error for a mysql driven website. All of sudden a site has started to display this error: Can’t create/write to file ‘#sql_5a0_0.MYD’ (Errcode: 17) Its MySQL error, MySQL is saying the it cannot write to that directory. Its most probably related file exists in that directory. The/tmp is a folder used […]
Grant remote access of MySQL database If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host ‘192.168.1.4’ is not allowed […]
