| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 14:29:39 GMT
content-type: text/html; charset=utf-8
cf-ray: 963bdf0698efc1ba-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=b320b09c-97a7-4eaa-8d10-800358f37bb8; expires=Thu, 23 Jul 2026 14:29:39 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: bdaceb53-799b-4d83-a187-ba745407997f
x-worker-origin-response-time: 475000000
x-dns-prefetch-control: off
set-cookie: prov=b320b09c-97a7-4eaa-8d10-800358f37bb8; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=.KzLzJQ6DNm.zwqh2neY.CoUhoKHb2QdMm1umLWrsvc-1753280979-1.0.1.1-wPcvXmGkSMeRhsTOwoO..kYQVMENzC27dHXSTtnjZ6BBHKxhp0Hkb2gG6X.A2R96LMHOqvSWs3wrWYWspT_._Zzl8PADEqaYjtePKi.FQIc; path=/; expires=Wed, 23-Jul-25 14:59:39 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=cjFRiLhrfKuy_A.Mdzs9RnQZtrpUHANUo_zicdopJH0-1753280979470-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'mysqldump' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [mysqldump]
MySQL's Standard Dump/Backup Utility
754 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
31
views
mariadb docker fails to Initialize database contents from dump file
I have a Nextcloud server set up that uses docker image mariadb:10.11. I use mysqldump to back up the database. Where I am having trouble is trying to restore that to a test system as described here ...
1
vote
0
answers
25
views
Cloud SQL: gcloud sql export sql does not include procedures/triggers — alternatives?
How to export stored procedures and triggers from Cloud SQL without hitting production?
I'm using Google Cloud SQL (MySQL) and want to automate a nightly/weekly clone of the production database into ...
1
vote
2
answers
42
views
Unexpected occasional DEADLOCK when re-recreating database from split MySQL dump
To replace the content of a test database from a production database mysqldump output the following command was used:
cat mysqldump-db-thisdate.sql | mysql -p ... mydb
There has never been any issue ...
1
vote
1
answer
84
views
Restoring a primary mysqldump on a R/O replica
EDITED:
I've encountered the following error message on my R/O replica which supports GTIDs and had not been running for a few weeks:
Last_IO_Error: Got fatal error 1236 from source when reading data ...
1
vote
1
answer
49
views
Replication - replica falling behind while mysqldump is taken
I am pretty inexperienced with MariaDB, especially replication. However, being 'on call duty' I have an issue with this today.
it looks like my replica is falling behind while I am taking a mysqldump ...
0
votes
0
answers
48
views
mysqldump export not all rows on table with binary content
I try export a table from mediawiki. The structure is:
CREATE TABLE `dev1text` (
`old_id` int unsigned NOT NULL AUTO_INCREMENT,
`old_text` mediumblob NOT NULL,
`old_flags` tinyblob NOT NULL,
...
1
vote
1
answer
123
views
How to truncate tables in cron job while mysqldump is running? Prevent Error 1412 "Table Definition Has Changed"
I have a maintenance cron job script that runs every 5 minutes that TRUNCATES a table, repopulates it with maintenance data, and then TRUNCATES it at the end. I also run a daily mysqldump script that ...
0
votes
1
answer
88
views
The mysqldump command is omitting collation in the output
When I run mysqldump, the output does not include the table default collation for some tables. How do I include the collation for all tables?
The MySQL version is 5.7.
mysqldump --version
mysqldump ...
0
votes
0
answers
55
views
MySQL: Using Symbolic Links for Databases on linux
Someone gave me a database. It's (1) a folder containing files with the following extensions: MYD, MYI, TRG, TRN, frm, opt; (2) a file with the sql-extension called db_add_nodata.sql , and (3) a file ...
0
votes
3
answers
521
views
How to use mysqldump to transfer data to another server with a different database name
I have a production MySQL server and I want to copy everything to a development MySQL server (actually, I believe it is really MariaDB on the development side). Both servers are hosted (one Azure, the ...
0
votes
0
answers
35
views
Issue when performing mysqldump - Matomo - MySQL error 2013
On premise setup, **Ubuntu 20.04:
CPU: AMD Ryzen 5 3600 6-Core Processor
Memory: 64GB RAM**
mysql Ver 8.0.40-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
We’re recently being confronted by an ...
1
vote
1
answer
61
views
0
votes
1
answer
151
views
Loading an SQL dump is slow
note: I initially asked this question on stackoverflow, but was told superuser would be a better place for it. I was then made aware of the existence of dba.stackexchange, which seems like the right ...
1
vote
1
answer
39
views
mysqldump 8.0.22 doesn't output rows for a large table using where flag
I have a table which has a few hundred million rows and I'm trying to create backups using the mysqldump utility, version 8.0.22.
My entire command looks like the following (I've omitted the actual ...
0
votes
1
answer
42
views
Why my mysqldumps are corrupted?
Every night laravel scheduler runs "mysqldump -h $dbHost -u $dbUsername -p$dbPassword $dbDatabase > $path/$filename" command through exec() functon.
And sometimes the dump is corrupted in ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 663
backup × 227
mariadb × 76
innodb × 68
restore × 61
replication × 50
mysql-5.5 × 48
mysql-5.7 × 42
mysql-5.6 × 38
myisam × 28
import × 25
linux × 21
amazon-rds × 20
migration × 20
mysql-workbench × 19
dump × 18
mysql-8.0 × 18
mysql-5.1 × 13
export × 12
percona × 12
mysql-5 × 11
windows × 11
command-line × 8
performance × 8
more related tags
Hot Network Questions
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- bootstrapping for variance estimation takes too long
- Dystopian 80s sci-fi movie about the USA choosing mediocrity
- When you view a historical event with an incorrect modern lens
- Pourquoi "better to use ne alone" dans ce cas, "with savoir followed by an indirect question"?
- rEAAlly good for you
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- Can I mount my PC with a desktop mount underneath a particle board Ikea Karlby Walnut top?
- Why were two 2x6 boards installed on top of a window rough sill?
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- How can I grow kelp or seaweed at home in a small container?
- How much time should I take for "self transfer" without checked-in baggage?
- Issue with OR operator in QGIS Rule-Based Labelling expression
- Why does internal energy end up higher in an irreversible adiabatic process, even though the work done is less?
- Will a restless MCU survive long enough?
- What was the source of the image of pelican in Catholic churches?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- Story about a room on Mars that contains God
- Sum of ranks of blocks
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- Is a diet of one third Tuna ok for an eldery cat?
- Create a custom filter in WordPress extensions page
- Not sure which test statistic to look at with regression with interaction term
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?