WordPress.org

Ready to get started?Download WordPress

Forums

mySql import Failing because of WordPress Dashboard Widget Feed Data (1 post)

  1. NPSites
    Member
    Posted 3 years ago #

    hey I am starting to run into this a lot
    I develop a site locally then export the database and restore it to the server....

    When I attempt to restore the data there is garbage in the database that is part of the WordPress dashboard widgets. It is the downloaded feed data about WordPress News / Plugins... BLAH ... and it has characters in the data that is not playing nice

    I get the following error truncated partly because you dont need to read a hugeass error...

    As you can see its all that fricken feed crap in the Widgets on the front page of the dashboard no one reads or needs....

    and yes UTF8 out and in and it is standard dumps from mySql Administrator...

    This is happening quite a few times the only work around so far is to upload tables individually ... which is not fun because then i am saving a bunch of individual tables for my backups instead of saving a database dump...

    Turning off the configuring the feeds or removing the widgets from the dashboard does not empty the content from the database....

    thanks

    error below largely truncated

    Error while executing this query:INSERT INTO wp_options (option_id,blog_id,option_name,option_value,autoload) VALUES
    (254,0,'_transient_feed_a5420c83891a9c88ad2a4f04584a5efc','a:4:{s:5:\"child\";a:1:{s:0:\"\";a:1:{s:3:\"rss\";a:1:{i:0;a:6:{s:4:\"data\";s:3:\"\n \n\";s:7:\"attribs\";a:1:{s:0:\"\";a:1:{s:7:\"version\";s:3:\"2.0\";}}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:1:{s:7:\"channel\";a:1:{i:0;a:6:{s:4:\"data\";s:72:\"\n \n \n \n \n \n \n

    --------------------

    \"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:105:\"This plugin will generate a special XML sitemap which will help search engines to better index your blog.\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:1:{s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:4:\"Arne\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:4;a:6:{s:4:\"data\";s:30:\"\n \n \n \n \n \n \n \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:5:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:62:\"cincopa1 on \"Post video players slideshow and photo galleries\"\";s:7:\"attribs\";a:0:{}s:8:\"xml_base

    ------

    1:\"1355@http://wordpress.org/extend/plugins/\";s:7:\"attribs\";a:1:{s:0:\"\";a:1:{s:11:\"isPermaLink\";s:5:\"false\";}}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:124:\"You can have simple, concise stats with no additional load on your server by plugging into WordPress.com's stat system.\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:1:{s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:4:\"andy\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:12;a:6:{s:4:\"data\";s:30:\"\n \n \n \n \n

    -----------------------

    \"vary\";s:15:\"Accept-Encoding\";s:13:\"last-modified\";s:29:\"Wed, 17 Nov 2010 20:00:30 GMT\";s:14:\"content-length\";s:6:\"212691\";s:4:\"x-nc\";s:11:\"HIT luv 138\";s:13:\"accept-ranges\";s:5:\"bytes\";}s:5:\"build\";s:14:\"20090627192103\";}','no'),
    (155,0,'can_compress_scripts','1','yes');

    The server has returned this error message:Lost connection to MySQL server during query
    MySQL Error.

Topic Closed

This topic has been closed to new replies.

About this Topic