[Mediawiki-l] mysqldump - no permission to backup (and a knoppix issue)

Jordi Domingo jordidr at gmail.com
Mon Apr 4 15:07:19 UTC 2005


Hello everybody! I am creating my wiki but I need to present my
progress regularly to my project's heads. I can mail the .php, but the
content of the page and other thing are by DB. So, I read
Documentation::Administration, and I decide to make a dump of the DB
('Backing up data: Creating a database dump') and recuperate it in my
bosses' computer (following 'Importing the database dump').

I go to /opt/lampp/bin (I use Xampp) and ./mysql . Then 'use wikidb',
I try 'select * from cur where cur_namespace='Portada';' and all
right... but trying

./mysqldump --user=wikiuser --password=mypassword \wikidb > wiki-volcatdb-1.txt

does

./mysqldump: Got error: 1044: Access denied for user
'wikiuser'@'localhost' to database 'wikidb' when using LOCK TABLES

In localsettings.php I have:

$wgDBserver         = "localhost";
$wgDBname           = "wikidb";
$wgDBuser           = "wikiuser";
$wgDBpassword       = "mypassword";
$wgDBprefix         = "";

I installed from root...I don't have permissions in the DB??

By the way, I am trying to work from home using Knoppix; I have read
that I can modify permissions and so write in disk, but it's
reasonable to work with Wikipedia and Xampp using Knoppix liveCD?


Thanks in advance

Jordi



More information about the MediaWiki-l mailing list