Forums

Can't restore mysql backup file because of denied access

I'm trying to restore the database from the backup file (as described here: https://help.pythonanywhere.com/pages/MySQLBackupRestore/) and getting the following error. What am I doing wrong?

> 2:15 ~ $ mysqldump -u DimaFrank -h DimaFrank.mysql.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces 'DimaFrank$IWM' > /home/DimaFrank/project/iwm/backup/IWM_backup.sql

12:16 ~ $ mysqldump -u DimaFrank -h DimaFrank.mysql.pythonanywhere-services.com 'DimaFrank$IWM_dev' < /home/DimaFrank/project/iwm/backup/IWM_backup.sql

-- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
--
-- Host: DimaFrank.mysql.pythonanywhere-services.com    Database: DimaFrank$IWM_dev
-- ------------------------------------------------------
-- Server version       8.0.35
/*!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' */;
/*!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 */;
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!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 2024-10-26 12:16:33
12:16 ~ $

[edit by admin: formatting]

I think when you took this dump you didn't have the '--no-tablespaces ' option on the command