export customer database

[yosemite]

i had done this awhile back then came back to the forum to find the answer i had found before and could not find until i did a lot of digging around. so i am reposting in its own thread in the hopes that it is easier to find and helps someone else


to import your customer information from one database to another database

this seems to work fine when importing from 1.35 to 1.37

import these fields
1. address_book
2. customers
3. customers_info

phpmyadmin settings for export

select table: ie> customers

sql options= NONE

uncheck "structure"
check> Add AUTO_INCREMENT value
check> Enclose table and field names with backquotes
check>data
check> "complete inserts"
check>Use hexadecimal for binary fields

then import into new database. i have only done this import into a fresh install so i am not sure what will happen if you import into a db with other customers.

[kobra]

selet the typ for this as incremental and no "drop Table if exists"