[FIXED] How to import .sql file on the altered table?

Issue

I am working on PHP project, I use MYSQL at backend and I use XAMPP to work on my machine.

I have a copy of source code in my localhost and on the online server that is on hostgator.com.

I use localhost to test my source code and after finishing testing. I upload it on the online server(hostgator.com)

Recently I am facing a problem in Database.

I applied some alter table queries on few tables in my database. Now I exported the database in a SQL file from localhost and importing in on live server of hostagotor.

But 'import' action is showing error(Using PHPmyadmin to import queries) . It is saying that 'Column, Column_name was not found' , i know this error is because i applied some alter table queries on few tables.

Can you tell me if there is any shortcut so that, i dont have to write those alter table queries again on the live server.

Solution

After doing lot of research , i could not find out any shortcut. I wrote those alter table queries again on the table of new database and then imported the .sql file.

Answered By - CyberBoy