Skip to content

倪之帅 Victor 个人主页

  • Home
  • Tech
    • Linux
    • LNMP
    • Mac
    • Mobile
    • Products
    • SMS
  • 英语学习
May 16, 2018 / Linux

Mysql database copy command

Create database

mysql -uroot -p
CREATE DATABASE `newdb` DEFAULT CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;

Copy database

mysqldump db1 -u root -p123456 --add-drop-table | mysql newdb -u root -p123456

If different server

mysqldump db1 -uroot -p123456 --add-drop-table | mysql -h 192.168.1.22 newdb -u root -p123456

Post navigation

Previous Post:

Updating CMake from 2.8.11 to 3.6.2 or Newer Version on CentOS Linux

Next Post:

9 Best Free FTP Server Software

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

  • composer切换源_composer全局更换镜像源的教程
  • 宝塔终端切换root用户为www
  • 五年级 单词 Unit 1
  • 五年级 单词 Unit 2
  • 五年级 单词 Unit 3

Archives

  • October 2022
  • September 2022
  • August 2022
  • June 2020
  • 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
  • January 2001
  • March 2000
© 2000-2023 倪之帅 Victor 个人主页