I got a problem when try to import mysql table from intranet to internet.
the problem is at auto_increament.
Field Type Collation Attributes Null Default Extra Action
no_jurnal bigint(20) No auto_increment
it seem after i export into mysql state and try to import in internet server the auto_increment is missing,
does someone heere know what is happened ?
hello, this topic up to top.
Does anyone here know why after i export and import on server internet mysql, i lost my Auto Increment on all my tables.
Well if you exported and imported them correctly, that doesn't happen. Care to tell us how you did this import/export?
can you examine "create" statements in your dump? autoincrement may be missing (dump not created properly).
You must check
add AUTO_INCREMENT, on the export form
It works for me.
it seems to be ok.
You dont have data? You want to transfer only table structure? Or, how does your section wit "INSERT INTO ..... " look like?
I have few problems exporting and importing between diferent versions of MySQL especilally on frihost where is very old version 4.0.23 and at home I have 4.1.21 and there are many diferents. But there is also compatibility mode. So I don't know.
that's so strange, can not we defined a array object that ranged 1 to 10 with own want ?
Ya! that's it..
I think that importing and exportng should be done correctly and finally all will be OK.
this has never been with me.