MySQL copy table to another database (not the same network)- backup?

Question

I have a working database - and I want to copy all its data (or even just 1 table from it) and create a backup on disk and also create a "backup" database on another location (not the same computer). The other computer is not connected to the internet

How can I do this?

Jayesh Dhandha · Accepted Answer · 2018-05-21 13:38:01Z

0

Use mysqldump to create dump of you Database. Which will be in <name>.sql format.

Then restore it in another system.

Reference: https://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump

answered May 21, 2018 at 13:38

Jayesh Dhandha

2,15931 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Korenron Over a year ago

sorry , but I guess I'm missing something ..... how do I do this using MySQL WorkBench? Thanks,

Jayesh Dhandha Over a year ago

There are only 4 commands. You can easily do this using command line. In MySql workbench there is option of import and export. Try that. Reference: dev.mysql.com/doc/workbench/en/…

Korenron Over a year ago

Thanks , I did a simple export\import for tha table I wanted.... BTW can I do the same thing to a whole DB? All Table? and not jsut 1 table inside?

Jayesh Dhandha Over a year ago

Yes of course. There should be select all option which will take dump of whole database.

Korenron Over a year ago

Ok , I will try - Thank you

Collectives™ on Stack Overflow

MySQL copy table to another database (not the same network)- backup?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related