What do you want to save?
Add Code snippet
New code examples
-
Other 2021-11-08 08:31:08
ERROR 1273 (HY000) at line 1116: Unknown collation: 'utf8mb4_0900_ai_ci'
MYSQL import issues Error: ERROR 1273 (HY000) at line 1116: Unknown collation: 'utf8mb4_0900_ai_ci' 1. Export DB: mysqldump -u root -p DB_NAME > 18_06_21.sql sed -i 's/utf8mb4/utf8/g' 18_06_21.sql sed -i 's/utf8_unicode_ci/utf8_general_ci/g' 18_06_21... Add solution -
SQL 2021-11-08 05:37:17
back up stored procedures mysql
# Stored Procedures Plus Everything mysqldump -R <dbname> #or mysqldump --routines <dbname> #Stored Procedures only mysqldump -n -t -d -R <dbname> #or mysqldump --no-create-db --no-create-info --no-data --routines <dbname> Add solution -
Other 2021-11-03 04:27:20
syntax error: unterminated quoted string
The line with DROPBOX="/root/Dropbox/Backups does not have a " at the end. The MYSQL, MYSQLDUMP and GZIP variables refer to the programs used to execute various commands. So they should contain the path of those programs: MYSQL="/usr/bin... Add solution
Best helpers
Grin
+5
Hwsolutions
+5
SYJ
+5
A. Pelicker
+5
KMC
+5
Jonjie
+5
Blank
+5
Paul Knight
+5
WYSIWYG
+5
Required
+5
Saylestyler
+5
Deverejones
+5
Frank Jaeger
+5