Question problem in stream_id values in millions

[hazdo]

hello mates hope you are doing okay

i have a pannel that it has stream id in millions values due to autoincrement jump
the problem now is when trying to add user agent or any stream prameter it can be added due to high value limit.
anyway to fix this problem and reset autoincrement to low values

 

[urgodfather]

hello mates hope you are doing okay

i have a pannel that it has stream id in millions values due to autoincrement jump
the problem now is when trying to add user agent or any stream prameter it can be added due to high value limit.
anyway to fix this problem and reset autoincrement to low values

easiest way is to back up the stream table as inserts, truncate it and streams_sys, then re-import and mass edit.

more importantly though, if you have reached millions in your stream id's then you obviously have loaded too many playlists over and over. trials or whatever. that is a really bad habit.

 

[hazdo]

easiest way is to back up the stream table as inserts, truncate it and streams_sys, then re-import and mass edit.

more importantly though, if you have reached millions in your stream id's then you obviously have loaded too many playlists over and over. trials or whatever. that is a really bad habit.

it is a friend pannel he told me and i noticed a auto increment jump he maybe did somthing wrong impossible to reach that number manually

i did not get this "back up the stream table as inserts" normal backup for table you mean and backup also stream_arguments ??

 

[urgodfather]

it is a friend pannel he told me and i noticed a auto increment jump he maybe did somthing wrong impossible to reach that number manually

i did not get this "back up the stream table as inserts" normal backup for table you mean and backup also stream_arguments ??

To view the content, you need to Sign In or Register.

 

[hazdo]

thanks a lot urgodfather.
after i do mass edit to restream them back you mean sorry for that but please clarify more.

so i need to re select servers and params for each stream

i thought in a way to update id for streams and streams_id for both stream_sys and stream_arguments tables but the problem is that streams_id is not uniq for those two tables

 

[urgodfather]

thanks a lot urgodfather.
after i do mass edit to restream them back you mean sorry for that but please clarify more.

so i need to re select servers and params for each stream

i thought in a way to update id for streams and streams_id for both stream_sys and stream_arguments tables but the problem is that streams_id is not uniq for those two tables

nothing needs to be bothered with stream_arguments.

make full backup to be safe.

then make specific backup just for streams.

truncate streams table and stream_sys table.

restore streams backup.

from panel mass edit streams to assign to servers and etc. this will recreate entries in stream_sys.

 

[hazdo]

nothing needs to be bothered with stream_arguments.

make full backup to be safe.

then make specific backup just for streams.

truncate streams table and stream_sys table.

restore streams backup.

from panel mass edit streams to assign to servers and etc. this will recreate entries in stream_sys.

@urgodfather about movies and series i do need to retranscode them right?