Database Import Error - Printable Version +- Post4VPS Forum | Free VPS Provider (https://post4vps.com) +-- Forum: Geek World (https://post4vps.com/Forum-Geek-World) +--- Forum: Scripting & Programming (https://post4vps.com/Forum-Scripting-Programming) +--- Thread: Database Import Error (/Thread-Database-Import-Error) |
Database Import Error - Rehan - 02-05-2019 Hello experts, I have transferred my website from one host to a new one.I have a backup of mysql database.Whenever i import database it shows error. My SQL Said : Code: #1273 - Unknown collation: 'utf8mb4_unicode_520_ci' Code: -- -------------------------------------------------------- RE: Database Import Error - Mashiro - 02-05-2019 Depending on which version of MySQL is running on the server it might not even support the collate "utf8mb4_unicode_520_ci" and will show you this error. Try to remove "COLLATE utf8mb4_unicode_520_ci" from the whole database backup (make sure you make a copy of it before removing anything or changing anything). After that try to import the database without this code. RE: Database Import Error - Rehan - 02-05-2019 (02-05-2019, 07:35 AM)Hidden Refuge Wrote: Depending on which version of MySQL is running on the server it might not even support the collate "utf8mb4_unicode_520_ci" and will show you this error.Thanks @Hidden Refuge i have replaced those lines by " utf8mb4_general_ci ".It is working fine now. RE: Database Import Error - deanhills - 02-05-2019 Looks as though inquiry has been answered to the satisfaction of the author of the topic. Am closing this topic to prevent spam responses. If anyone wishes it to be re-opened for further discussion please PM me. |