Moving a MySQL Database To Another Server

Scott

Published: November 27, 2009Posted in: Syndicate GuidesTags: migration, mysql

Comments [0]

Here is a simple command line tip for moving a mysql database from one server to another.

 mysqldump  [mysqldump_options] |        gzip -c | ssh user@remotehost "gunzip -c > mysql  [mysql_options]"

Read more at Experimenting with GNU/Linux.

No Comments

Start the ball rolling by posting a comment on this article!

- Tag Cloud
- Latest
- Comments
- Featured
9.04 64bit adobe amarok apache browser clamav cli dansguardian debian Desktop firefox flash google jaunty karmic koala kde kubuntu lenny linux Microsoft mp3 music nagios open source Programming Python rdp Server squid sun terminal Tips and Tricks tutorial ubuntu ubuntu 9.04 Ubuntu Linux Video virtualbox virtual machine vlc vm vmware Windows xorg
- Google Public DNS – Speeding up your internet experience.
  03 December 2009 1:53 PM | No Comments
- Some wget tricks
  01 December 2009 8:46 AM | 1 Comment
- Moving a MySQL Database To Another Server
  27 November 2009 8:10 PM | No Comments
- Installing Google’s Go Language on Ubuntu
  12 November 2009 8:59 AM | No Comments
- Enhancing terminals with byobu on Ubuntu 9.10
  12 November 2009 1:37 AM | No Comments
- teak on Installing Adobe CS4 in Wine
- bookmarking demon tutorial on Install ClamAV on Ubuntu Linux
- Tony on Ubuntu 9.04 64bit Adobe Air Install
- aqquadro » Blog Archive » Installare Dreamweaver CS4 su GNULinux Debian “Lenny” grazie a WineHQ on Installing Adobe CS4 in Wine
- Me on Pandora | One Review
- Chris Allen Lane on Ubuntu 9.04 64bit Adobe Air Install
- Jor on Some wget tricks
- Tom on Nagios & Ubuntu 9.04 – Part 1
- Google Public DNS – Speeding up your internet experience.
  03 December 2009 1:53 PM | No Comments
- Some wget tricks
  01 December 2009 8:46 AM | 1 Comment
- Moving a MySQL Database To Another Server
  27 November 2009 8:10 PM | No Comments
- Installing Google’s Go Language on Ubuntu
  12 November 2009 8:59 AM | No Comments
- Enhancing terminals with byobu on Ubuntu 9.10
  12 November 2009 1:37 AM | No Comments
Login
Username:

Password:

Remember me
- Register
- Lost your password?

News & Anouncements
Translator

By N2H
Linux reddit
- Idea: Organize r/linux monthly "meetings" to contribute to a linux-related project March 12, 2010
- Download And Convert Youtube Videos: The Linux Way March 12, 2010
- What are your themes? March 12, 2010
- Ubuntu Server: The Linux OS Dark Horse March 11, 2010
- New software based 3D rendering now capable of running OpenArena March 11, 2010

Moving a MySQL Database To Another Server

No Comments

Leave a Reply

Login

News & Anouncements

Translator

Linux reddit

Archives

Contributors

Favorite Links

Copyright