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 ?
thanks
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.
thanks ^__^
Well if you exported and imported them correctly, that doesn't happen. Care to tell us how you did this import/export?
| simplyw00x wrote: |
| Well if you exported and imported them correctly, that doesn't happen. Care to tell us how you did this import/export? |
i am using phpmyadmin for export, and i am using phpmyadmin for import also, but when i was import i set the collation into latin1 since i see my data local is using latin1 too also.
this info doesn;t help me, the increament still dont show up after dump it to mysql internet server. --"
i confused by it --" 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.
| Code: |
--
-- Table structure for table `data_files_group`
--
DROP TABLE IF EXISTS `data_files_group`;
CREATE TABLE IF NOT EXISTS `data_files_group` (
`user_id` bigint(20) NOT NULL,
`group_files` bigint(20) NOT NULL,
`keterangan` tinytext NOT NULL,
`tgl` tinytext NOT NULL,
PRIMARY KEY (`user_id`,`group_files`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
nope it seem it was ok, there is a AUTO_INCREMENT text under create tabel sql statement,
when i check it with using SQL for run this statement the auto increament is created also, but when i was using import php myadmin, upload zip files for run this statement, it seem the auto increment is not create, i wonder is it because i change the collation into LAtin1 ??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.
i don't try it yet, but maybe later,
i will up this topic again, after i tried it 
thanks all pal
