Topic on Project:Support desk

problem with displaying images after importing sql dump / "php importDump.php" in new server ( getting tones of pages with broken file links )

4
165.225.206.250 (talkcontribs)

Hi All, From some time Im struggling wit the issue where on on my MediaWiki 1.35 hosted Centos7 with XAMP ( 7.3.27-1 / 7.4.16-0, PHP 7.3.27 , 7.4.16 ,Apache 2.4.46 , MariaDB 10.4.18 ) i was trying to import into my wiki data via mysqldump -ed files from the other of my server also working under Centos 7 and a bit older XAMPP , MediaWiki v. 1.32. and older version of Mariadb 10.3.16 ) After typical pulling sql dump of DB with all tables , I wasnt able log in, nor launch any pages in new server.. Looks like this import totally messed up my wiki. When I was trying to log in, frontend screen error was saying: "Auto-creation of a lcoal account failed. Username entered already in use... " . I did chacke USER table form backend and looked ok to me .

I decided to restore my wikidb from sql backup which I made prior the that import, So I did try another shut and import data previously exported , this time with usage of "php dumpBackup.php --full --quiet > dump.xml" . I did import successfully my new server with "php importDump.php < dumpfile.xml" .Pages looked to be opening correctly and logging was proper. I did copy over all IMAGE folder and untar it. All other server paths and settings looks exactly the same on my both servers. IMAGE folder have all correct permissions. but imported images are not being displayed.

I did use few of the maintenance scripts like: php rebuildImages.php , checkImages.php , rebuildImages.php and all other related with images and metadata. Even so my other imported images are in the same directory, those php maintenance script only can detect just one image file that i recently uploaded and put on a article manually via defaul editor. All imported pages seems to be OK on my new server, so the problem is with pages cannot "see" images embended. Can you advise what esle should I check? what can be casuing problem, is tehre any other maintenace activity i can try? ps I did twice my sql dump import with also with droping the DB


thanks for any hits

165.225.206.250 (talkcontribs)

also when comparing the tables between servers , i see that in page table I have different values for page_id for given page titles than in old server. that is casung that imagelinks table via its field il_from referencing the page table ( page_id) are having mismatch. However dumping and importing page table again from the old server is casuing wiki to not display sites all . rebuildall.php crashes with error when trying to fix it.

Bawolff (talkcontribs)

Did you copy over the image table?

165.225.206.250 (talkcontribs)

yes, the image table was copied to new db. the problem the when compare page table i see different page_id values per page name. that is why imagelinks table provide a valid values. , but when I copy over the page table , it all crashes and new wiki cannot display any page.

Reply to "problem with displaying images after importing sql dump / "php importDump.php" in new server ( getting tones of pages with broken file links )"