BinaryWorks.it Official Forum
BinaryWorks.it Official Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 eXtreme Movie Manager 8, 9, 10 Forum
 Information
 Fix Movie ID		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

alcohol
Starting Member

6 Posts
Posted - 24 Oct 2014 :  19:24:17  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello,

I have a database of 915 movies, all of them in 2 NAS servers X & Y. When i delete a movie and add another one, the movie id continue to increase in number instead of taking the deleted movie id. so far i have 915 movies and the latest id is 1018. is it possible by a function to reset all movie ids - without harming the database - and have 915 movies with ids from 1 to 915?

Thanks in advance

JDommi
Administrator

Germany
4638 Posts
Posted - 24 Oct 2014 :  21:28:02  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You can renumber by id. Have a look at the database tools of the menu (I hope I'm right with the menu as I'm @work just now).
But to prevent any possible error I would backup the whole database manually: http://www.binaryworks.it/cgi-bin/data/wiki/doku.php?id=backup_database
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
BinaryWorks.it Official Forum © Binaryworks.it Go To Top Of Page
Generated in 0.12 sec. Powered By: Snitz Forums 2000 Version 3.4.07