CODEWITHSUNDEEP
phpmyadmin
Jood jindy
Jood jindy

Reputation: 480

modify phpmyadmin database on server with import?

in my work i have

phpmyadmin

SQL database to work on (locally and on server)

the annoying problem is when i modify the local DB structure (columns,relations,new tables) i'm forced to redo the modifying again on the server DB because when i backup my local DB and import it in the server i get the error (table exists) and the importing operation gets canceled

so how can i import the modified structures in the server without redo them? thanks a lot

Upvotes: 2

Views: 131

Answers (1)

habib Kaghas
habib Kaghas

Reputation: 36

Save the DDL on another TXT file and when you are finished with the modification process upload the TXT file to the server and execute the DDL.

Upvotes: 2

Related Questions