New answers tagged mysqldump
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"...
- 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 ...
- 131
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 ...
- 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 ...
- 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 ...
- 423
Top 50 recent answers are included