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
3,058
Sonwebhost
Bryan McClure
CentOS Web Panel vs Vestacp, Which one is better?
Replies
15
Views
12,752
radwebhosting
DenisMNE
Railgun cloudflare
Replies
2
Views
3,313
Kaz Wolfe
TheGodfather
Rackspace vs Cloudflare
Replies
2
Views
2,292
Edward
lorang
Hi there!
Replies
2
Views
1,403
David Beroff
Newer Threads
BillEssley
How to extract files and create archives via SSH
Replies
3
Views
1,990
BillEssley
TheGodfather
VPS with GPU?
Replies
8
Views
5,517
Gmeister4
natzzzzz1
How to create a website?
Replies
14
Views
3,758
technbyte
TheGodfather
How to add Piwik/Matomo to Cloudflare ?
Replies
6
Views
5,845
djsmiley2k
TheGodfather
Block certain countries on Cloudflare
Replies
1
Views
2,408
AlbaHost
Latest Threads
R
How much bandwidth is enough for a growing website?
Replies
1
Views
24
FerdieQO
J
How does Jtti Server Defend against DDoS attacks?
Replies
0
Views
176
jtti
J
What are the performance differences between DNS load Balancing and reverse proxy?
Replies
1
Views
154
FerdieQO
hostiko
What Features Do You Value Most in a Hosting Provider?
Replies
1
Views
37
FerdieQO
GreenhostCloud
Free vs. Paid Hosting: Is It Worth It?
Replies
2
Views
81
FerdieQO
Recommended Threads
Marc0
Ways To Make Money On Facebook?
Replies
13
Views
6,559
jayjacobs
leen12
Hi newbie
Replies
3
Views
3,146
Shole
MilesWeb
[MilesWeb] Save 20% on KVM Based Managed VPS | Free Migration | Starts at $12/mo
Replies
0
Views
1,249
MilesWeb
MilesWeb
OFFER [MilesWeb] Unlimited cPanel Hosting | Free Domain | Free SSL | 20% OFF | Buy Now
Replies
0
Views
1,973
MilesWeb
freds86
Relationship Marketing or Affiliate?
Replies
2
Views
3,249
blueclcl
Similar Threads
techteacherdebashree
It is impossible to change rank math plugin. what can I do?
Replies
0
Views
969
techteacherdebashree
T
Is backup to a different server using cPanel is possible?
Replies
9
Views
2,784
sam@12
T
Is backup to a different server using cPanel is possible?
Replies
5
Views
1,939
tranzservrsupprtz
A
Is it possible to install cPanel on Centos8 server?
Replies
4
Views
3,278
infotech
P
Is it possible to secure wordpress website 100%?
2
Replies
21
Views
5,305
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