mysql 操作命令技巧

 

mysql数据库备份

1．C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -hlocalhost -uroot beingpo

wer> sql.sql

2．create database beingpower;

3．mysql> use beingpower;

Database changed

mysql> source sql.sql