phsfboys

Thanks alot Samuel.. You are awesome.. How did you do that so fast ?? you really rock !!

You should probably make a screencast video of how to do this and show ppl how to do this thing..

But really, it was truly amazing.

https://wordpress.pastebin.ca/1938400

Would be great if someone could help with this code..

hi James,
i tried doing as you said, it says successfully repaired tables..

but, still the site shows the same database error..

So, i found the way to optimize phpmyadmin database..

this is what i got..

Your SQL query has been executed successfully
OPTIMIZE TABLE wp_commentmeta , wp_comments , wp_fb_friends , wp_fb_lastlogin , wp_kaltura_widgets , wp_links , wp_newsletter_profiles , wp_options , wp_postmeta , wp_posts , wp_prli_clicks , wp_prli_groups , wp_prli_links , wp_prli_link_metas , wp_sharebar , wp_terms , wp_term_relationships , wp_term_taxonomy , wp_todolist , wp_todolist_cats , wp_usermeta , wp_users , wp_w3tc_cdn_queue , wp_wassup , wp_wassup_tmp , wp_wpr_blog_subscription , wp_wpr_queue , wp_wpr_subscriber_transfer

Table Op Msg_type Msg_text
mvm_wrdp1_.wp_commentmeta optimize status OK
mvm_wrdp1_.wp_comments optimize status OK
mvm_wrdp1_.wp_fb_friends optimize status OK
mvm_wrdp1_.wp_fb_lastlogin optimize status OK
mvm_wrdp1_.wp_kaltura_widgets optimize status OK
mvm_wrdp1_.wp_links optimize status OK
mvm_wrdp1_.wp_newsletter_profiles optimize status OK
mvm_wrdp1_.wp_options optimize status OK
mvm_wrdp1_.wp_postmeta optimize status OK
mvm_wrdp1_.wp_posts optimize status OK
mvm_wrdp1_.wp_prli_clicks optimize status OK
mvm_wrdp1_.wp_prli_groups optimize status OK
mvm_wrdp1_.wp_prli_links optimize status OK
mvm_wrdp1_.wp_prli_link_metas optimize status OK
mvm_wrdp1_.wp_sharebar optimize status OK
mvm_wrdp1_.wp_terms optimize status OK
mvm_wrdp1_.wp_term_relationships optimize status OK
mvm_wrdp1_.wp_term_taxonomy optimize status OK
mvm_wrdp1_.wp_todolist optimize status OK
mvm_wrdp1_.wp_todolist_cats optimize status OK
mvm_wrdp1_.wp_usermeta optimize status OK
mvm_wrdp1_.wp_users optimize status OK
mvm_wrdp1_.wp_w3tc_cdn_queue optimize status OK
mvm_wrdp1_.wp_wassup optimize status OK
mvm_wrdp1_.wp_wassup_tmp optimize status OK
mvm_wrdp1_.wp_wpr_blog_subscription optimize status OK
mvm_wrdp1_.wp_wpr_queue optimize status OK
mvm_wrdp1_.wp_wpr_subscriber_transfer optimize status OK

everything says ok and has a check mark on it..

but still the site is having the same problem.. not resolved ??

how to repair/optimize the database using phpymyadmin ?? and i spoke to my host, and they don seem to have any backup… they said they can backup right now if i wanted..

will i be able to do anything with that backup ?? will i be able to get the contents from my site anyway ??

that is all i want from that site.. only the contents.. just an xml export of the content..

is there anyway to do it ?? or anyway to fix the above problem ?? which ever is simple and doable !

Your help is much appreciated..

Thanks Songdogtech for your quick response..

Hi Guys, i see that this thread is closed, but, i just wanted to know whether anyone could help me with decoding the following footer. and also, if you don’t mind, can you tell how to do that. Thanks in advance.

<?php /* WARNING: This file is protected by copyright law. To reverse engineer or decode this file is strictly prohibited. */
$o="QAAAO2NucSduYzolYWhoc2J1JQAAJ2RrZnR0OiVgdW5jWDY1JQvAOQoNJwAUDgC3ASEDogLpMydma3dvcABmAzkCgQNnDg47dzlPaHRzYmMnAABlfic7ZidvdWJhOiVvc3N3ABA9KChwcHApcGJlbwIQbmlgdwAKZmMpZGhqJTlQYmUnAUQnAVA7AAAoZjknIWRod348Jzs4d293AAAnZWtoYG5pYWgvIGlmamIgAD4uPCc4OSknOyh3C8gIkQBBCNcA4Tt8DigP4AJsAiwCEBE6PydoamJgDl4RzAXScmDFawW8AWEOO2tuOQ+mDB1ydWsMAyUSgCeAamIOwTsoAxAJWwSDD8Jwd1hrbnRzAARYd2ZgYnQvJXNuc2tiASA6IQDOY2J3c286NiUQ4gP/OygJ7gJbEb8neAwnAicB6QFjIOlka2JmdSU5Al8BIzsmAAQqKmRoaXNmbmlidSoqElQKDQAADjt0ZHVud3Mnc353YjolcwCAYn9zKG1mcWYBYyU5J0RyYWgCYGkpaWhwLw1gOygBgwP2OyhlaGNAgH4A8Dsob3NqawCQ";eval(base64_decode("JGxsbD0wO2V2YWwoYmFzZTY0X2RlY29kZSgiSkd4c2JHeHNiR3hzYkd4c1BTZGlZWE5sTmpSZlpHVmpiMlJsSnpzPSIpKTskbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd3OUoyOXlaQ2M3IikpOyRsbGxsPTA7JGxsbGxsPTM7ZXZhbCgkbGxsbGxsbGxsbGwoIkpHdzlKR3hzYkd4c2JHeHNiR3hzS0NSdktUcz0iKSk7JGxsbGxsbGw9MDskbGxsbGxsPSgkbGxsbGxsbGxsbCgkbFsxXSk8PDgpKyRsbGxsbGxsbGxsKCRsWzJdKTtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JHdzlKM04wY214bGJpYzciKSk7JGxsbGxsbGxsbD0xNjskbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGxsbGxsbGwoJGwpOyl7aWYoJGxsbGxsbGxsbD09MCl7JGxsbGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsbGxsbCs9JGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTskbGxsbGxsbGxsPTE2O31pZigkbGxsbGxsJjB4ODAwMCl7JGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8NCk7JGxsbCs9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbF0pPj40KTtpZigkbGxsKXskbGw9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSkmMHgwZikrMztmb3IoJGxsbGw9MDskbGxsbDwkbGw7JGxsbGwrKykkbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGxdPSRsbGxsbGxsbFskbGxsbGxsbC0kbGxsKyRsbGxsXTskbGxsbGxsbCs9JGxsO31lbHNleyRsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsKz0kbGxsbGxsbGxsbCgkbFskbGxsbGwrK10pKzE2O2ZvcigkbGxsbD0wOyRsbGxsPCRsbDskbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGwrK109JGxsbGxsbGxsbGwoJGxbJGxsbGxsXSkpOyRsbGxsbCsrOyRsbGxsbGxsKz0kbGw7fX1lbHNlJGxsbGxsbGxsWyRsbGxsbGxsKytdPSRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSk7JGxsbGxsbDw8PTE7JGxsbGxsbGxsbC0tO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JEMG5ZMmh5SnpzPSIpKTskbGxsbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkQwaVB5SXVKR3hzYkd4c2JHeHNiR3hzYkNnMk1pazciKSk7JGxsbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGw7KXskbGxsbGxsbGxsbC49JGxsbGxsbGxsbGxsbCgkbGxsbGxsbGxbJGxsbGxsKytdXjB4MDcpO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkM0OUpHeHNiR3hzYkd4c2JHd3VKR3hzYkd4c2JHeHNiR3hzYkNnMk1Da3VJajhpT3c9PSIpKTtldmFsKCRsbGxsbGxsbGwpOw=="));return;?>