Alter column name in mariadb

ALTER TABLE customer CHANGE COLUMN `CUST_ID` -- old name; notice optional backticks CustomerID -- new name decimal(15,0); -- must include all the datatype info

Export and Import Table in Mariadb

mariadb-dump -p dmdb customer > customer.sql mariadb -p uirtdb < customer.sql