mysqlÃüÁî_»ù´¡
ÏÔʾmysql»ù±¾ÐÅÏ¢£ºmysql>status;
²é¿´±äÁ¿£ºshow variables like '%version%';
±¸·ÝÓ뻹ÔÃüÁÔÚ×îºó»¹ÓÐ
1.±¸·ÝMySQLÊý¾Ý¿âµÄÃüÁî:
ÔÚcmdÖнøÈëµ½mysqlµÄlibĿ¼ÏÂÖ´ÐÐÈçÏ£º
mysqldump -hhostname -uusername -ppassword databaseName > backupfile.sql
Àý£ºmysqldump -hlocalhost -uroot -p123456 test > test.sql
2.µ¼³öÒ»¸ö±í£º
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -u root -p dataname users> dataname_users.sql
»¹ÔMySQLÊý¾Ý¿âµÄÃüÁ
Ê×ÏÈн¨Ò»¸öÊý¾Ý¿â£ºcreate database Êý¾Ý¿â;
È»ºó½øÈëÊý¾Ý¿â£ºuse Êý¾Ý¿âÃû;
È»ºóÖ´ÐÐsql½Å±¾£ºmysql>source d:\aaa.sql;
Íê³É
°ïÖúÃüÁ½øÈëlibĿ¼ÏÂmysqldump -help
×¢£ºÈç¹ûÅäÖÃÁË»·¾³±äÁ¿¾Í²»ÓýøÈëlibϾͿÉÒÔÖ±½ÓÔËÐÐ
Á¬½ÓMySQL
ÏÈÖ´ÐÐmysql°²×°Ä¿Â¼ÏµÄmysqld.exeÆô¶¯·þÎñ
½øÈëMySQL¹ÜÀí½çÃæ
mysql -h localhost -u root -p
-h Ö÷»úÃû -uÓû§Ãû -p ÃÜÂë
ÐÞ¸ÄÃÜÂë¡£
¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
mysqladmin -u root -password ab12
×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
ÔÙ½«rootµÄÃÜÂë¸ÄΪ123456¡£
ÏÔʾËùÓÐÊý¾Ý¿â
show databases;
½¨Á¢Ò»¸öпâ
create database new;
drop database if exists school; //Èç¹û´æÔÚSCHOOLÔòɾ³ý
ʹÓÃÕâ¸öÊý¾Ý¿â
use new;
½¨Á¢Ð±í
create table app_user(
username varchar(20),
password varchar(255),
primary key(username));
ÏÔʾ±í½á¹¹
describe app_user;/desc app_user;
ÏÔʾËùÓбí
show tables;
²åÈë²âÊÔÊý¾Ý
insert into app_user values('tomcat' , '123');
insert into app_user values('yeeku' , '123');
Í˳öMySQL¹ÜÀí½çÃæ
exit/quit;
Ïà¹ØÎĵµ£º
ÎȹʶøÖªÐ£¬×î½üÓÖÓõ½ÁË£¬²Ý²ÝÄÃÀ´ÎÂϰһÏ£º×ª×Ô http://www.bccn.net/Article/sjk/mysql/jc/200601/3411.html
MySQL¹ÜÀíÔ±Ó¦¸ÃÖªµÀÈçºÎÉèÖÃMySQLÓû§Õ˺ţ¬Ö¸³öÄĸöÓû§¿ÉÒÔÁ¬½Ó·þÎñÆ÷£¬´ÓÄÄÀïÁ¬½Ó£¬Á¬½ÓºóÄÜ×öʲô¡£MySQL
3.22.11¿ªÊ¼ÒýÈëÁ½ÌõÓï¾äʹµÃÕâÏ×÷¸üÈÝÒ××ö£ºGRANTÓï¾ä´´½¨MySQLÓû§²¢Ö¸¶¨ÆäȨÏÞ£¬¶øREV ......
ÈçºÎµ¼Èë.sqlÎļþµ½mysqlÖУ¿
C:\mysql\bin>mysql -u Óû§Ãû -p Êý¾Ý¿âÃû < c:/test.sql (source "c:\adsense.sql" )
ÖмäµÄ¿Õ¸ñÊÇÒ»¸ö¿Õ¸ñλ¡£
ͬʱʹÓÃ200¶àMBµÄsqlÎļþ¡£
ÀýÈ磺
C:\Program Files\MySQL\bin>mysql -u root -p myrosz & ......
Ê×ÏÈ·ÖÎöÂÒÂëµÄÇé¿ö
1.дÈëÊý¾Ý¿âʱ×÷ΪÂÒÂëдÈë
2.²éѯ½á¹ûÒÔÂÒÂë·µ»Ø
¾¿¾¹ÔÚ·¢ÉúÂÒÂëʱÊÇÄÄÒ»ÖÖÇé¿öÄØ£¿
ÎÒÃÇÏÈÔÚmysql ÃüÁîÐÐÏÂÊäÈë
show variables like '%char%';
²é¿´mysql ×Ö·û¼¯ÉèÖÃÇé¿ö:
mysql> show variables like '%char%';
+--------------------------+---------------------------------------- ......
¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
¡¡¡¡3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
¡ ......