mysqlÊý¾Ý¿â±¸·ÝÓ뻹Ô
mysqlÊý¾Ý¿â±¸·ÝÓ뻹ÔÃüÁ
±¸·Ý£º
ÈçÎÒÃÇÐèÒª°Ñ Êý¾Ý¿âÃûΪ£ºshopping µÄÊý¾Ý¿â±¸·Ý£º Óû§ÃûΪ£ºroot£¬ÃÜÂëΪ£º12345£¬ÄÇôÃüÁîÈçÏ£º
Ö±½Ó½øÈëdos£¬Èç¹ûûÓÐÅäÖÃmysqlµÄ»·¾³±äÁ¿£¬ÄÇôÐèÒª°ÑdosµÄµ±Ç°Ä¿Â¼Çл»µ½mysqlµÄbinĿ¼Ï£¬È»ºóÇÃÈëÒ»ÏÂÃüÁ
mysqldump -uroot -p12345 shopping>e:/shopping.sql
Èç¹ûÊý¾Ý¿âûÓÐÃÜÂ룬ÄÇôֻÐ裺
mysqldump -uroot shopping>e:/shopping.sql
»¹Ô£º
°ÑÉÏÃæµÄshoppingÊý¾Ý¿â±¸·Ý»¹Ôµ½Êý¾Ý¿âÃûΪ£º shoppingBackµÄÊý¾Ý¿âÖУ¬
ÄÇôҪÇÃÈëÒ»ÏÂÃüÁ
µÚÒ»²½£¬½øÈëmysql¿Í»§¶Ë£º
mysql -uroot -p12345
µÚ¶þ²½£¬Ñ¡ÔñÊý¾Ý¿â£º
use shoppingBack
µÚÈý²½£¬»¹ÔÊý¾Ý£º
source E:/shopping.sql
ok£¬Õâ¸öʱºòÊý¾Ý¾ÍÒѾ»¹Ôµ½shoppingBackÕâ¸öÊý¾Ý¿âÖÐÁË
linuxÏÂÃüÁîÒ»Ñù£¬Ö»Ðè°Ñ±¸·ÝÎļþµÄ·¾¶¸ÄһϾÍokÁË£¡
Ïà¹ØÎĵµ£º
轉×Ô»¨開µÄµØ·½
mysqlÓÐÒ»¸ö¹¦ÄܾÍÊÇ¿ÉÒÔlogÏÂÀ´ÔËÐеıȽÏÂýµÄsqlÓï¾ä£¬Ä¬ÈÏÊÇûÓÐÕâ¸ölogµÄ£¬ÎªÁË¿ªÆôÕâ¸ö¹¦ÄÜ£¬ÒªÐÞ¸Ämy.cnf»òÕßÔÚmysqlÆô¶¯
µÄʱºò¼ÓÈëһЩ²ÎÊý¡£
Èç¹ûÔÚmy.cnfÀïÃæÐ޸ģ¬ÐèÔö¼ÓÈçϼ¸ÐÐ
long_query_time = 1
log-slow-queries
=
log-queries-not-using-indexes
long_query_t ......
ASPÁ¬½ÓMySQLÊý¾Ý¿âµÄ·½·¨
ASPµÈÓïÑÔÁ¬½ÓmysqlÊý¾Ý¿â£¬¿ÉÒÔͨ¹ý°²×°mysqlµÄODBCÇý¶¯£¬Í¨¹ýÅäÖÃODBCÊý¾ÝÔ´£¬Á¬½Ó²¢²Ù×÷Êý¾Ý¿â¡£
mysql odbc 3.51°æ
ÏÂÔصØÖ·:
http://dev.mysql.com/downloads/connector/odbc/3.51.html
£¼%
'²âÊÔ¶ÁÈ¡MySqlÊý¾Ý¿âµÄÄÚÈÝ
strconnection="driver={mysql odb ......
mysql´´½¨Êý¾Ý¿âsqlʵÀý
# MySQL-Front 3.2 (Build 2.10)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'latin1' ......
ת×Ô: http://www.phpweblog.net/lemon2maple/archive/2007/07/29/1397.html
mysqlµÄ³ö´í´úÂë±í£¬¸ù¾ÝmysqlµÄÍ·Îļþmysql/include/mysqld_error.hÕûÀí¶ø³É¡£´íÎóÖ®´¦£¬Çë´ó¼ÒÖ¸Õý¡£
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾ ......
##/etc/my.cnf:
# [mysql]
# default-character-set=utf8
# [mysqld]
# character-set-server=utf8
# collation-server=utf8_general_ci
# [client]
# default-character-set=utf8
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
# dump db
mysqldump -u dbuser -pdbpass --opt --skip-set-charset --defaul ......