Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [mysqldump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
866 views

Mysqldump max_allowed_packet issue

I need to migrate a database that was managed by someone who left the company. The source server is MariaDB 1:10.5.5, the destination MariaDB 1:10.5.19. The existing backup scripts use the following ...
Gbl's user avatar
  • 5
0 votes
2 answers
2k views

Cron job to backup the MySQL database produces empty dump files with no errors logged that I can find

My site is controlled via cpanel. I want to automate the backup of my databases and then automate their download to my development machine. The first step was to set up the cron jobs as follows 0 3 ...
Rohit Gupta's user avatar
0 votes
1 answer
252 views

mysqldump - username takes "-p" as well

I use the following script to read database credentials from a Wordpress installation: DB_NAME=$(sed -n "s/define( *'DB_NAME', *'\([^']*\)'.*/\1/p" wp-config.php) DB_USER=$(sed -n "s/...
Torben's user avatar
  • 123
0 votes
0 answers
32 views

How to restore sql+txt dump?

I have some dumps created with the following command: mysqldump --host=$host --user=$dbuser --password=$dbpass --tab=$backupdir/$dbname $dbname That created couple files table.sql/table.txt with the ...
Entretoiz's user avatar
1 vote
2 answers
2k views

How to downgrade mysql-client from 8.0.27 to 8.0.26 on Ubuntu

MySQL 8.0.27 has a bug when used to connect to Azure, where it uses all CPU resources and never connects. Therefore I would like to downgrade to 8.0.26 What I have tried so far: #uninstall any mysql ...
JimmyBanks's user avatar
0 votes
1 answer
1k views

MySQL Dump on Ubuntu 20.04 returns 0 byte file and runs indefinitely. Works on Ubuntu 18.04

I am using identical configs on Ubuntu 20.04 as I was previously on 18.04; however, on 20.04 the CPU shoots up to 50% usage and the process runs indefinitely, and by indefinitely I mean it was running ...
JimmyBanks's user avatar
1 vote
0 answers
653 views

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 ...
Sebastian Martinson's user avatar
4 votes
1 answer
4k views

How to get a local mysql dump of a specific AWS RDS Snapshot

Hello I have a linux bastion host in AWS that I am able to SSH into. In the Bastion I am able to run a mysqldump command which makes a copy of an RDS instance. What I want to accomplish is being able ...
CodeConnoisseur's user avatar
1 vote
0 answers
156 views

slow environment with high CPU usage [closed]

I'm new to Linux metrics in our test environment we experiment a slowness, after investigation we have found that the disk space used to store backup data is full, but what is wired for me is that the ...
Hamza AZIZ's user avatar
0 votes
2 answers
845 views

Default password in .my.cnf for a specific user

We've got a backup script which takes a mysql dump every night, and to authenticate we've got a .my.cnf file with [mysqldump] password=somepass However, every mysql user that doesn't pass in a ...
owenmelbz's user avatar
  • 173
8 votes
1 answer
1k views

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: /...
TmCrafz's user avatar
  • 139
0 votes
0 answers
176 views

Backing up a large database using mysqldump and CRON

I'm trying to backup a single MySql Database on my website using CRON but it's not working. Command is /usr/bin/mysqldump -uUSERNAME -pPASSWORD --databases DATABASENAME | gzip > /home/MYSITE/...
Neil's user avatar
  • 1
1 vote
0 answers
113 views

Mysql database restore from rescue mode server

I have one server which is in rescue mode, and limited run the command even the mysqldump. I tried to restore the client database to new server by manually upload and created database but the sql ...
Edward Lee's user avatar
1 vote
2 answers
2k views

Database Restore ERROR 2013 (HY000) at line 68497: Lost connection to MySQL server during query mariadb

I have a Database of 150G - 300 Mio entries and i want to restore it (gz SQL Dump) on MariaDB 10.3 but the restore failed because the sql server gone away. I tried to raise max_allowed_packet to the ...
Norbert Sehm's user avatar
11 votes
2 answers
48k views

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-...
JimmyBanks's user avatar
1 vote
0 answers
3k views

mysqldump: Couldn't execute 'show create table `xxx.yyy`': Table 'yyy' doesn't exist in engine (1932)

I had to redo my server (Debian 9) in Proxmox. I updated a package (libc6) and I broke the dependencies (I didn't snapshot it...). One of the affected daemons was MySQL / MariaDB, I could not make a ...
z3nth10n's user avatar
  • 119
1 vote
3 answers
1k views

mysqldump using a lot of space

I have a server and the / partition is 20GB in size. Databases are stored in /mnt/mysql-data partition is 500GB in size. Now here's the problem. Whenever I run mysqldump it fills up / partition to ...
Christian Noel's user avatar
0 votes
1 answer
927 views

Solved 'ERROR 1054 Unknown column' importing into MariaDB 10.4

I recently tried to migrate a database from an old Debian 8, MariaDB 10.1 server to a new Debian 10, MariaDB 10.4 but met with this nasty error ERROR 1054 Unknown column 'pusername' in 'field list' ...
Gagan Pal's user avatar
2 votes
1 answer
17k views

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....
Mcload's user avatar
  • 133
1 vote
1 answer
951 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 ...
lonix's user avatar
  • 978
1 vote
1 answer
1k 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....
mike's user avatar
  • 11
3 votes
2 answers
3k 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 ...
Billy's user avatar
  • 31
5 votes
3 answers
8k 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 ...
Hadrien's user avatar
  • 51
1 vote
1 answer
1k 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, ...
Damian's user avatar
  • 21
0 votes
1 answer
166 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 ...
Matt's user avatar
  • 101
1 vote
1 answer
228 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 --...
Chris Muench's user avatar
1 vote
1 answer
2k 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 ...
HelloSam's user avatar
  • 171
0 votes
0 answers
883 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 ...
Matthieu Napoli's user avatar
503 votes
23 answers
362k 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, ...
manifestor's user avatar
  • 6,469
1 vote
1 answer
1k 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 ...
Madno's user avatar
  • 203
0 votes
1 answer
885 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 ...
Justin's user avatar
  • 137
-3 votes
2 answers
76 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 ...
Medic305's user avatar
  • 101
0 votes
1 answer
226 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 ...
Geoffrey Wiseman's user avatar
6 votes
1 answer
8k 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 ...
the_nuts's user avatar
  • 460
0 votes
1 answer
522 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 ...
Dmitri DB's user avatar
  • 113
0 votes
1 answer
2k 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 ...
rgvcorley's user avatar
  • 133
-1 votes
1 answer
524 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 ...
StackOverflowed's user avatar
0 votes
1 answer
729 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-...
michabbb's user avatar
  • 131
0 votes
3 answers
622 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 ...
Orphans's user avatar
  • 1,434
4 votes
2 answers
28k views

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....
Aha's user avatar
  • 419