Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


migration rejected from May 26 '13 at 15:15

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as not a real question by Mark Storey-Smith, RolandoMySQLDBA, Max Vernon, Jon Seigel, StanleyJohns May 26 '13 at 15:15

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Contact cPanel support. – Jon Seigel May 26 '13 at 13:18