Tag: MySQL

mysql create utf8 database This is the way to create a mysql database with UTF8 characterset CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
Backup mysql databases into separate files This bach script makes separate backup files of all the databases in mysql and saves the result in the mysql_backup folder. #!/bin/bash -v USERNAME='yourusername'...
Script to backup MySql database #!/bin/bash # Shell script to backup MySql database # To backup Nysql databases file to /backup dir and later pick up by your # script. You can skip few databases from backup...
MySQL Not Listening On A Public IP By default, MySQL (on Debian) doesn’t listen on the public interface: #netstat -l tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1768/mysqld In /etc/mysql/my.cnf, comment out the...