XF 2.0 Backup and Restore of Database Failing

[GoHerdIBG]

I am in the process of testing my dump/restore strategy and can't seem to get things to work.

The database I am dumping is:
mysqld version 5.6 (Linux)

I am using a hosting provider (KnownHost) and have used 3 methods for my database dumps:

1. In cPanel I use phpMyAdmin to export the database selecting the quick method (no options) to an .sql file. I believe this dumps everything including all databases and tables as the file is fairly large (100+M) for a new site with no real content.

2. In cPanel under Backup I "Download a MySQL Database Backup" and chose my xenforo database. This file is compressed but uncomrpressed is about 60M.

3. Using mysqldump with the command line:
mysqldump --opt xenforo --default-character-set=utf8mb4 > /tmp/xenforo.sql

On my local Linux server where I am trying to test my restore, the database is:
MariaDB version 5.5

I am restoring the database using mysql redirected:
mysql -u root -p --default-character-set=utf8mb4 xenforo < xenforo.sql

and also the non-root user (user in the application).

The import completes without any errors.

However, when I attempt to access the forums page, I get a 500 error and can not find the logs where the 500 error is being generated. access_log and error_log for apache are not showing anything.

I have tried dropping the xenforo database and recreating with the same results.

Any assistance would be appreciated.

 

[rosal]

Note: if your database collation is uft8mb4 you will need to use this command:

mysqldump --opt --default-character-set=utf8mb4 -uroot database_name > /home/path/mysql_backups/backup.sql

Thanks, where i can check if have uft8mb4?
In phpmyadmin i see utf8_general_ci in the collation.

 

[rosal]

I use utf8_general_ci in the collation i have to convert to utf8mb4_general_ci to use xenforo 2?

MySQL Collation

I've never really bothered much when it came to the 'collation' setting in MySQL. But I noticed I had a lot of mixed values. Including some old latin value. I've read up a little and I've come down to these 4 utf8_unicode_ci utf8_unicode_520_ci utf8mb4_unicode_ci utf8mb4 unicode 520_ci From...

xenforo.com

 

[AndyB]

Thanks, where i can check if have uft8mb4?
In phpmyadmin i see utf8_general_ci in the collation.

Use phpMyAdmin to check if collation column shows:

utf8_general_ci

or

utf8mb4_general_ci

 

[AndyB]

I use utf8_general_ci in the collation i have to convert to utf8mb4_general_ci to use xenforo 2?

No you can leave the collation as utf8mb4_general_ci.

 

[rosal]

Use phpMyAdmin to check if collation column shows:

utf8_general_ci

or

utf8mb4_general_ci

It show utf8_general_ci.

 

[AndyB]

It show utf8_general_ci.

The instructions from post #2 can be used.