Backup mysql database from live server to my local MySQL

Question

I develop a good website on my local computer, lets called Site A. I have packed them and put to live server which host by hosting company.

Now.. I would like to take database from Site A (live server) to my Site A database that I manage on my PC localhost.

Is there any command line work to update my Site A Database (development area) with current data table from Site A on live server?

empty the tables in local pc and import data using phpmyadmin — Karthick Kumar
– Karthick Kumar, Commented Jan 22, 2014 at 8:59

CS GO · Accepted Answer · 2014-01-22 09:19:23Z

1

first from remote server in terminal/cmd:

mysqldump -u [username] -p[password] [dbname] > [backupfile.sql]

after that in local machine terminal/cmd:

mysql -u [username] -p [password] [dbname] < [backupfile.sql]

answered Jan 22, 2014 at 9:08

CS GO

9026 silver badges20 bronze badges

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

Comments

sergio · Accepted Answer · 2014-01-22 09:01:04Z

1

First, if you have access to remote DB, using command line and fetch the remote database, you can do something like this:

cd "mysql_directory"

after, do

mysqldump -u username -p -h host_ip DATABASE_TO_MIRROR >c:\backup\database.sql

answered Jan 22, 2014 at 9:01

sergio

5,2607 gold badges27 silver badges47 bronze badges