I recently created a complete backup of my cpanel to move it into another server. Now the
insert queries generated by cpanel for
wp-posts table (corresponding to
WordPress posts) are too big since they contain entire text of a post. So the database restore through cpanel fails. After running the query separately in
phpMyAdmin it inserts 123 rows, which should ideally be 1 row (since it's one insert statement). How do I insert these big queries?
Please suggest a solution to this.