I am making modifications to a page that is in production, I wanted to download a backup to edit it in development and I have tried to upload it in xampp but it gives me many errors with the database. I have already created the data base and I have restored the one I downloaded from the cpanel but it is still impossible to open it.
possibly the database versions are incompatible it is very common to make a backup of a modern database to an older one or vice versa and then the errors appear in lots.
To avoid these errors, it is best to use a database client other than the classic phpmyadmin. and instead of generating the sql file, download it and reload it. It is better to do a data transfer.