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
Back to "Factory Settings"
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Back to "Factory Settings"
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: Back to "Factory Settings"
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
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
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Back to "Factory Settings"
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: Back to "Factory Settings"
Hello,
I can't remember to met you at the Bonner McDonalds. And I'm sure I would remember that
Regards
Ramon
I can't remember to met you at the Bonner McDonalds. And I'm sure I would remember that
Regards
Ramon