[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