I used the following commands to backup and restore:
mysqldump -h localhost -u user -p --default-character-set=binary database >
database.sql
mysql -u user -p -h localhost database < database.sql
Thanks!
On Mon, Oct 25, 2021 at 4:07 PM John <phoenixoverride(a)gmail.com> wrote:
How did you backup/restore the database?
On Mon, Oct 25, 2021 at 4:56 PM Jingyi C. Shi <jshizhang(a)gmail.com> wrote:
> Hi John,
> I backed up my database and the entire wiki folder. I didn't re-download
> MediaWiki this time. I directly loaded the backup database into the new
> server, and moved the entire wiki folder. I don't think the PHP versions on
> both servers are exactly the same. PHP on the new server is 7.4 while on
> the old one maybe 7.0 or similar.
> Thanks!
> Catherine
>
> Message: 2
>> Date: Mon, 25 Oct 2021 16:41:07 -0400
>> From: John <phoenixoverride(a)gmail.com>
>> Subject: [MediaWiki-l] Re: Pages not showing with error messages
>> To: MediaWiki announcements and site admin list
>> <mediawiki-l(a)lists.wikimedia.org>
>> Message-ID:
>> <CAP-JHpmhOo67rCHoQ5LoEx=1-NNKg2+YegAbWc7u+8=
>> aJgimvA(a)mail.gmail.com>
>> Content-Type: multipart/alternative;
>> boundary="00000000000015550905cf336298"
>>
>> How are you doing the backup/restore? did you backup your database and
>> re-download mediawiki? are the versions of PHP the same on both servers?
>>
>