“ERROR 1148. The used command is not allowed with this MySQL/MariaDB version” when doing LOAD DATA LOCAL FILE with MySQL Workbench. Solution: In the advanced tab of the connection, put OPT_LOCAL_INFILE=1 in the others box.
There is a utility program called "automysqlbackup" that is available in the Ubuntu repositories. This utility can be scheduled to automatically perform backups at regular intervals. To install this program, type the following into the terminal: sudo apt-get install automysqlbackup…
https://docs.phpmyadmin.net/en/latest/setup.html#setup_script
How to import data from csv, txt or other export files into MYSQL Syntax: LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [PARTITION (partition_name,...)] [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY]…
http://stackoverflow.com/questions/18236838/explain-htaccess-rules
Make sure you backup your mysql databases first! sudo apt-get remove mysql-server sudo apt-get autoremove sudo apt-get install mysql-client-5.6 mysql-client-core-5.6 sudo apt-get install mysql-server-5.6 reference: askubuntu.com
https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/
MySQLTuner-perl MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format…
STEP 01) Change the following in /etc/my.cnf [mysqld] innodb_log_buffer_size = 32M innodb_buffer_pool_size = 2G innodb_log_file_size = 768M STEP 02) SET GLOBAL innodb_fast_shutdown = 0; to force InnoDB to completely purge transactional changes from all of InnoDB moving parts, including the transactional logs (ib_logfile0,…
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu
GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.webhost.net' IDENTIFIED BY 'root-password-here';