MySQL Forums
Forum List  »  Newbie

mysqldump new problem
Posted by: Scott Jalbert
Date: November 29, 2021 09:37AM

For a long time I have been using this command to back up a database; mysqldump --all-databases --single-transaction --quick --lock-tables=false > ~/backups/full-backup-$(date +%F).sql -u zabbix -p

Today that results in a process privilege error, so a workaround is the no tablesspace option. Now the command completes successfully but it doesn't dump any data. DB is 36GB on disk and previous dumps were in the 750MB file size range. So something changed and now I need to do something different, but what?




user@computer:~/backups$ mysqldump --all-databases --no-tablespaces --single-transaction --quick --lock-tables=false > ~/backups/full-backup-$(date +%F).sql -u zabbix -p
Enter password:
user@computer:~/backups$ cat *.sql
-- MySQL dump 10.13 Distrib 8.0.27, for Linux (x86_64)
--
-- Host: localhost Database:
-- ------------------------------------------------------
-- Server version 8.0.27-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!50606 SET @OLD_INNODB_STATS_AUTO_RECALC=@@INNODB_STATS_AUTO_RECALC */;
/*!50606 SET GLOBAL INNODB_STATS_AUTO_RECALC=OFF */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!50606 SET GLOBAL INNODB_STATS_AUTO_RECALC=@OLD_INNODB_STATS_AUTO_RECALC */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-11-29 10:10:50

Options: ReplyQuote


Subject
Written By
Posted
mysqldump new problem
November 29, 2021 09:37AM
November 29, 2021 10:00AM
November 29, 2021 10:10AM
November 29, 2021 10:24AM
November 29, 2021 10:32AM
November 29, 2021 10:41AM
November 29, 2021 12:29PM
November 29, 2021 12:45PM
November 29, 2021 01:24PM
November 29, 2021 02:07PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.