How to copy table from another MySQL database

0 votes
Once login, is there another way to connect to another database?

Please help me with it
Aug 1, 2018 in Cloud Computing by code_ninja
• 6,300 points
585 views

1 answer to this question.

0 votes

Once login there is no way to connect to another database. The only way out is we have to export the data first and then import

Use the mysqldump tool for exporting like:

mysqldump -h HOST -u USER -p database table > export.sql

Then import it via: 

mysql -h HOST -u USER -p database table < export.sql

answered Aug 1, 2018 by Gopalan
• 1,360 points

Related Questions In Cloud Computing

0 votes
2 answers

Is there a way to copy AMI from one AWS account to another AWS account using boto?

You could share the AMI from one ...READ MORE

answered Aug 21, 2018 in Cloud Computing by Priyaj
• 58,020 points
2,256 views
0 votes
1 answer

Is there a way to use amazon ECR image from one account in the code build of another account?

These forums might just help with AWS ...READ MORE

answered May 7, 2018 in Cloud Computing by brat_1
• 7,200 points
1,650 views
+2 votes
2 answers

Is there a way to get IAM Credentials from Cognito Username/Password from CLI?

Try doing it the other way round. ...READ MORE

answered Mar 27, 2018 in Cloud Computing by brat_1
• 7,200 points
1,275 views
+4 votes
2 answers

Amazon S3 Permission problem - How to set permissions for all files at once?

This can be done by setting the ...READ MORE

answered Mar 27, 2018 in Cloud Computing by brat_1
• 7,200 points
4,067 views
0 votes
1 answer
0 votes
1 answer
+8 votes
3 answers

How to download folder from AWS S3?

To Download using AWS S3 CLI : aws ...READ MORE

answered Sep 7, 2018 in Cloud Computing by eatcodesleeprepeat
• 4,710 points
289,026 views
0 votes
1 answer

How to delete the files from AWS S3 except the recently 5 added/updated files?

Use AWS s3 rm command with multiple --exclude options as shown: aws ...READ MORE

answered Jul 30, 2018 in Cloud Computing by Gopalan
• 1,360 points
3,864 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP