mysqldump and mediawiki
Hi all,
I wrote a php script to backup my databases. It works with all batabases but wikidb which is the name of the DB i use for MediWiki.
The command is
root[~]# /usr/bin/mysqldump -u yyyyyy -pxxxxxxxxxxxxx -S /media/hdb1/zan/Gestione/mysql/mysql.sock wikidb >/media/ext3/Backup_MySql/Wikidb_20120521-164555.sql
but I get following error
mysqldump: Got error: 1146: Table 'wikidb.category' doesn't exist when using LOCK TABLES
The eviroment is:
MediaWiki 1.14.0
PHP 5.2.11 (apache2handler)
MySQL 5.1.56-log
and now some strange things
from command line the above command works correctly (its not a permissions problem since the same command but with other BD works)
running mysql inside a terminal I get that following tables are present wikidb
+-------------------+
| Tables_in_wikidb |
+-------------------+
| archive |
| category | <--------- the missing table is present
| categorylinks |
| externallinks |
......
......
| user_groups |
| user_newtalk |
| watchlist |
+-------------------+
38 rows in set (0.00 sec).
If I check wikidb tables from phpmyadmin I dont see the "category" table and there are 34 tables instead of 38.
Any idea?
Thank you in advance
Subject
Views
Written By
Posted
mysqldump and mediawiki
3935
May 21, 2012 02:12PM
1435
June 04, 2012 03:39PM
1619
June 04, 2012 03:49PM
1740
June 04, 2012 04:03PM
1718
June 04, 2012 04:16PM
1667
June 30, 2012 04:23AM
1456
July 03, 2012 10:01AM
1368
July 03, 2012 11:52AM
1477
June 15, 2012 09:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.