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