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

**rome2ng** · 11-16-2007, 03: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....
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, 05:24 PM

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

come one

wikes82 · 11-16-2007, 07: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)

Quote:

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, 07:57 PM

Quote:

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.

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, 05:24 PM	#2 (permalink)
rome2ng Your Friendly Mod® Forum Moderator Join Date: Oct 2005 Location: 1°88′N, 7°95′E Posts: 1,347 1,897.30 NP$ (Donate)	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)

Forum Moderator

Forum Moderator

Forum Moderator