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"...
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 ...
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 ...
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 ...
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 ...
Top 50 recent answers are included
Related Tags
mysqldump × 725mysql × 643
backup × 224
innodb × 65
mariadb × 62
restore × 55
mysql-5.5 × 51
replication × 48
mysql-5.7 × 41
mysql-5.6 × 38
myisam × 30
import × 25
migration × 22
mysql-workbench × 22
linux × 21
amazon-rds × 21
dump × 17
mysql-5.1 × 14
mysql-8.0 × 13
export × 12
windows × 11
mysql-5 × 11
percona × 10
performance × 9
stored-procedures × 9