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-02 19:57:09
mysql dump specific tables
#note by specifying -p flag without a password it'll prompt you for pass #dump specific files to a SQL file mysqldump -u userHERE -p --lock-tables=false database_name table1 table2 table3 > mydb_tables.sql #if you want to import a file into the data... Add solution -
SQL 2021-10-17 12:43:03
copy database mysql
// if you didnt create the target db, do it: mysql -u your_user -p > CREATE DATABASE the_db_cloned_name; > SHOW DATABASES // then check if it is created and so you're ready to proceed mysqldump -u your_user -p the_db_name > /directory/file_name... Add solution -
Other 2021-10-09 11:36:07
mariadb clone database to another name
// if you didnt create the target db, do it: mysql -u your_user -p > CREATE DATABASE the_db_cloned_name; > SHOW DATABASES // then check if it is created and so you're ready to proceed mysqldump -u your_user -p the_db_name > /directory/file_name... Add solution -
SQL 2021-10-02 19:45:02
mysqldump cli command
mysqldump -u username -p dbname > filename.sql Add solution