473,320 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

phpMyAdmin question

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.

May 22 '06 #1
4 3852
I have same problem! :(

May 22 '06 #2
Rik
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
May 22 '06 #3
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
==================
May 22 '06 #4
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.

May 22 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
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...
0
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...
0
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:...
0
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...
0
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...
2
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...
2
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...
2
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...
1
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,...
6
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...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
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...
0
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...
0
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...
1
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.