Skip to content
  • Wed. Jan 27th, 2021

WIRED GORILLA

monkey business for the geek in you

  • Techno Babble
    • Resources
  • cPanel
  • System Administration
    • Cloud Cluster Computing
    • Fedora
    • Linux
    • MySQL
  • Security
  • SEO
    • Google
  • Web Design
    • WordPress
  • Advertising on WiredGorilla
Linux MySQL Techno Babble

Moving mySQL DBs between servers

ByWeb Monkey

Mar 27, 2009

Moving mySQL DBs from one server to another:

mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql

puts the entire thing in one nicely portable text file.

on a new server it takes

mysql -uUSER -pPASSWORD txp_database < txp_database.sql

to import it.

Post navigation

Linux Cron Jobs Explained
Turbo charging MySQL by setting up the query cache

By Web Monkey

Related Post

Linux

Movim: An Open-Source Decentralized Social Platform Based on XMPP Network

Jan 25, 2021 Web Monkey
Linux

How to Install and Use Fail2ban on RHEL 8 / CentOS 8

Jan 25, 2021 Web Monkey
Linux

Managing Your Greatest Asset – People

Jan 23, 2021 Web Monkey
Recent Posts
  • Where Two-Factor Authentication Falls Short
  • Building Single-Page Websites on WordPress.com
  • How to plan an SEO campaign for higher rankings
  • Movim: An Open-Source Decentralized Social Platform Based on XMPP Network
  • How to Install and Use Fail2ban on RHEL 8 / CentOS 8
Advertise on WiredGorilla
Categories
  • Cloud Cluster Computing
  • cPanel – WHM
  • Design
  • Fedora
  • Google
  • Linux
  • MySQL
  • Resources
  • Security
  • SEO Talk
  • Techno Babble
  • Web Design
  • WordPress
Get a Wordpress Website!
blank
RSS FASTDOT News
  • Quick Fix – Microsoft Teams Not Loading on MacOS Big Sur
  • WordPress Hooks: The Essential Guide
  • 5 Multichannel Marketing Strategies to Scale Your eCommerce Business
Archive

You missed

Web Design

Where Two-Factor Authentication Falls Short

Jan 26, 2021 Web Monkey
Design WordPress

Building Single-Page Websites on WordPress.com

Jan 26, 2021 Web Monkey
WordPress

How to plan an SEO campaign for higher rankings

Jan 25, 2021 Web Monkey
Linux

Movim: An Open-Source Decentralized Social Platform Based on XMPP Network

Jan 25, 2021 Web Monkey
Legals
  • Advertising on WiredGorilla
  • DMCA – Legal
  • Privacy Policy – Legals

WIRED GORILLA

monkey business for the geek in you

Proudly powered by FASTDOT WordPress Hosting | Designed by Fastdot Digital.

  • Techno Babble
    • Resources
  • cPanel
  • System Administration
    • Cloud Cluster Computing
    • Fedora
    • Linux
    • MySQL
  • Security
  • SEO
    • Google
  • Web Design
    • WordPress
  • Advertising on WiredGorilla