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
Jordi Domingo wrote:
./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
Do the GRANTs specify LOCK TABLES permission?
-- brion vibber (brion @ pobox.com)
Hrm... Try dumping using the root user, if you can.
On Apr 4, 2005 7:03 PM, Brion Vibber brion@pobox.com wrote:
Jordi Domingo wrote:
./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
Do the GRANTs specify LOCK TABLES permission?
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Thanks everybody, I just removed the refenrences to user and password and worked!
I'll import later the text to my home computer db and if doesn't match I will ask you
Jordi
mediawiki-l@lists.wikimedia.org