We’re rewarding the question askers & reputations are being recalculated! Read more.
Server Fault

Questions tagged [mysqldump]

Ask Question

The tag has no usage guidance.

22 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
1
vote
1answer
32 views

Errors while restoring mariadb/mysql dump in docker

I'm running mariadb in a docker container. I want to backup and restore using a sql dump. I created the database for use with wordpress, and created just one test page. I installed phpmyadmin to the ...
1
vote
1answer
31 views

mysqldump extremely slow when using a private ip

I am facing a very strange issue with Mysql. I have two cloud server and they are in the same region and VPC network so the internal connection speed is quite fast. Both servers are running CentOS 7....
0
votes
0answers
13 views

Mysqldump helm chart is unable to upload via ssh. Failing at key authentication ssh

I am trying to use mysqldump helm chart and upload the dump via SSH to a remote server. This was working in my dev environment (SSH upload destination was ubuntu 16.04) but the same is not working for ...
2
votes
2answers
117 views

MySQL using ridiculous amount of memory to import 1-2GB SQL files

I have a MySQL server running on an Ubuntu 18.04 machine via Docker. The machine has 32 GB of RAM. I have about 300 1-2GB SQL files which need importing into a database on the server, into a single ...
0
votes
0answers
55 views

MariaDB rescan for consistency

At the beginning of a database dump, FOREIGN_KEY_CHECKS is disabled and at the and it is enabled again. That means consistency is not guaranteed in case of altered/broken commands inside the dump file....
2
votes
3answers
299 views

Mysql runs out of memory during backup dumps (Docker container)

We have a container running MariaDB, and a few other small containers on the host. The Mysql container was allocated 21G of memory (out of 32G total), as well as a few other parameters, with the ...
0
votes
1answer
150 views

Mysqldump to compressed file

Situation: 1. mysql is backuped to disk with mysqldump (~250 GB) 2. dump is compressed with bpzip2 3. dump is moved to another DC 4. disk usage again in good state Problem: Filesystem usage peaks, ...
0
votes
1answer
46 views

MySQL restore from dump working on OSX but not Windows

I have created a dump from a CloudSQL database for local development. I can successfully run the dump file to restore the database on a computer running OSX but when trying on a colleagues computer ...
0
votes
1answer
29 views

mysqldump piped to gzip then s3 doesn't to run out of disk space

I run the following command which all.sql.gz is greater than the amount of free space on hard drive....but somehow it completes without issue. Is it because of how the piping works? mysqldump --...
1
vote
1answer
747 views

Output of mysqldump all-databases failed to run in MySQL 8.0 because of dropping the 'mysql' database

Problem statement mysqldump --add-drop-database --all-database creates a dump that contains .... /*!40000 DROP DATABASE IF EXISTS `mysql`*/; .... This is expected and I believe is a correct ...
0
votes
0answers
145 views

Is mysqldump's binary portable across distributions?

I'm trying to write a backup program that works everywhere and is easy to install. My program downloads a mysqldump binary and runs it to export the database. I want to avoid requiring users of my ...
132
votes
9answers
91k views

mysqldump throws: Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

Every time I try to make a mysqldump I get the following error: $> mysqldump --single-transaction --host host -u user -p db > db.sql mysqldump: Couldn't execute 'SELECT COLUMN_NAME, ...
0
votes
1answer
660 views

Export Local MySQL Table Into Remote Database

I am trying to export only some tables in a local database, into a remote database which has the same name of these tables + some other tables (I want to overwrite the remote database tables which has ...
0
votes
1answer
286 views

MySQL Table Checksum - Before or after MySQL dump?

The company I'm currently working for has a script that runs at night that takes a MySQL dump of the production environment and imports it into the staging environment. This is a very basic setup - No ...
-3
votes
2answers
61 views

Large MySQL Database back up ZURMO [closed]

Not sure if anyone if familiar with Zurmo. Long story short I need to back up the whole database for it. I would use PHPmyadmin but I didn't install it when I set up Ubuntu Server. I want to use ...
0
votes
1answer
142 views

Mysqldump over SSH Fails silently with crontab

A colleague is attempting to back up a mysql database on a Windows machine from a linux machine on a schedule. The linux and windows machines use different versions of mysql, so we can't run mysqldump ...
6
votes
1answer
7k views

mysqldump: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled

When I try to run mysqldump on a Percona Server 5.7.17-12, I get this error: # mysqldump -u backups -pxxxx -h 127.0.0.1 --single-transaction --quick dbname mysqldump: [Warning] Using a password on ...
0
votes
1answer
221 views

Is it safe to mysqldump a section of missing data for re-importation with my flags?

Let's say on a test database about a year's data got erased. I got the two id's for the data in one year at the earliest and the data in the other at the latest and therefore a range of what's missing ...
0
votes
1answer
1k views

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database. I would like to perform 'hot backups' simply using mysqldump on one of ...
-1
votes
1answer
153 views

Remote Dump of MySQL user issue (behind VPN)

I'm trying to remote dump a MySQL db that is behind a VPN (I'm VPNed in): mysqldump.exe -h 10.39.23.111 -u dbuser -p remoteschema > c:\temp\mysql.sql The error message I get is: mysqldump: Got ...
0
votes
1answer
375 views

What is best method for fixing a out of sync mysql slave when pt-online-schema-change, pt-table-sync, xtrabackup do not work?

We all know, there are several methods for syncing data from a mysql master to a slave. After reading many blogs about this issue, two common tools always come up: pt-online-schema-change pt-table-...
0
votes
2answers
209 views

Adding mysqldump parameters in automysql

Please excuse any formatting or grammatical errors. I am currently using automysqlbackup to take local backups of my mySQL database. I recently started to having problems that is connected to that ...