Getting a MySQL DB dump in local machine from server

Getting a DB dump in local machine from server..

Step1: Login into the server where mysql is hosted -
ssh username@server
Step 2: Take MySQL Dump
mysqldump dbname -u dbusername -p > filename.sql
Step 3: Logout
Logout of server
Step 4: from Local machine
scp username@server:server_path/filename.sql dumpfile.sql


The above steps can be done in 1 step.
mysqldump -h hostname -u dbusername -p dbname > filename.sql

Comments

Post a Comment

Popular posts from this blog

Install Cpanm module error : No such file or directory opening compressed index

I got this error while installing Rest client perl module $ HOME=/tmp /home/perl/5.10/bin/cpanm REST::Client ! Finding REST::Client on cpanmetadb failed. ! cannot open file '/tmp/.cpanm/sources/http%www.cpan.org/02packages.details.txt.gz': No such file or directory opening compressed index ! Couldn't find module or a distribution REST::Client Solution: The problem is because of "LWP::Protocol::https" module. Removing the directory worked for me. $ cd /perl_installed_path/perl/5.10/lib/site_perl/5.10.1 $ rm –rf LWP* or try with option "--no-lwp" cpanm REST::Client --no-lwp
Read more

How to increase Elasticsearch Shard recovery Speed

To Increase Shard recovery speed do this: Increase node recovery speed PUT http://es:9200/_cluster/settings { "persistent" : { "indices.recovery.max_bytes_per_sec": "200mb", "indices.recovery.max_concurrent_file_chunks": 5, "cluster.routing.allocation.node_concurrent_recoveries" : 5 } } Links: https://www.elastic.co/guide/en/elasticsearch/reference/current/shards-allocation.html https://www.elastic.co/guide/en/elasticsearch/reference/current/recovery.html
Read more

Getting started with Python Flask application with MVC structure

I have added a MVC structure and getting started with Python flask application in my Github.  I will continue to contribute to this repository with Database connections and JWT Authentication. Lets get started with Python and Flask :) Here is the Github link for my project. https://github.com/srikanthjeeva/python-flask-getting-started Structure your Flask application like a Rails Application. I'm a Rails developer. I like the way a Rails application is structured and I wanted to implement the similar kind of structure for a Python Flask web Application. Flask by default will not give you this structure. So make use of the getting started with Python flask repository above. The Code structure will look like this: python-flask-getting-started/ |-- app | |-- config.py | |-- controllers | | |-- hello_controller.py | | |-- __init__.py | |-- helpers | | |-- common_helpers.py | | |-- __init__.py | |-- __init__.py | |-- models | | ...
Read more