Originally Posted by RAH104
Both servers are running MySQL 5. Backup was made with mysqldump. What is the best way of correcting this? Editing the file in nano I presume would take forever for it to load.
Yeah, loading a 1.4GB file then trying to edit and save is not something you want to do, not even with vi or any editor.
The way I would approach this is to either edit the file by using sed, might take just as long but could work, I've done this with mysql dumps over 10GB once, knowing the line number helps quicken the process. Or you could try using the command split to split up the file into smaller files. Find the line that has the duplicate column name, edit or remove, finish loading to restore.