Nukemods Forum - View Single Post

paycheck · 07-01-2003, 02:05 PM

It will be impossible to import the tables laterally using the insert method in MySQL. To do it you should open the database back up file you created in a text editor and copy the tables insert script adding the appropriate missin values that are in the new 6.5 structure. What I did when I updated my forums from 6 to 6.5 I made a SQL back up file, opened it in Ultraedit and copied the INSERT statement and pasted them into my SQL query and ran it. If I had a table change all I did was add the new value to the insert statement and placed the column in as well.

Worked fine but was time consuming.

JM

	(#2 (permalink))
paycheck Junior Member Status: Offline Posts: 137 Join Date: Jun 2003 Location: San Clemente, Ca. Orange	07-01-2003, 02:05 PM It will be impossible to import the tables laterally using the insert method in MySQL. To do it you should open the database back up file you created in a text editor and copy the tables insert script adding the appropriate missin values that are in the new 6.5 structure. What I did when I updated my forums from 6 to 6.5 I made a SQL back up file, opened it in Ultraedit and copied the INSERT statement and pasted them into my SQL query and ran it. If I had a table change all I did was add the new value to the insert statement and placed the column in as well. Worked fine but was time consuming. JM Logos for free at http://www.jsm-inc.com Be cool!