Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MYSQLDUMP with AUTO NUMBER

Status
Not open for further replies.
sciclunam

sciclunam

Programmer
Oct 12, 2002
138
MT
I need to dump my table on the localhost so that I can rerun the script on the remote site using phpmyadmin.

The problem is that both tables (local and remote) have an autonumber field and thus cannot insert data in it. How can go about it?



Getting married in Malta?
Visit
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
516
Chris Miller
Chris Miller
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
176
spamjim
spamjim
Arun Mahajan
  • Locked
  • Question
How to catch SQL Exception Error number in MySQL 5.6
Replies
0
Views
155
Arun Mahajan
Arun Mahajan
eizs002
  • Locked
  • Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
347
spamjim
spamjim
Nigel Gomm
  • Locked
  • Question
MariaDB ODBC connector 3.1.4 with BEGIN ATOMIC
Replies
1
Views
128
Nigel Gomm
Nigel Gomm

Part and Inventory Search

Sponsor

Back
Top