Please help so that I can export MySQL database from prior MediaWiki into MySQL of XAmpp installed in a new Windows machine.
Following are the steps I took:
Downloaded and installed xampp-windows-x64-7.4.16-0-VC15-installer, as the latest mediaWiki can only support up to PhP 7.4
In C:\Xampp\php.ini, changed:
max_execution_time = 3600
upload_max_filesize=2000M
max_file_uploads=10000
Created a new database using Xampp control panel with name newmediawiki
Restart Apache and MySQL in Xampp using Control Panel
I had the priormediawikidb (exported from prior media wiki) saved in my C:\mediawiki, and saved it as zip, and another copy as sql extension (as I tried with both the formats). The priormediawikidb is 1.5 GB.
I tried exporting priormediawikidb into the newmediawiki using both Control panel and from the command line, but with no success.
When I try the control panel, I get an error shown on the Control panel as "Incorrect format parameter", so it was of no use.
I tried the following (tried with both sql extension and zip extension) from the command line as follows:
C:\Xampp\mysql\bin>mysql -u root newmediawikidb < "C:\mediaWiki\priormediawikidb.sql"
Also, tried (by changing the format of file from sql to zip) as:
C:\Xampp\mysql\bin>mysql -u root newmediawikidb < "C:\mediaWiki\priormediawikidb.zip"
By running from the command line (with both zip format and sql format) no error was thrown in the command line and I got the command line prompt back. I restarted Apache and MySQL, refreshed the PHP/MySQL browser (http://localhost:8082/phpmyadmin/), but I do NOT see the prior tables imported into newmediawiki.
The mysql_error.log does not give any information.
The prior MySQL was of version 5.0.27 if that matters.
The command prompt successfully returns but I do not see the tables into newmediawikidb.
I will appreciate any help.