Mysql的备份

电工技师

有谁能告诉我Mysql不用其它工具的情况下，怎么备份和还原
写出sql语句就可以了

pipi2009

--连库
c:\>mysql -u root -padmin
c:\>mysql -u root -padmin mydb
--创建一个超级用户
mysql>GRANT ALL PRIVILEGES ON *.* TO 'tea'@'localhost' IDENTIFIED BY '123' WITH GRANT OPTION;
--限定用户的权限及数据库
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON 数据库名.* TO 'tea'@'localhost' IDENTIFIED BY '123';
--删除用户
drop user tea@localhost;
--存储过程
mysql> delimiter //
mysql> CREATE PROCEDURE stu_add (n int,m varchar(10))
-> begin
-> insert stu(num,name) values(n,m);
-> end
-> //
mysql> CREATE PROCEDURE stu_sel (n int,out m varchar(10))
-> begin
-> select name into m from stu where num=n;
-> end
-> //
--删除存储过程
drop PROCEDURE 过程名
--数据库备份
mysqldump -h 127.0.0.1 -u root -padmin mydb > c:/mydb
--数据库还原
建库：mydb
c:/>mysql -h 127.0.0.1 -u root -padmin mydb  start transaction;
-> savepoint s1;
-> delete from ta;
-> savepoint s2;
-> delete from tb;
-> rollback to savepoint s2;
-> commit;
-> //
个人总结非常经典,最实用的mysql语句