LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   mysql import without overwriting existing data (https://www.linuxquestions.org/questions/linux-general-1/mysql-import-without-overwriting-existing-data-4175442153/)

surferboy 12-19-2012 08:48 AM
mysql import without overwriting existing data
 
I have a mysqldump of an entire database

I want to import that into a database on a different server

The new database already has data in it

how can I import the data that is not there and not tinker with the existing data?

acid_kewpie 12-19-2012 08:51 AM
just strip out the dump and only save the INSERT INTO lines.


All times are GMT -5. The time now is 06:15 AM.