Back to "Factory Settings"

ramon · Post by **ramon** » Wed Apr 27, 2011 1:50 pm

Hi,

I am planning to migrate my Blog from WP back to s9y (well, I missed it). Before bringing the new Blog online I am testing a few things. Which also means, that I am importing the WP-Articles, delete them and import them again.

Now I noticed that the IDs for the articles are increase. Let's say I have 500 articles. After importing and deleting them for the first time I import them again an the ID for the first article starts with 501. For me it is just some sort of cosmetics but I would like to see the first article ID starting with 1. I already tried to empty tables like _comments, _entries and some others, but without any success. What do I have to "reset" to assure that, after importing, the first used ID is 1?

regards
Ramon
--
Software failure! Press left mouse button to continue.
Guru Meditation #8100000A.000FEA00

Post by **garvinhicking** » Wed Apr 27, 2011 4:25 pm

Hi!

How did you delete them? If you use a "TRUNCATE TABLE" instead of "DELETE FRMO..." this will reset the auto_increment counter in MySQL.

Regards,
Garvin

ramon · Post by **ramon** » Wed Apr 27, 2011 9:32 pm

Hi,

well, another reason to migrate to s9y. It's faster, the Core Developer is a "Bonner" (Weil wir die Bonner sind...

) and you get help in a quite short time. Now it works. Thanks!

regards
Ramon

Post by **garvinhicking** » Wed Apr 27, 2011 9:47 pm

Hi!

I try my best.

Weren't you the one I met up with at the Bonner McDonalds a long time ago?

Nice to have you back aboard!

Regards,
Garvin

ramon · Post by **ramon** » Thu Apr 28, 2011 1:37 pm

Hello,

I can't remember to met you at the Bonner McDonalds. And I'm sure I would remember that

Regards
Ramon

Back to "Factory Settings"

Back to "Factory Settings"

Re: Back to "Factory Settings"

Re: Back to "Factory Settings"

Re: Back to "Factory Settings"

Re: Back to "Factory Settings"