hugh Posted August 7, 2016 Report Share Posted August 7, 2016 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 Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted August 8, 2016 Report Share Posted August 8, 2016 Those are backup tables from earlier upgrades. You can safely delete them. Quote Link to comment Share on other sites More sharing options...
hugh Posted August 8, 2016 Author Report Share Posted August 8, 2016 40 minutes ago, Erik Geurts said: Those are backup tables from earlier upgrades. You can safely delete them. Which? All those prefixed ox_? Or just the ones I listed? Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted August 8, 2016 Report Share Posted August 8, 2016 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. Quote Link to comment Share on other sites More sharing options...
hugh Posted August 8, 2016 Author Report Share Posted August 8, 2016 Does that mean I can simply delete all the ox_ tables? Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted August 8, 2016 Report Share Posted August 8, 2016 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). andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
hugh Posted August 8, 2016 Author Report Share Posted August 8, 2016 All good. Thank you for your time! andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.