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

linux mysql±¸·ÝÎÊÌâ

mysql±¸·ÝµÄʱºò£¬Ö´ÐÐmysqldump -u test -p test>/test.sql

±¨´íAccess denied for user 'test'@'localhost' ¡£¡£¡£¡£¡£¡£

ÔÚÍøÉϲéÁ˺óÃæÒª¼Ó--skip-lock-tables²Å¿ÉÒÔ£¬ÇëÎÊ--skip-lock-tablesÊÇʲôÒâ˼£¬

»á²»»á¶ÔÊý¾Ý¿â²åÈëºÍ·ÃÎÊÔì³ÉÓ°Ï죬Èç¹ûÊÇËø±íµÄ»°£¬ÔõôÑù½âËø£¬Ð»Ð»»Ø´ð¡£
--skip-lock-tables Õâ¸öÓ¦¸ÃÊDz»Ëø±í°É

mysqldump -u xxx -p xxx --database yyy --skip-lock-tables>/tmp/xxx.sql

±¨´í£º

Access denied for  user 'xxx'@localhost (using password:YES) when  trying to connect

Ϊʲô»¹±¨´í°¡£¿


mysqldump -u test -ptest>/test.sql

-p ºóÃæ²»ÄÜÓпոñ¡£



Ïà¹ØÎÊ´ð£º

linux»·¾³ÏÂgethostbynameº¯ÊýÎÊÌâ - C/C++ / CÓïÑÔ

дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
   
  struct hostent *hp; 
char AlarmDevIP[20];  
  int x2;

hp = gethostbyname("www.google.com");
if (hp)
{ ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

linux×ÀÃæ½ø²»È¥ÁË£¬Ôõô°ì¡­¡­¡­¡­¡­¡­

ÔÚ×Ô¼ºµÄµçÄÔÉϰ²×°ÁËubuntu ¾ÍÊÇÏëÍæÒ»ÏÂ3D×ÀÃæ£¬ÓÚÊÇÏÂÔØÁË 
compizconfig-settings-manager 
emerald 
simple-ccsm 
fusion 
ÕâЩ¶«Î÷£¬°²×°ÍêÖ®ºó£¬ÎÒÔÚµçÄÔÀïµã»÷ÁËemerald ......

¹ØÓÚMYSQLµÄinnodb±í±¸·ÝµÄÎÊÌâ

ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý

Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ