Mysqldump

From ElectroDragon
Revision as of 13:14, 7 May 2020 by Chao (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

export

  • mysqldump -u root -p RUNOOB runoob_tbl > dump.txt
  • mysqldump -u root -p8561312 control |gzip > control.sql.gz

import by mysql command line

  • create database XXX;
  • use XXX;
  • source BBB.txt