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,160 points
28 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,260 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
• 56,160 points
236 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 about help https://forums.aws.amazon.com/t ...READ MORE

answered May 7, 2018 in Cloud Computing by brat_1
• 7,080 points
117 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,080 points
42 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,080 points
38 views
0 votes
1 answer
+3 votes
2 answers

How to download folder from AWS S3?

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

answered Sep 6, 2018 in Cloud Computing by eatcodesleeprepeat
• 4,670 points
2,730 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,260 points
83 views