Discussion Locked

MySQL mysqldump exporting incomplete files?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to export a MySQL database from an Amazon Web Service Relation Database Service. I have tried connecting and exporting through MySQL Workbench and tried through command line in the EC2 server. But the tables exports still end up incomplete.

One table exports the first 5459 rows (1.1Mb) and then stops halfway through the row. another table exports the first 676 rows (7.7Mb) and then stops halfway through the row again, this table should have about 39000 rows.

I haven't used Amazon Web Services before or Linux or MySQL, I normally work on Windows servers with Microsoft SQL. Has anyone had this error before or know what the cause could be?

4 replies

by abhishekguptagupta

Hi, I own a website https://earningkart.in/ Right now I have a blog section on my site with a permalink /blog. Now I wanted to know can I create a subdomain like blog.exapmle.com and add my all /blog post to it.

What changes I have to do in MYSQL table? I just to show my all post on subdomain section instead of /blog section.

Please reply as soon as possible

Thanks & Regards,
Abhishek!!!

by lorrainepocklington

It feels like a resource issue server-wise... I noticed on another question site that a poster found the solution in the setting of the max_allowed_packet on both client and server. There's a big discussion there that I probably shouldn't repeat here, but a google for incomplete mysql exports aws might help you out.

This discussion is closed to new replies.