Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysqldump]

42 questions
1
vote
2 answers

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 references get remove --purge -s 'mysql*' sudo…
JimmyBanks
  • 253
  • 1
  • 2
  • 9
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
vote
0 answers

slow environment with high CPU usage

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 disk i/o is not high at all we are working with…
Hamza AZIZ
  • 131
  • 5
1
vote
0 answers

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 database in phpmyadmin shown the error "#1932 - Table…
Edward Lee
  • 11
  • 1
1
vote
2 answers

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 maximum of 1G, it takes 20G more than before but…
Norbert Sehm
  • 11
  • 1
  • 4
1
vote
0 answers

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 backup from PhpMyAdmin because the daemon does not…
z3nth10n
  • 119
  • 1
  • 8
1
vote
3 answers

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 100%. I have already moved the tmpdir to…
Christian Noel
  • 129
  • 9
0
votes
1 answer

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 running Windows, the execution fails part way with…
Matt
  • 101
  • 3
0
votes
0 answers

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 program to download and install mysql/mysqldump. If…
Matthieu Napoli
  • 421
  • 1
  • 5
  • 11
0
votes
1 answer

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 replication, no fancy backup or migration…
Justin
  • 137
  • 2
  • 9
0
votes
1 answer

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 on the linux machine and connect it to the…
Geoffrey Wiseman
  • 123
  • 1
  • 8
0
votes
1 answer

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 here. My question; Is there any danger at all in…
Dmitri DB
  • 113
  • 5
0
votes
1 answer

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 the nodes that doesn't serve the application by…
rgvcorley
  • 133
  • 6
0
votes
1 answer

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-sync xtrabackup in my case, i cannot use them,…
michabbb
  • 131
  • 5
0
votes
3 answers

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 automysqlbackup (or in fact mysqldump) does lock the…
Orphans
  • 1,396
  • 2
  • 18
  • 30
1
2
3