Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎµ¼Èëµ¼³öMySQLÊý¾Ý¿â *.sqlÎļþ²Ù×÷

 
1. ¸ÅÊö
MySQLÊý¾Ý¿âµÄµ¼È룬ÓÐÁ½ÖÖ·½·¨£º
1) Ïȵ¼³öÊý¾Ý¿âSQL½Å±¾£¬ÔÙµ¼È룻
2) Ö±½Ó¿½±´Êý¾Ý¿âĿ¼ºÍÎļþ¡£
ÔÚ²»Í¬²Ù×÷ϵͳ»òMySQL°æ±¾Çé¿öÏ£¬Ö±½Ó¿½±´ÎļþµÄ·½·¨¿ÉÄÜ»áÓв»¼æÈݵÄÇé¿ö·¢Éú¡£
ËùÒÔÒ»°ãÍÆ¼öÓÃSQL½Å±¾ÐÎʽµ¼Èë¡£ÏÂÃæ·Ö±ð½éÉÜÁ½ÖÖ·½·¨¡£
Linux주
2. ·½·¨Ò» SQL½Å±¾ÐÎʽ
²Ù×÷²½ÖèÈçÏ£º
2.1. µ¼³öSQL½Å±¾
ÔÚÔ­Êý¾Ý¿â·þÎñÆ÷ÉÏ£¬¿ÉÒÔÓÃphpMyAdmin¹¤¾ß£¬»òÕßmysqldump(mysqldumpÃüÁîλÓÚmysql/bin/Ŀ¼ÖÐ)ÃüÁîÐУ¬µ¼³öSQL½Å±¾¡£
2.1.1 ÓÃphpMyAdmin¹¤¾ß
µ¼³öÑ¡ÏîÖУ¬Ñ¡Ôñµ¼³ö“½á¹¹”ºÍ“Êý¾Ý”£¬²»ÒªÌí¼Ó“DROP DATABASE”ºÍ“DROP TABLE”Ñ¡Ïî¡£
Ñ¡ÖГÁí´æÎªÎļþ”Ñ¡ÏÈç¹ûÊý¾Ý±È½Ï¶à£¬¿ÉÒÔÑ¡ÖГgzipped”Ñ¡Ïî¡£
½«µ¼³öµÄSQLÎļþ±£´æÏÂÀ´¡£
2.1.2 ÓÃmysqldumpÃüÁîÐÐ
ÃüÁî¸ñʽ
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
·¶Àý£º
mysqldump -uroot -p abc > abc.sql
£¨µ¼³öÊý¾Ý¿âabcµ½abc.sqlÎļþ£©
ÌáʾÊäÈëÃÜÂëʱ£¬ÊäÈë¸ÃÊý¾Ý¿âÓû§ÃûµÄÃÜÂë¡£
2.2. ´´½¨¿ÕµÄÊý¾Ý¿â
ͨ¹ýÖ÷¿Ø½çÃæ/¿ØÖÆÃæ°å£¬´´½¨Ò»¸öÊý¾Ý¿â¡£¼ÙÉèÊý¾Ý¿âÃûΪabc£¬Êý¾Ý¿âȫȨÓû§Îªabc_f¡£
2.3. ½«SQL½Å±¾µ¼ÈëÖ´ÐÐ
ͬÑùÊÇÁ½ÖÖ·½·¨£¬Ò»ÖÖÓÃphpMyAdmin£¨mysqlÊý¾Ý¿â¹ÜÀí£©¹¤¾ß£¬»òÕßmysqlÃüÁîÐС£
2.3.1 ÓÃphpMyAdmin¹¤¾ß
´Ó¿ØÖÆÃæ°å£¬Ñ¡Ôñ´´½¨µÄ¿ÕÊý¾Ý¿â£¬µã“¹ÜÀ픣¬½øÈë¹ÜÀí¹¤¾ßÒ³Ãæ¡£
ÔÚ"SQL"²Ëµ¥ÖУ¬ä¯ÀÀÑ¡Ôñ¸Õ²Åµ¼³öµÄSQLÎļþ£¬µã»÷“Ö´ÐДÒÔÉÏÔØ²¢Ö´ÐС£
×¢Ò⣺phpMyAdmin¶ÔÉÏÔØµÄÎļþ´óСÓÐÏÞÖÆ£¬php±¾Éí¶ÔÉÏÔØÎļþ´óСҲÓÐÏÞÖÆ£¬Èç¹ûԭʼsqlÎļþ
±È½Ï´ó£¬¿ÉÒÔÏÈÓÃgzip¶ÔËü½øÐÐѹËõ£¬¶ÔÓÚsqlÎļþÕâÑùµÄÎı¾Îļþ£¬¿É»ñµÃ1:5»ò¸ü¸ßµÄѹËõÂÊ¡£
gzipʹÓ÷½·¨£º
# gzip xxxxx.sql
µÃµ½
xxxxx.sql.gzÎļþ¡£
2.3.2 ÓÃmysqlÃüÁîÐÐ
ÃüÁî¸ñʽ
mysql -uÓû§Ãû -p Êý¾Ý¿âÃû < Êý¾Ý¿âÃû.sql
·¶Àý£º
mysql -uabc_f -p abc < abc.sql
£¨µ¼ÈëÊý¾Ý¿âabc´Óabc.sqlÎļþ£©
ÌáʾÊäÈëÃÜÂëʱ£¬ÊäÈë¸ÃÊý¾Ý¿âÓû§ÃûµÄÃÜÂë¡£
3 ·½·¨¶þ Ö±½Ó¿½±´
Èç¹ûÊý¾Ý¿â±È½Ï´ó£¬¿ÉÒÔ¿¼ÂÇÓÃÖ±½Ó¿½±´µÄ·½·¨£¬µ«²»Í¬°æ±¾ºÍ²Ù×÷ϵͳ֮¼ä¿ÉÄܲ»¼æÈÝ£¬ÒªÉ÷Óá£
3.1 ×¼±¸Ô­Ê¼Îļþ
ÓÃtar´ò°üΪһ¸öÎļþ
3.2 ´´½¨¿ÕÊý¾Ý¿â
3.3 ½âѹ
ÔÚÁÙʱĿ¼Öнâѹ£¬È磺
cd /tmp
tar zxf mydb.tar.gz
3.4 ¿½±´
½«½âѹºóµÄÊý¾Ý¿âÎļþ¿½±´µ½Ïà¹ØÄ¿Â¼
cd myd


Ïà¹ØÎĵµ£º

¹ØÓÚSQLµÄ×óÓÒÁ¬½Ó²éѯ

Ò»Ö±ÒÔÀ´¶ÔÓÚSQLµÄ²éѯ¶¼Ã»ÔõôÔÚÒ⣬½ñÌìÓöµ½Ò»¸ö¹ØÓÚ×óÁ¬½Ó²éѯµÄÎÊÌâ¡£
Select  uId ,uName,dpName
from users
left join dpart
on  users.pid=1 where u.pid=dpart.pid
½á¹ûÊǰÑusersËùÓнá¹û²éѯ³öÀ´£¬¶ø²»ÊÇpidΪ1µÄÓû§
Ô­À´onºóÃæ±ØÐë·ÅÁ¬½ÓÌõ¼þ£¬ÆäËûµÄÌõ¼þ·ÅÔÚwhereÀïÃæ
¸ÐлÏÄ»¶Ìá³ö ......

UbuntuÏÂÅäÖÃLAMP£¨Linux+Apache+Mysql+PHP)»·¾³

ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾ­ÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²Å̰²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......

mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ

mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ
ÎÄÕ·ÖÀà:Êý¾Ý¿â
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
 
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£ ......

ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶

ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶
ÎÒ°²×°µÄÕâ¸ö°æ±¾µÄMYSQLûÓÐdataÎļþ¼Ð£¬µ«ÊÇ¿ÉÒÔÕý³£Ê¹Ó㬲»ÖªµÀÄãÃǵÄÓÐûÓÐÄØ£¿Ôõô²Å¿ÉÒÔ³öÏÖdataÎļþ¼ÐÄØ£¬Ã»ÓÐdataÎļþ¼Ð£¬ÄÇÎÒµÄÊý¾Ý¿âÎļþ´æ·ÅÔÚʲôµØ·½ÁËÄØ£¿ÎÒËÑË÷ÁËÕû¸öµçÄÔ¶¼Ã»ÓÐÕÒµ½¡£
ºÃÐĵÄÅóÓÑ£¬¿ì¸æËßÎÒÔõô»ØÊ£¿¸ÃÔõô½â¾ö£¿
ллÁË£¡£¡£¡
====================== ......

Mysql¼¯ÈºÅäÖÃÎĵµ

¹ÜÀí½Úµã:192.168.50.211 Êý¾Ý½Úµã: 192.168.50.214 Êý¾Ý½Úµã: 192.168.50.215 SQL½Úµã: 192.168.50.212 SQL½Úµã: 192.168.50.213 ²Ù×÷ϵͳ:Red Hat Enterprise Linux AS release 5 ------------------------------------------°²×°Ç°±Ø¶Á---------------------------------------- µ±Ç°ÎĵµµÄ°æ±¾Îªmysql-cluster- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ