MySQL Migration ToolkitµÄʹÓÃ
MySQL Migration ToolkitÊÇMySQL³öµÄÊý¾ÝÇ¨ÒÆ¹¤¾ß(ÊÊÓÃÓÚMySQL5.0»òÒÔÉÏ)£¬Ê¹Óò¢²»¸´ÔÓ£¬Ö§³ÖOracle,Microsoft SQL Server,Microsoft Access,Sybase,MaxDBµ½MySQLÖ®¼äµÄת»»¡£ÒÔÏÂʵÀýÊÇOracleµ½MySQLµÄ¡£
1. °²×°jdk1.6
×°ÍêMySQL Migration Toolkit»¹Ðè°²×°jdk1.6£¬ÐèÒªjre1.5.0.8ÒÔÉϵÄÖ§³Ö¡£
2. ÔËÐÐMySQL Migration Toolkit
µã»÷“¿ªÊ¼”£“³ÌÐò”£“MySQL”£“MySQL Migration Toolkit”£¬ÔËÐÐMySQL Migration Toolkit¡£µã»÷“Next”
3. Ñ¡Ôñ“Direct Migration”£¬µã»÷“Next”
µÚÒ»´ÎÔËÐУ¬»á¸æËßÄãOracleµÄJDBC Driverδ¼ÓÔØ£¬ÏȼÓÔØojdbc14.jar¼´¿É¡£
4. ÔÚ“Source Database”ÖÐÌîдԴÊý¾Ý¿âµÄһЩ²ÎÊý
“Database System”ΪÊý¾Ý¿âϵͳÀàÐÍ£»
“Driver”ΪʹÓõÄÇý¶¯³ÌÐò£»
“Service”ΪԴÊý¾Ý¿âµÄ·þÎñÃû£»
“Hostname”ΪԴÊý¾Ý¿âÎļþµÄipºÍport£»
“Uesrname”ΪԴÊý¾Ý¿âµÄʹÓÃÓû§Ãû£»
“Password”ΪԴÊý¾Ý¿âʹÓÃÓû§ÃÜÂë¡£
5. ÔÚ“Target Database”ÖÐÌîдĿ±êÊý¾Ý¿âµÄһЩ²ÎÊý
“Database System”Êý¾Ý¿âϵͳÊÇMySQL Server£»
“Hostname”ΪÖ÷»úÃû³Æ£¬“Port”Ϊ¶Ë¿Ú£»
“Username”ΪÊý¾Ý¿âʹÓÃÕßÃû³Æ£»
“Password”ΪÊý¾Ý¿âʹÓÃÓû§ÃÜÂë¡£
6. Á½¸öÊý¾Ý¿âµÄ²ÎÊý¶¼ÌîдÍê³Éºó£¬ÏÂÃæÒ»²½¾ÍÊÇ·þÎñÆ÷µÄÁ¬½Ó
³öÏÖ“Execution completed successfully”¾Í˵Ã÷·þÎñÆ÷Á¬½Ó³É¹¦£¬Ö®ºóµã»÷“Next”¡£
7. Ñ¡ÔñҪת»»µÄÊý¾Ý¿â
Ñ¡ÔñÎÒÃÇÐèҪת»»µÄOracle Schema¡£
Ïà¹ØÎĵµ£º
ÐÞ¸Älinux·þÎñÆ÷µÄhttpÅäÖÃÖ®ºó£¬±ØÐëÖØÆôApache·þÎñ£¬ÃüÁîΪ£º /etc/rc.d/init.d/httpd restart
chown -R mysql:mysql Ŀ¼Ãû ¸Ä±äÎļþÊôÐÔ
mysqladmin -u root -p password 'new password' ÉèÖÃÃÜÂë
apt-get remove ɾ³ýÈí¼þ
apt-get clean ÇåÀí
/etc/rc.d/init.d/mysqld restart
php ¾ÍÅäÖÃÁËsession Ö÷ ......
PHPnow ÊÇʲô?
Win32 ÏÂÂÌÉ«Ãâ·ÑµÄ Apache + PHP + MySQL »·¾³Ì×¼þ°ü¡£
¼òÒ×°²×°¡¢¿ìËٴ֧³ÖÐéÄâÖ÷»úµÄ PHP »·¾³¡£¸½´ø PnCp.cmd ¿ØÖÆÃæ°å£¬°ïÖúÄã¿ìËÙÅäÖÃÄãµÄÌ×¼þ£¬Ê¹Ó÷dz£·½±ã¡£
PHPnow ÊÇÂÌÉ«µÄ£¬½âѹºóÖ´ÐÐ Init.cmd ³õʼ»¯£¬¼´¿ÉµÃµ½Ò»¸ö PHP + MySQL »·¾³¡£
È»ºó¾Í¿ÉÒÔÖ±½Ó°²×° Discuz!, PHPWind, ......
Explain MySQL architecture
. - The front layer
takes care of network connections and security authentications, the
middle layer does the SQL query parsing, and then the query is handled
off to the storage engine. A storage engine could be either a default
one supp ......
java£¨jsp)ʹÓÃMySqlÊý¾Ý¿â,ÖÐÎÄÂÒÂëµÄÍêÕû½â¾ö·½°¸
mysqlÊÇÒ»¸öСÐ͵ĿªÔ´µÄÊý¾Ý¿â£¬ÓÃÀ´×ÔѧһЩ¼¼ÊõÊÇÊ®·Ö·½±ãµÄ¡£µ«Ê¹ÓÃmysql´æ´¢Êý¾Ý£¬Ò²»áÓöµ½Ò»Ð©·Ç³£¶ñÐĵÄÎÊÌ⣬È磺ÖÐÎÄÂÒÂëÎÊÌâ¡¢javaÇý¶¯³ÌÐòÎÞ·¨Ê¹ÓõÄÎÊÌ⣨ÒѾ½â¾ö£¬Ïê¼û£ºhttp://hi.baidu.com/lauo1988/blog/item/ff0da655bd3e2eceb745ae0b.html)¡£
......
Ôø¾Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈÐ¶ÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......