Skip to content

倪之帅 Victor 个人主页

  • Home
  • Tech
    • Linux
    • LNMP
    • Mac
    • Mobile
    • Products
    • SMS
  • My Music
June 13, 2018 / Linux

Mysql database Export and Import

Mysql export

mysqldump -u root -pxxxxx --all-databases > mysql.sql
mysqldump -u root -pxxxxx --databases db1 db2 db3 > wellcome2015.sql

Mysql import

mysql -u root -pxxxxx --all-databases < mysql.sql

Post navigation

Previous Post:

How to install Samba server on CentOS 7

Next Post:

Check cron log

Leave a Reply Cancel reply

You must be logged in to post a comment.

Categories

  • Linux
  • LNMP
  • Mac
  • Mobile
  • PHP
  • Products
  • SMS
  • Uncategorized
  • VPS
  • 原创
  • 技术

Recent Posts

  • PHP代码http跳转到https
  • 宝塔php 7.2 安装 mcrypt 扩展
  • 9 Best Free FTP Server Software
  • Mysql database copy command
  • Updating CMake from 2.8.11 to 3.6.2 or Newer Version on CentOS Linux

Archives

  • June 2019
  • October 2018
  • May 2018
  • April 2018
  • March 2018
  • July 2016
  • June 2016
  • April 2016
  • November 2015
  • October 2015
  • May 2015
  • April 2015
  • February 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • April 2014
  • June 2011
  • June 2010
  • May 2010
  • April 2010
  • May 2006
  • November 2005
  • December 2004
  • June 2004
  • March 2003
  • October 2002
  • January 2001
  • March 2000
© 2019 倪之帅 Victor 个人主页