I am uploading my website but in MySQL database getting import error: " #1142 - TRIGGER command denied to user ‘epiz_32981627’@‘192.168.0.6’ for table 'wp_comments " The table wp_comments is the issue this table is not necessary so I can skip or whatever the solution for import rest of database. Thanks
The wp_comments is a necessary table of WordPress, but WordPress is built for broad compatibility and doesn’t use advanced database features such as MySQL triggers.
I’m curious as to what this trigger actually does (the top result I found related to this uses MySQL triggers for a security backdoor, which would be very bad news). But I’m pretty sure you don’t need it.
If the TRIGGER statement is blocking the restoration of the backup, the easiest way to get a backup without triggers is to go back to the previous server and generate a new backup without triggers (phpMyAdmin has a checkbox for that). Alternatively, if you have some knowledge of SQL, you can edit the export file yourself to remove the TRIGGER commands yourself.