Importing Mysql db (5 years ago) to today's Phpadmin

[rome2ng]

hihi guys..

i have a problem here and i seriously need help

I have a database that i use to create a site 5 years ago....
and i couldn't upload to today's phpadmin...

the reason being the phpadmin shows an error :

Error

SQL query:

-- MySQL dump 9.09
--
-- Host: localhost Database: lffusion_nuke
------------------------------------------------------- --
-- Server version 4.0.15-standard
--
-- Table structure for table `confirm`
--
DROP TABLE IF EXISTS confirm;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '---------------------------------------------------------
-- Server version 4.0.' at line 1

Here's the db info in my backup file.

-- MySQL dump 9.09
--
-- Host: localhost Database: lffusion_nuke
---------------------------------------------------------
-- Server version 4.0.15-standard

currently , i am using
PHP version 5.2.4
MySQL version 5.0.27-standard


anyway to import without problem ???

 

[rome2ng]

paying NP$30 to anyone who can get it fix...

come one

 

[wikes82]

mysql comment should start with '--' (double dash) followed by whitespace... so replace that long "----------------------" to "-- ------------"

or just delete the comments....
line start with "--" or "/*" (without quotes)

hihi guys..

i have a problem here and i seriously need help

I have a database that i use to create a site 5 years ago....
and i couldn't upload to today's phpadmin...

the reason being the phpadmin shows an error :

Error



Here's the db info in my backup file.



currently , i am using
PHP version 5.2.4
MySQL version 5.0.27-standard


anyway to import without problem ???

 

[rome2ng]

SQL query:

INSERT INTO nuke_bbsearch_wordlist( word_text, word_id, word_common )
VALUES (

'sanosuk�',4213, 0
);



MySQL said:

#1062 - Duplicate entry 'sanosuk' for key 1

upon browsing ... this error came out.

SQL query:

SELECT *
FROM Array
WHERE CONCAT_WS( "-", word_text, word_id, word_common ) = "sanosuk"
ORDER BY word_text, word_id, word_common
LIMIT 0 , 30

MySQL said:

#1146 - Table 'lffusion_nuke.Array' doesn't exist

note : i am using phpnuke old version..