How can I update table, if table exists with MySQL info?

Question

I have a mysql broken database and I have another one which is good and with all tables and columns. How can I import in broken database only missing info which is in good database? I mean tables and columns and values not stored info.

I exported good database and when I try to import in broken database I get: #1060 - Duplicate column name 'id_advice'

So, what I need is to skip if duplicate items and continue to add only info which does not exist.

Answer 1

You can make use of Mysqldump. There is a selection to use no data.

mysqldump -uYourUserName -p=YourPassword databasename --no-data --routines > "dump.sql"

The you can import the table stucture. there is also different options to use create if not exists or drop if exists so you can tailor make it for your needs. I recommend downloading Mysql Workbench, its easily done with that tool.

Info about mysqldump http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html