MySQL Forums
Forum List  »  Backup

mysqldump and mediawiki
Posted by: Joshua Whopper
Date: May 21, 2012 02:12PM

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

Options: ReplyQuote


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.