Hi All I have a .sql dump which i think is from mysql 4 but i am using mysql so i cant import it using phpmyadmin and its just takes ages and nothing happend so i tied running 1 of the lines which is:

INSERT INTO `gs_games` ('gId', 'gInCategory', 'gSwfFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gHeight', 'gDescription', 'gplays', 'description2', 'des2', 'filetype') VALUES (1,101,'f-218.swf','12 Holes of X-Mas',0,1,'f-218.png',525,400,"'Pick your putter and go out to putt a hole in one.Move the ball to where you want it then click,move your mouse according to the arrow then click to shoot the ball, and play all twelve holes'",0,'','',1)

but phpmyadmin give the error:

#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 ''gId', 'gInCategory', 'gSwfFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWid' at line 1

So i removed the ' in the ('gId', 'gInCategory', 'gSwfFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gHeight', 'gDescription', 'gplays', 'description2', 'des2', 'filetype') so they are just e.g. (gId, gInCategory,.... and fair enough if it was a few lines i needed to change I would but its 4,000 and thats why to many to change. I was wondering if there is a program or trick or something that could change the .sql so its removes the ' on the first area but not the others without removing them myself? Thanks in advance.

    text editor, search and replace, just match the whole string 'gId' not just ', you have to do it 13 times but for a one of does not seem to painfull

    doh--

    just search replace the string B[/B]

      Hi thats a gd idea i think i will do that thanks. I was going to just edit each ' but your way is alot better. Also its 4,000 times as its 4,000 lines and one for each line. Thanks

        Write a Reply...