FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Export and Import Mysql Table





Philip
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
Philip
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 ^__^
simplyw00x
Well if you exported and imported them correctly, that doesn't happen. Care to tell us how you did this import/export?
Philip
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.
kv
http://www.frihost.com/forums/vt-36118.html
Philip
kv wrote:
http://www.frihost.com/forums/vt-36118.html


this info doesn;t help me, the increament still dont show up after dump it to mysql internet server. --"
i confused by it --"
kv
can you examine "create" statements in your dump? autoincrement may be missing (dump not created properly).
JayBee
You must check
add AUTO_INCREMENT, on the export form
It works for me.
Philip
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 ??
JayBee
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.
Philip
that's so strange, can not we defined a array object that ranged 1 to 10 with own want ?
avk
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.
Philip
i don't try it yet, but maybe later,
i will up this topic again, after i tried it Smile

thanks all pal
Related topics
E-Cards with PHP & MySQL
HTTP AUTH with PHP and mySQL
Help me to Import mysql databases from web into home pc !
mysql table keyword search
Working with Excel, PHP & MySQL. Any Ideas
SELECTing from MySQL with PHP
best phpmyadmin database exporting format
How to import mysql databases from text files?
how to selecting this from a mysql table ?
Overwrite/Delete on Import of Table
phpmyadmin import doesn't work
a new mysql table...
Validating sql statements
Subtrat values to a mysql table script
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.