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, ......
¡¡±àÒëºÍÁ¬½Ó³ÌÐò
¡¡¡¡MySQLÖÐÓÐÒ»¸öÌØÊâµÄ½Å±¾,½Ð×ömysql_config. Ëü»áΪÄã±àÒëMySQL¿Í»§¶Ë,²¢Á¬½Óµ½MySQL·þÎñÆ÷ÌṩÓÐÓõÄÐÅÏ¢.ÄãÐèҪʹÓÃÏÂÃæÁ½¸öÑ¡Ïî.
¡¡¡¡1. --libs Ñ¡Ïî - Á¬½ÓMySQL¿Í»§¶Ëº¯Êý¿âËùÐèÒªµÄ¿âºÍÑ¡Ïî.
¡¡¡¡$ mysql_config --libs
¡¡¡¡2. --cflags Ñ¡Ïî - ʹÓñØÒªµÄincludeÎļþµÄÑ¡ÏîµÈµÈ.
......
½â¾ö·½·¨(ת)£º---µ«Ö´ÐеÚÒ»Öְ취ʱ³öÏÖ´íÎ󣬵ڶþÖÖ°ì·¨³É¹¦
1¡£¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -pvmwaremysql>use mysql;mysql>update use ......
Ôø¾Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈÐ¶ÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......