Linux · MySQL / MariaDB

You run mysqldump for a backup while the app keeps writing. Which option guarantees a consistent snapshot, and which one makes the restore not fail on existing tables?

Sign in to see the full answer — free to start on the web.

This is one card from the KnowCard library. The full way to learn it — spaced-repetition review, progress tracking, and AI explanations — lives in the KnowCard app, free to start on the web. iOS & Android are coming soon.

Get started — it’s free

Already have an account? Sign in →

More in MySQL / MariaDB

You wrote a proprietary closed-source product that bundles the MySQL server. Someone tells you MySQL is free software, so no license is needed. Where does that reasoning break down?

A colleague assumes every distro ships MySQL. On Debian, Fedora, and openSUSE you can't find a MySQL package at all — only MariaDB. What is going on?

You picked a MariaDB version for a system you'll run for several years. Why does grabbing whatever is newest sometimes leave you patched for only one year?

You're migrating a server and need to copy the actual database contents, whether it runs MySQL or MariaDB. Which directory holds the data files?

The database won't come up after a config edit and you want to see why. What's a distribution-independent way to read the startup errors?

You edited settings under the [mysqld] section but nothing changed. Why, and how do other sections of the config behave differently?