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

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¡£
 
 
 
 
 


Ïà¹ØÎĵµ£º

.\mysql\user is marked as crashed ½â¾ö°ì·¨

 
I found a solution to anyone else who may be having this problem.
First start mysql using skip grant tables
root@ns1 [/var/lib/mysql/mysql]# service mysql start --skip-grant-tables
Starting MySQL [ OK ]
now with mysql started, you can repair the mysql/user table
root@ns1 [/var/lib/mysql ......

mysqliÓëmysqlÇø±ð

 mysqlÊǷdzּÌÁ¬½Óº¯Êý¶ømysqliÊÇÓÀÔ¶Á¬½Óº¯Êý¡£Ò²¾ÍÊÇ˵
mysqlÿ´ÎÁ´½Ó¶¼»á´ò¿ªÒ»¸öÁ¬½ÓµÄ½ø³Ì¶ømysqli¶à´ÎÔËÐÐmysqli½«Ê¹ÓÃͬһÁ¬½Ó½ø³Ì,´Ó¶ø¼õÉÙÁË·þÎñÆ÷µÄ¿ªÏú
ÓÐЩÅóÓÑÔÚ±à³ÌµÄʱºò£¬Ê¹ÓÃnew mysqli('localhost', usenamer', 'password', 'databasename');×ÜÊDZ¨´í£¬Fatal error: Class 'mysqli' not found in ......

MySQLÊý¾Ý¿âÖеÄShowÃüÁî¾ßÌåÓ÷¨

 MySQLÖÐÓкܶàµÄ»ù±¾ÃüÁshowÃüÁîÒ²ÊÇÆäÖÐÖ®Ò»£¬ÔںܶàʹÓÃÕßÖжÔshowÃüÁîµÄʹÓû¹ÈÝÒײúÉú»ìÏý£¬±¾ÎĻ㼯ÁËshowÃüÁîµÄÖÚ¶àÓ÷¨¡£
a. show tables»òshow tables from database_name; -- ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ¡£
b. show databases; -- ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ¡£
c. show columns from table_nam ......

Ô¶³ÌÁ¬½Ómysql

½â¾ö·½·¨(ת)£º---µ«Ö´ÐеÚÒ»Öְ취ʱ³öÏÖ´íÎ󣬵ڶþÖÖ°ì·¨³É¹¦
1¡£¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
mysql -u root -pvmwaremysql>use mysql;mysql>update use ......

ÖØа²×°mysqlµÄÐĵÃ

Ôø¾­Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾­Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈжÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ