Mysqldump

From ElectroDragon Wiki
Revision as of 01:14, 8 May 2020 by Chao (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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