importing mysql db (5 years ago) to today's phpadmin

rome2ng · 11-16-2007, 04:31 AM

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....
????: NamePros.com http://www.namepros.com/programming/396350-importing-mysql-db-5-years-ago.html
and i couldn't upload to today's phpadmin...

the reason being the phpadmin shows an error :

Error

Quote:

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.

Quote:

-- 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 · 11-16-2007, 06:24 PM

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

come one

wikes82 · 11-16-2007, 08:01 PM

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)

Originally Posted by 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

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 · 11-16-2007, 08:57 PM

Quote:

SQL query:

INSERT INTO nuke_bbsearch_wordlist( word_text, word_id, word_common )
????: NamePros.com http://www.namepros.com/showthread.php?t=396350
VALUES (

'sanosuk�',4213, 0
);

MySQL said:

#1062 - Duplicate entry 'sanosuk' for key 1

upon browsing ... this error came out.

Quote:

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..

11-16-2007, 06:24 PM	THREAD STARTER #2 (permalink)
rome2ng Senior Member Join Date: Oct 2005 Location: 1Â°88′N, 7Â°95′E Posts: 1,388	paying NP$30 to anyone who can get it fix... come one __________________ What's a good blog ? Find out here [+++] [http://treoo.com]- S'pore Local Gadget StoreÂ® - Now Online For Sales : \| Ads Development Site [neatad.com] -HOT \|

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)