Update online MySQL with local computer SQL via Command Prompt?

Question

I have an online sql database which is used by a PHP web-script.

I'm working with someone who is managing a local database on their computer.

I need a way to replace the content of my online sql database with the updated version from the computer, preferably using Windows Command Line. How can I do this?

why can't the person manage the online database from their computer ? wiping the content of a public online database is always sensitive and can generate request failures. — Justin T.
– Justin T., Commented May 23, 2012 at 16:18
We have a batch program running on that local computer/database already which converts the info into several PDFs and other assets. The command line I'm looking for will simply be added to the already existing program which is run every week. — Philip Kirkbride
– Philip Kirkbride, Commented May 23, 2012 at 16:33

Dan Armstrong · Accepted Answer · 2012-05-23 17:08:53Z

2

You could use the mysql utilities to do this. mysqldump will create a backup of the updated database and then you can feed that into your online database using the mysql utility.

C:>mysqldump -uUSER -pPASSWORD DATABASE > database.sql
C:>mysql -hHOST -pPORT -uUSER -pPASSWORD DATABASE < database.sql

answered May 23, 2012 at 17:08

Dan Armstrong

2,10616 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Update online MySQL with local computer SQL via Command Prompt?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related