Happy Coder on "[Plugin: Duplicator] Cannot restore - always promted to do fresh WP install"

Happy to post the fix.

https://wordpress.org/support/topic/duplicator-creates-a-new-install-not-a-duplicate?replies=38#post-7752708

and

http://stackoverflow.com/questions/5659835/xampp-and-mysql-all-colimns-in-table-are-lower-case-in-php,

particularly, this answer

http://stackoverflow.com/a/8587744

was the solution for me.

If you are on Windows or Mac using XAMPP, WAMP, etc. and you want to use case senSiTiVe characters for your table names, so to speak, if you set a case sensitive table prefix in your wp-config.php like so

$table_prefix = 'hfjRhjgvnjmDzgnme_';

then you must set

lower_case_table_names = 0 in your my.ini file

in the [mysqld] section of that file.
Find the my.ini file in the mysqlbin folder of your XAMPP or WAMP installation.

And then you must deal with the waing that Duplicator correctly throws you during scanning.

Though your MySQL databse will be restored correctly with case senSiTiVe characters as table prefix to the host/server!

Duplicator works regardless of this MySQL configuration! Attention there Windows and Mac users!

Depending on where you restore the archive to the MySQL configuration might be different, it can happen that WP does not recognize the WP install because the table prefix is all lowercase and because of that WP throws the install screen as it wants to create a new set of a database.

3. For table name case sensitivity issues either rename the table with lower case characters or be pre-paired to work with the lower_case_table_names system variable setting.

[would be good to change per-paired to prepared]

So do we have to use lowercase table prefixes on Windows and Mac machines if we want to work with various hosts?

Are lowercase table names the (preferred) standard?

I assume so since many hosting companies are based on Linux systems, no?

Duplicator does the job right, though the table names are borked if you are on Windows or Mac and use UPPERCASE characters in your table prefix.

So basically the chances are quite high of someone running into this error. Attention there users, this is not really Duplicator related.

How could Duplicator though kind of wa users on Windows or Mac systems about the use of UPPERCASE characters as table prefix?