You can not (usually) use a metadata.db from another (time wise) collection.. Things contained, may have changed.
The Series column, not the book name, sets the (book number/reading) order used by the template on export.
Series_name[series_index_value]
I thought you said had you copied the CALIBRE Library folder? That should always work.