Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysqldump]

39 questions
434
votes
19 answers

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, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')…
manifestor
  • 5,329
  • 5
  • 21
  • 33
8
votes
1 answer

Used mysql command instead of mysqldump

I wanted to backup my MySQL database and I accidentally used mysql command instead of mysqldump. So I executed: /usr/local/mysql5/bin/mysql -u db_username -p db_name > db_backup.sql Instead of: /usr/local/mysql5/bin/mysqldump -u db_username -p…
TmCrafz
  • 129
  • 7
7
votes
2 answers

Install MySQLDump for MySQL 8.0 on Ubuntu 18.04

I am trying to install mysqldump on a Azure hosted Ubuntu VM. During the build process I attempt the following command: sudo apt-get update sudo apt-get install -y --no-install-recommends mysql-client-8.0 This results in the following error: Unable…
JimmyBanks
  • 203
  • 1
  • 2
  • 7
6
votes
1 answer

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 the command line interface can be insecure. -- MySQL…
the_nuts
  • 412
  • 6
  • 18
5
votes
3 answers

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 following commands in the…
Hadrien
  • 51
  • 1
  • 2
4
votes
2 answers

Log the error and warning while restoring the sql dump on MySql

How to log the error and warning while restoring the SQL dump on MySQL ? Following are the steps we were doing. mysql> CREATE DATABASE dbname; mysql> USE dbname; mysql> SOURCE dbdumpname.sql
Aha
  • 389
  • 3
  • 6
  • 18
3
votes
2 answers

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 table. The database itself is completely empty, and…
Billy
  • 31
  • 2
2
votes
1 answer

How to compress SQL file correctly on CentOS?

I have a database whose size is roughly 3.1 Gb according to PhpMyAdmin. I would like to dump and compress it with gzip. This is a very similar answer to what I'm trying to do: https://serverfault.com/a/804273/326635 Here is my command: mysqldump…
Mcload
  • 133
  • 1
  • 5
1
vote
1 answer

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 same database. I created a backup like…
lonix
  • 757
  • 9
  • 20
1
vote
1 answer

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.6 I performed a simple test using scp to copy one…
mike
  • 11
  • 1
1
vote
1 answer

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, example: I need 1 TB space to fit the data while…
Damian
  • 21
  • 3
1
vote
1 answer

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 --defaults-file=/home/ec2-user/db-master.cnf…
Chris Muench
  • 417
  • 3
  • 9
  • 29
1
vote
1 answer

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 behavior. Yet, if cat'ing this dump into a mysql server,…
HelloSam
  • 171
  • 1
  • 6
1
vote
1 answer

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 the same name with the local ones I have from my…
Madno
  • 193
  • 2
  • 14
1
vote
0 answers

Mysqldump really slow when dumping to network drive

I'm facing an issue when dumping a mysql database to the network drive. The thing is I'm getting really slow speeds (around 3-7mb/s). Dumping locally, the speed is fine. I've coded my own program that performs automatic backups 4 times per day and…
Sebastian Martinson
  • 11
  • 1
1
2 3