I share example how to export database from command line, use mysql dump
A DB, then:
mysqldump -u [uname] -p db_name > db_bk.sql
Remote DB, then:
$ mysqldump -P 3306 -h [ip_address] -u [uname] -p db_name > db_bk.sql
In many enterprise systems, you may need to work with multiple databases — for example, customer data in PostgreSQL, legacy records in Oracl...
No comments:
Post a Comment