Reputation: 321
Instance details: Aws Linux instance
My database contain 1680 individual tables I'm trying to export database in phpmyadmin it failed and i'm trying below command to export db file at end of execution only partial db file created
mysqldump -u root -p password exampledb > /var/www/html/exampledb.sql
Upvotes: 0
Views: 1427
Reputation: 321
finally gzip compression helps me to take full database dump without any error.
mysqldump -u user -p exampledb |gzip> /var/www/html/exampledb.sql.gz
Upvotes: 1