I know this isn't strictly php, but I am guessing someone has run into
this before in php work.
I have a table, this table has an autonumber as a primary key.
I export the table in phpMyAdmin.
Cool so far.
I create a new DB, I import the backup of the DB in that new DB and it
throws an error that the table with the automnumber already has a value
of 1 (it isn't incrementing the new table).
Ok, go back and hack through, remove the autonumber. Now export and it
imports fine.
Except how do I get the autonumber back? There are hundreds of rows of
data and I want that autonumber but when I try and add it it says there
is already an ID field with a "1" (same as before, not saying "find the
highest and add one more" just saying "start at 1, oops there is one,
then die"
Anyone know a way around this? I want ot add my autonumber to my table
with the data that is already there. 4 3852 JM****@gmail.com wrote: I know this isn't strictly php, but I am guessing someone has run into this before in php work.
I have a table, this table has an autonumber as a primary key.
I export the table in phpMyAdmin.
Cool so far.
I create a new DB, I import the backup of the DB in that new DB and it throws an error that the table with the automnumber already has a value of 1 (it isn't incrementing the new table).
Ok, go back and hack through, remove the autonumber. Now export and it imports fine.
Except how do I get the autonumber back? There are hundreds of rows of data and I want that autonumber but when I try and add it it says there is already an ID field with a "1" (same as before, not saying "find the highest and add one more" just saying "start at 1, oops there is one, then die"
Anyone know a way around this? I want ot add my autonumber to my table with the data that is already there.
This what you mean?
Export options:
- structure
- Add AUTO_INCREMENT
- data
- Complete inserts
Grtz,
--
Rik Wasmus JM****@gmail.com wrote: I know this isn't strictly php, but I am guessing someone has run into this before in php work.
I have a table, this table has an autonumber as a primary key.
I export the table in phpMyAdmin.
Cool so far.
I create a new DB, I import the backup of the DB in that new DB and it throws an error that the table with the automnumber already has a value of 1 (it isn't incrementing the new table).
Ok, go back and hack through, remove the autonumber. Now export and it imports fine.
Except how do I get the autonumber back? There are hundreds of rows of data and I want that autonumber but when I try and add it it says there is already an ID field with a "1" (same as before, not saying "find the highest and add one more" just saying "start at 1, oops there is one, then die"
Anyone know a way around this? I want ot add my autonumber to my table with the data that is already there.
Maybe ask in a mysql newsgroup, such as comp.databases.mysql?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp. js*******@attglobal.net
==================
The question now is two things (probably the same answer).
1. The table I had to take the autonumber off, it won't let me put it
back on "Duplicate entry '1' for key 1" How do I tell it, "keep the
autoIDs that are set, and when someone adds a new one then autonumber"
because right now it is trying to renumber where there is already data.
2. Same thing with the copy of the table, it won't let me add the key
there either. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: SCS |
last post by:
Running PHP 4.5.7
PHPMyAdmin 2.5.7-pl1
IIS 6
I am thrying to get phpmyadmin to work, but whenever I click a link or try
to browse a database I get a 404 error, because the PmaAbsoluteUri...
|
by: phpnube |
last post by:
I used this php package to install on my system... (i had problems with the
isapi package from php so im back to the cgi portion of PHP php-cgi.exe)
PHP 5.0.0 installer - 26 July 2004
(CGI...
|
by: ghasem |
last post by:
Dear all,
Hello to all the great minds of php. My humble question is regarding
the phpmyadmin. As you know the welcome screen of phpmyadmin allows
one to choose the language.
My question is this:...
|
by: leegold2 |
last post by:
Can using PHPMyAdmin cause problems. What I'm doing is, I'm using
PHPMyAdmi as a data entry tool. I create a new record in a table and
then fill in the fields with the field editing and insert...
|
by: Golf Nut |
last post by:
This is a phpmyadmin question more than anything, but I hope someone may be
able to help. When creating a dump of a normalized database with 26 innodb
tables, phpmyadmin export seems to only export...
|
by: Charles Alexander |
last post by:
This is a really, really elementary (almost dumb) question. I have a php
script I picked up elsewhere that I want to use to query my MySQL DB. I
have phpMyAdmin. I'd like to somehow run this...
|
by: Marcus |
last post by:
Hello,
I am trying to install phpMyAdmin 2.8.2 and have a question about
config.inc.php. Is it necessary to include all of the $cfg fields in
config.default.php, or is it ok to just have...
|
by: Victor |
last post by:
Could anybody kindly point me to a clue in the following enigma :
I have phpMyAdmin - 2.8.2.4 and MySQL - 4.1.13-nt. In the phpMyAdmin
opened in any browser I am able to enter and store Russian...
|
by: bill |
last post by:
I have created a database with phpMyAdmin, without problem.
I can save and retrieve from the database without problem
(programatically)
But, when I want to browse the database with phpMYAdmin,...
|
by: Daz |
last post by:
Hi everyone,
This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |