umarzuki 78 Report post Posted April 28, 2010 tadi aku cuba import dari database mysql 3 (RHEL 3) ke mysql 5 (CentOS 5) apa aku dah buat, dump database: # mysqldump mambo > mambo.sql aku scp ke server centos 5 lepas tu cuba import # mysql < mambo.sql keluar pulak error 1064 (sql syntax error). Bila aku tanya kat channel #mysql, ada cakap kena buat ikut urutan (mysql 3 -> mysql 4 -> mysql 5) selain dari cara tu? nak kena install mysql-server 4 pulak... Quote Share this post Link to post Share on other sites
FryShadow 90 Report post Posted April 29, 2010 syntax error rasa command tu ada salah kot. dah cuba [code] shell> mysql -u username -pPassword [databasemysql5] < [databasemysql3.sql] [/code] p/s:topik ni yang ke 5 di google search engine dengan keyword "import mysql 3 to mysql 5" Quote Share this post Link to post Share on other sites
umarzuki 78 Report post Posted April 29, 2010 [quote name='FryShadow' date='29 April 2010 - 09:47 AM' timestamp='1272505649' post='1028137'] syntax error rasa command tu ada salah kot. dah cuba [code] shell> mysql -u username -pPassword [databasemysql5] < [databasemysql3.sql] [/code] p/s:topik ni yang ke 5 di google search engine dengan keyword "import mysql 3 to mysql 5" [/quote] terima kasih sebab reply. dah cuba, sama juga kalau tak mesti error pasal authentication. Quote Share this post Link to post Share on other sites
umarzuki 78 Report post Posted April 29, 2010 (edited) [quote name='umarzuki' date='29 April 2010 - 10:02 AM' timestamp='1272506558' post='1028142'] terima kasih sebab reply. dah cuba, sama juga kalau tak mesti error pasal authentication. [/quote] setel... [list=1] [*]matikan mysqld kat server rhel 3 [*]tar datadir mysql (default kat /var/lib/mysql) [*]scp ke server centos 5 [*]matikan mysqld kat server centos 5 [*]untar fail tadi ke / [*]mulakan mysqld kat server centos 5 [/list] Edited April 29, 2010 by umarzuki Quote Share this post Link to post Share on other sites