[thelist] Mysql backing up db

Anthony Baratta Anthony at Baratta.com
Fri Oct 19 21:41:11 CDT 2001


I usually do a mysqldump, which allows you to dump the data with full SQL 
insert commands. If I remember correctly mySQL will allow you to assign a 
number to the AutoIncrement field. With MS SQL, you need to set a special 
parameter (SET IDENTITY_INSERT <table name> ON) before you attempt an 
insert with an identity field.

What I would do it setup a test table and play around with it.

Don't forget the penultimate source of info: 
http://www.mysql.com/documentation/index.html
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."





More information about the thelist mailing list