New answers tagged

1 vote

Stuck at importing data directly from the staging machine to the development machine in MySQL/MariaDB

From the source machine: mysqldump ... | mysql -h dest ... Or, from the destination machine: mysqldump -h source ... | mysql ... Either tool (mysql or any dumper) can reach into the "other"...
user avatar
  • 69.4k
3 votes

mysql to mariadb: unknown collation utf8mb4_0900_ai_ci

First, I can't comment on the errors you are getting when defining views as you haven't shown the statements you're trying to use to create them. In short, in MariaDB use utf8mb4_unicode_520_ci ...
user avatar
0 votes
Accepted

mysqldump won't accept combination of --socket, --all-databses, --user, --password

Use --user=$user --password=$password as shown in the help for mysqldump. You may also include the user name and password in the INI file in the [mysqldump] section to avoid using it on the command ...
user avatar
  • 383
0 votes

Understanding slow queries from mysqldumpslow

SELECT /*!40001 SQL_NO_CACHE */ * FROM `audits looks like a query from mysqldump. Increase the global timeout -- so that it won't crash. Meanwhile, you may not have any complete dumps for the last ...
user avatar
  • 69.4k
1 vote

Best practices for backing up a MySQL DB

Universal practices that are applied to all DBMS, including MySQL 3-2-1 rule. The Cybersecurity and Infrastructure Security Agency recommend that you: Keep 3 copies of any important file: 1 ...
user avatar
  • 423

Top 50 recent answers are included