Questions tagged [mysqldump]
42 questions
0
votes
1 answer
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 command:
mysqldump --max_allowed_packet=5120M -u…
Gbl
- 3
- 1
0
votes
0 answers
Problems with MySQL 8.0.29 Data Corruption, Need Upgrade Path Advice
I have a master and 3 slaves running the buggy 8.0.29 version of MySQL. Yesterday 2 of my slaves stopped synchronizing and I couldn't complete a full resync from a fresh dump because I kept getting "error 2013 lost connection to SQL server" when…
daehnomel
- 1
- 1
0
votes
0 answers
mysqldump encrypted table - keep encryption
If we have a table that is encrypted at rest, like this:
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-data-encryption-master-key-rotation
How can we configure mysqldump to dump encrypted data and the key in the…
iateadonut
- 121
- 4
0
votes
1 answer
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/define( *'DB_USER', *'\([^']*\)'.*/\1/p"…
Torben
- 123
- 2
0
votes
0 answers
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 structure in the first (that can can be installed…
Entretoiz
- 73
- 2
- 5
0
votes
1 answer
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 for over 24hr when I caught the issue. I am…
JimmyBanks
- 253
- 1
- 2
- 9
0
votes
2 answers
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 password seems to inherit this password.
Is it possible…
owenmelbz
- 163
- 3
- 12
0
votes
0 answers
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/forumbackup/backup.$(date…
Neil
- 1
0
votes
1 answer
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'
I tried to import the same sql into a Debian 10,…
Gagan Pal
- 33
- 7
-1
votes
1 answer
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 error: 1045: Access denied for user…
StackOverflowed
- 109
- 4
-1
votes
2 answers
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 * * 4 mysqldump -u username -p password…
Rohit Gupta
- 356
- 2
- 4
- 14
-3
votes
2 answers
Large MySQL Database back up ZURMO
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 MySQLdump command but I'm afraid of crashing the…
Medic305
- 101