Access denied when trying to backup Wiki

From FVue

Jump to: navigation, search

Contents

Problem

My provider allows me to connect to the database via port forwarding (see: MediaWiki backup via SSH tunnel). This used to work all right but now I receive the error: 

-- Connecting to 127.0.0.1...
-- MySQL dump 10.9
--
-- Host: 127.0.0.1    Database: db
-- ------------------------------------------------------
-- Server version       4.0.20
  
/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!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' */;
mysqldump: Got error: 1044: Access denied for user: 'user@host' to database 'db' when using LOCK TABLES

Solution

Hosting provider gave me right to LOCK TABLES.

Journal

20050815

Send e-mail to hosting provider. I remembered I upgraded to SuSE 9.3 lately, so maybe my new version of mysqldump requires LOCK TABLES permission? Maybe they can grant me the rights.

Comments

blog comments powered by Disqus

Retrieved from "http://www.fvue.nl/wiki/Access_denied_when_trying_to_backup_Wiki"
Personal tools