Tag: mysql

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

Install LAMP Stack on Ubuntu/Debian using apt-get sudo apt-get install openssh-server openssh-client apache2 libapache2-mod-php5 php5-cli php5-common php5-cgi mysql-client mysql-common mysql-server…

Print out the result of an SQL query directly from the database using the mysql command mysql -u root Project_Tiker…

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

A perl script to stop crond if mysqld is down #!/usr/bin/perl # See if MySQL server is alive or not…

You can connect to a remote mysql server if you have the necessary permissions… mysql -h mysql.remote.com -u user

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

MySQL ./configure –prefix=/usr/local/mysql –localstatedir=/var/lib/mysql –with-mysqld-user=mysql –with-unix-socket-path=/tmp/mysql.sock –without-comment –without-debug –without-bench make make install cp support-files/my-medium.cnf /etc/my.cnf chown root:sys /etc/my.cnf chmod 644…

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