How to restore a table?

Question

MySQL

Hello!
There is a table with ~1 million records.
The table has fields abc d.
It was necessary to rename the fields (change the names of one column to another) a <-> c, b <-> d.
I did it using phpMyAdmin. When renaming, there was an error about lack of time, but visually the column was renamed. With such an error and renamed all columns. From pma everything seems to be fine. But when receiving data from scripts, the result did not change. How to restore (rename) table columns?
thank.

Answer 1

apparently write a script that patches the table :)