Is it possible to export a Mysql database via SSH?

Gmeister4

Gmeister4

Well-known member
Registered
Joined
Apr 19, 2016
Messages
178
Points
18
How can I export a Mysql database via SSH? I have too many my website databases and it consumed me more time when exporting databases from Phpmyadmin. I would like to know a way to export faster and download databases to my PC . Thanks in advance.
 
AlbaHost

AlbaHost

Well-known member
Moderator
Hosting Provider
Joined
Jan 18, 2017
Messages
809
Points
43
Gmeister4 said:
How can I export a Mysql database via SSH? I have too many my website databases and it consumed me more time when exporting databases from Phpmyadmin. I would like to know a way to export faster and download databases to my PC . Thanks in advance.
Click to expand...
Google do magic, just need to use it:

mysqldump --all-databases > all_databases.sql

and then download it.
 
Gmeister4

Gmeister4

Well-known member
Registered
Joined
Apr 19, 2016
Messages
178
Points
18
Gmeister4
I am checking on this.
Can I download specific databases as wanted? and where databases will be dumped to?
To run the command above, do I need to login into Mysql server first?
 
AlbaHost

AlbaHost

Well-known member
Moderator
Hosting Provider
Joined
Jan 18, 2017
Messages
809
Points
43
AlbaHost
For one database:

mysqldump database_name > database_name.sql

For multiple databases at the same time:

mysqldump --databases database_one database_two > two_databases.sql

And for all databases i just posted in my previous post, you need login to your ssh as root and after you run mentioned commands your backup will be in same directory where you are.
 
Gmeister4

Gmeister4

Well-known member
Registered
Joined
Apr 19, 2016
Messages
178
Points
18
Gmeister4
hmm....It will be stored in root folder :unsure:
You forget to guide me how to move database_one or database_two file to public_html on my domain so I can download them with a URL :)
 
AlbaHost

AlbaHost

Well-known member
Moderator
Hosting Provider
Joined
Jan 18, 2017
Messages
809
Points
43
AlbaHost
Yeah, wait for a little and i will do all the job for you for sure ;) you can login to your root with winscp or filezilla without moving them to public_html directory for security reasons.
Or if you don't mind for security, then just move with:
mv database.sql /home/username/public_html
 
Gmeister4

Gmeister4

Well-known member
Registered
Joined
Apr 19, 2016
Messages
178
Points
18
Gmeister4
Thanks for guiding me, I need to do this on my servers and see how it works.
Of course I will move them to public_html to easily download with a download program on Windows and I will remove database files after download by using rm filename.sql :)
 
AlbaHost

AlbaHost

Well-known member
Moderator
Hosting Provider
Joined
Jan 18, 2017
Messages
809
Points
43
AlbaHost
Don't be lazy with valued data, just use winscp or filezilla and download it on your pc, that's best solution.
 
Gmeister4

Gmeister4

Well-known member
Registered
Joined
Apr 19, 2016
Messages
178
Points
18
Gmeister4
I know and installed these programs but rarely use them because the speed of downloading is very slow if compared with some download programs from Windows as internet download manager, for example.
 
AlbaHost

AlbaHost

Well-known member
Moderator
Hosting Provider
Joined
Jan 18, 2017
Messages
809
Points
43
AlbaHost
Hell yeah, if your internet speed is slow, why do you think that it will faster downloading files directly from website?
 
Gmeister4

Gmeister4

Well-known member
Registered
Joined
Apr 19, 2016
Messages
178
Points
18
Gmeister4
Because those programs are design for purposes to download files from internet so they will be faster than filezilla or winscp or other FPT programs. I tried and always use them when download files from my websites.
 
AlbaHost

AlbaHost

Well-known member
Moderator
Hosting Provider
Joined
Jan 18, 2017
Messages
809
Points
43
AlbaHost
If you think so, then alright, just to let you know that winscp and filezilla were designed for such things too :)
 
You must log in or register to reply here.
Older Threads
Sonwebhost
Setting up a new dedicated server where to buy hardware
Replies
13
Views
2,975
Sonwebhost
Bryan McClure
CentOS Web Panel vs Vestacp, Which one is better?
Replies
15
Views
12,485
radwebhosting
DenisMNE
Railgun cloudflare
Replies
2
Views
3,232
Kaz Wolfe
TheGodfather
Rackspace vs Cloudflare
Replies
2
Views
2,222
Edward
lorang
Hi there!
Replies
2
Views
1,378
David Beroff
Newer Threads
BillEssley
How to extract files and create archives via SSH
Replies
3
Views
1,946
BillEssley
TheGodfather
VPS with GPU?
Replies
8
Views
5,397
Gmeister4
natzzzzz1
How to create a website?
Replies
14
Views
3,700
technbyte
TheGodfather
How to add Piwik/Matomo to Cloudflare ?
Replies
6
Views
5,673
djsmiley2k
TheGodfather
Block certain countries on Cloudflare
Replies
1
Views
2,332
AlbaHost
Latest Threads
josephilip
Welcome to ServerMO: Excellence in Dedicated Server Hosting
Replies
0
Views
1
josephilip
cancan
Save an incredible 90% off! The Best HostPapa Deal so Far: Unlimited SSL, 50 GB NVMe, 24/7 support
Replies
0
Views
27
cancan
M
How to Choose the Best Web Hosting Provider for a New Website ??
Replies
1
Views
28
BlueLeaf
J
Jtti: What are some common misconceptions about firewall rules?
Replies
0
Views
125
jtti
Mvv758
Hello
Replies
1
Views
79
AlbaHost
Recommended Threads
hmsnaveen95
How to find of Quality Score of PPC ad?
Replies
9
Views
2,841
vijaykl32
jaztez
I would Love Feedback On My New Site Content Marketplace
Replies
4
Views
2,770
Developer
Marc0
6 useful plugins to optimize images in WP
Replies
2
Views
2,601
metataggvp
Marc0
Import Blogger to Facebook
Replies
5
Views
3,154
EllaOwsley
iSocialMarketing
9 Killer Tips to Optimize Your Videos for YouTube and Google
Replies
3
Views
27,304
elcidofaguy
Similar Threads
techteacherdebashree
It is impossible to change rank math plugin. what can I do?
Replies
0
Views
935
techteacherdebashree
T
Is backup to a different server using cPanel is possible?
Replies
9
Views
2,722
sam@12
T
Is backup to a different server using cPanel is possible?
Replies
5
Views
1,895
tranzservrsupprtz
A
Is it possible to install cPanel on Centos8 server?
Replies
4
Views
3,204
infotech
P
Is it possible to secure wordpress website 100%?
2
Replies
21
Views
5,192
Elliot Martin

Latest postsNew threads

Latest Hosting OffersNew Reviews

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
  • cpanel
  • dedicated
  • free
  • hello
  • hosting
  • hosting services
  • marketing
  • offers
  • seo
  • server
  • services
  • vps
  • web
  • web hosting
  • website
  • wordpress
    • Top