Average Score	0.0 (of 0 scores)
Date Added	Mar 28, 2007
Last Updated	Mar 28, 2007
Tags	complete  insert

This is more of a note to myself, but I use it to dump databases where there are additional fields in the new table. When you're upgrading a database you can either add the new fields to the old table or move the data from an older table to a newer one.

I usually like to add the new fields, but when it's a major upgrade I just start with a fresh, current table. That's where this code comes in handy. You use this to dump the data from the older table. That way it can be inserted into the newer table without any hassles over an incompatible number of fields.

Grab the Code

mysqldump --complete-insert database table > table.sql

Enter comment here..

Commenting Options

Register or Login to Hawkee.com or use your Facebook or Twitter account by clicking the corresponding button below.