CAPS user to undercase user

[marcovdahosting]

Hi lads,

On the old server of a client he has a user with CAPS like USER1 and on the new server we have restored the backup which has user1 in undercase characters. I am running against some issues with DB import issues. How can i solve this matter ?

 

[zEitEr]

1. Delete restored user on new server.
2. Rename user's backup from USER1.tar.gz => user1.tar.gz
3. Restore user from renamed backup.