Tag: database

If you want to store Emoji characters in a MySQL DB, you need to update the table encoding. You can…

Gets data from a MySql database, splits the data into separate columns, then uses one column in a URL to download something – and uses other column to name the file thats downloaded

This command will import all the MySQL sql dumps in the current folder. You can use this to restore your…

Backup all files in /var/lib/mysql to another folder To restore, stop mysqld if it is running service stop mysqld Move…

This command can be used to backup MySQL database. mysqldump -u <User> -p <Database name> [<Table name>] > backup.sql This…