Jump to content
hugh

Strange table names and mixed prefixes

Recommended Posts

Hi,

So I was just taking a look at my database and I notice that I have mixed table prefixes (rv_ and ox_), pressumably left over from earlier incarnations of the software. Are these legacy tables (ox_) still needed? I also notice many tables with random looking names, what about those?

Thank you!

Hugh
---

ox_z_0c8971a0b5a2778d
ox_z_0e7b287c4b1d5f0f
ox_z_00bcfceb4d6ed89d
ox_z_00e11daab9ca1b87
ox_z_04483be74f999d25
ox_z_0493d1cfbdb8d7e2
ox_z_08d49b0f4db2ec7c
ox_z_1a800d9a5be064ce
ox_z_1c2471cdd657fa01
ox_z_1eefb8cf5b89cfbc
ox_z_1fbcb5a9d38d93a2
ox_z_2a945cff93bf5ad2
ox_z_2ad232fa61039438
ox_z_2b272788b0859cc0
ox_z_2ebb71db636955ad
ox_z_2f5d547e628f7008
ox_z_3b5775767e310205
ox_z_3bef635ffd969b9f
ox_z_3ca45a3158b76e9a
ox_z_3cba5b6385915d4e
ox_z_3cc483d585ef85f8
ox_z_3dbd0dc3489c7ff9
ox_z_3f4011c60eb981c1
ox_z_3fbf86047ad9f177
ox_z_4bc3ae3a06118a4c
ox_z_4d8f252c87fcaee0
ox_z_4da5ebe57c5c7be2
ox_z_4dafb742007d9334
ox_z_4e2cf58903fed1ff
ox_z_4f6d0a53851e819f
ox_z_4ffd588e022f7cf8
ox_z_6c17f17086aef1bc
ox_z_6f907754f88e9ffa
ox_z_6fe724ba223500cc
ox_z_7ec93bf3128ece77
ox_z_8afb1fee18e3e2fe
ox_z_8fdc9e97cabae9e4
ox_z_9a2fbcbf505c3773
ox_z_9a59b2e75310f416
ox_z_9abddd92a7ec4326
ox_z_9cdbe7e156a86c2d
ox_z_9e01a84f0c19555f
ox_z_9e4b3016d3991460
ox_z_9f3e4cedd2ec689b
ox_z_12b98db357dffac0
ox_z_12c30ee5abe808c8
ox_z_12c3139c5f1137ea
ox_z_18fc0867532daea5
ox_z_24da407661bc3705
ox_z_24e12246eda864b7
ox_z_25f82ef19cd328dc
ox_z_32da93de7f08b7a8
ox_z_38ebafc47d8dd8b7
ox_z_46bc080f8a8d2e04
ox_z_46d7b13b0d0617f9
ox_z_46db72e48ca8f928
ox_z_47f1d3cd8d825801
ox_z_59e1a00ce0caa621
ox_z_63a83a722e7a1e04
ox_z_65a3a61f28718269
ox_z_65e6cb08af9540c4
ox_z_69f65efda385d531
ox_z_70c36c95e2fb5b0e
ox_z_80b86c49c5de1b3a
ox_z_80dcb0634aaf3baf
ox_z_81eaccae48a38a5f
ox_z_82e6ead548956119
ox_z_86de5d27cd0ffbe5
ox_z_88a07ce51ab881f5
ox_z_89b04c821ba8b192
ox_z_208bb4d199a0b2fc
ox_z_219ebbdfedaf9dd4
ox_z_324c91920f1d0f26
ox_z_339b6c04f9e8e7c8
ox_z_410a7e49d61496e7
ox_z_423ec6ef884d4d23
ox_z_474b2696270e08f6
ox_z_564a0de39c39862f
ox_z_577b95da121de2a9
ox_z_587f82ba9e067a7a
ox_z_589fc9fb38dae79b
ox_z_590e48a6e0254e8b
ox_z_710ac226f8c4ccce
ox_z_754edce619092962
ox_z_819a02ce38b104e3
ox_z_834ac545c62cb236
ox_z_897ddacacc1badb9
ox_z_1550f84650368f35
ox_z_2371fe7412886e73
ox_z_3223fcfdf8507731
ox_z_7866c05800faab41
ox_z_8324d370c642a403
ox_z_8558f4bdc88ad0cb
ox_z_9139aeb1ac683005
ox_z_9356a42a08f41f62
ox_z_9643e1ff5c306a33
ox_z_15756a42d30c9282
ox_z_73974f3b992e4ff7
ox_z_82372af34844a13f
ox_z_82814ebde6927a16
ox_z_98766ea65e0f9666
ox_z_106663fe5db44788
ox_z_462198c677d808c1
ox_z_497436d60c1241a5
ox_z_505332ee3c14c76a
ox_z_848332f5139dda5b
ox_z_3357956df9241ea1
ox_z_8398194ff6b96b75
ox_z_8430851b4e430ed7
ox_z_12799713ab52913e
ox_z_13641853d917939f
ox_z_950233040ea0884c
ox_z_6099864825fff13b
ox_z_4343295906255e2a
ox_z_a0057b6dedd75f1b
ox_z_a06ac48ee50cb3fd
ox_z_a3cbc1ce6ffae7c5
ox_z_a4a51916e5c57042
ox_z_a4fc92de36e46fce
ox_z_a7b7c1b235af3ca2
ox_z_a63a75f8342288e8
ox_z_a30700c069748b0c
ox_z_a926267fec40510c
ox_z_aa84bfc53d9a576b
ox_z_ac596b3f662ae0f3
ox_z_ace167e56692ec29
ox_z_adbeda6de8d8ad1e
ox_z_ae8ca05cebead72f
ox_z_ae46b97e643532b2
ox_z_af9d8ffe16b689d3
ox_z_afed419e66a4076f
ox_z_b09ba15222835c42
ox_z_b2dc6ad178afe11d
ox_z_b8b6f2ccfdd085bf
ox_z_b12e41e52f7b2dd6
ox_z_baaa32c624ff5ef5
ox_z_bb759c382c6b7496
ox_z_bb1935c4321256a1
ox_z_bbc1a461fea7d312
ox_z_bc785cfd75311a0c
ox_z_bcfcacdd2be24473
ox_z_bdccad37266e167f
ox_z_bfda4785fabc30f6
ox_z_c07fef68576107c6
ox_z_c08e3aaa09c77c5b
ox_z_c4d7c2a856cf3fb8
ox_z_c74b8db08a99a9c6
ox_z_c643d4d4bedfbfcd
ox_z_c6041eac4fca1044
ox_z_cb6bc86aa72c3dee
ox_z_cc761bad06059061
ox_z_cc809dbc75ab9b91
ox_z_cdb25bb7270b5b7b
ox_z_cee678195cde4f82
ox_z_d5b1a9951cf8ef64
ox_z_d8f5e47b932442b9
ox_z_d232e5fc388be530
ox_z_d573dd2d9015aa5e
ox_z_d783fe4a459b035a
ox_z_d3802de896e65a9b
ox_z_db1b36be96c912c8
ox_z_dbc6372462ed3109
ox_z_dc58491b918a6d6d
ox_z_df843c299256185f
ox_z_e2ec12b0289f997c
ox_z_e275219e756bc930
ox_z_e685715cab57552a
ox_z_ea4dcbb5785536a5
ox_z_ef9115718fd43b11
ox_z_f96a7928bc0c0e5b
ox_z_f863e24532106989
ox_z_f2457d8ecf14e33a
ox_z_f984737a6b9c8e6a
ox_z_fbb624a532ff6254
ox_z_fbe9d430be8fa343
ox_z_fc4e0a1eb9287d6d

 

Share this post


Link to post
Share on other sites

Anything with those random name with _z_ in them are backup tables.

What I don't understand is how you can have both rv_ and ox_ tables in your database. The most likely explanation is that you used OpenX Source and at some point did a fresh install of Revive Adserver in the same database.

Share this post


Link to post
Share on other sites

I didn't say that. Those might actually be the active tables of your ad server.

If you started years ago with OpenX Source (prefix ox_) and over time upgraded to Revive Adserver, the table names will still have ox_ as their prefix.

What you can delete are the ox_z_ tables and the rv_z_ tables (if any of those exist).

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...