hi, im a bit stressed right now... im deploying my new site which has some important database design changes. i obviously want to keep the data from the old design and import it into the new one. the problem is i cant figure out how to do this. nothing i try is working. how do other people do this?
to explain better, say i have a table with 5 colums, the new design only has 4. how can the data be exported/imported? ive tried exporting to csv and importing to excel to remove the columns, but excel likes to format my datetime columns, which mysql doesnt like... very frustrating...
hope someone can offer some advice.
thanks,
paul
to explain better, say i have a table with 5 colums, the new design only has 4. how can the data be exported/imported? ive tried exporting to csv and importing to excel to remove the columns, but excel likes to format my datetime columns, which mysql doesnt like... very frustrating...
hope someone can offer some advice.
thanks,
paul