snoopy74Hello all,
i want to transfer my online mysql db to my local mysql server.
i exported the tables on the webserver with phpmysql (v2.11.3) as a .sql file (default settings, received as uncompressed textfile and saved locally). so far - so good.
now i opened my local phpmyadmin installation (v2.11.9), created a db with the same name as the web-database and tried to import from the .sql file. it is working fine until the xxx_options table should be importet. during that table-import the message "#2006 - MySQL server has gone away" came up and the import stopped.
i deleted that part from the .sql file - tried again - and all was fine.
the highlight: that shown record (on top of the error msg) is an absolute spam shit record from wordpress:
INSERT IGNORE INTO xxx_options (option_id,blog_id,option_name,option_value,autoload) VALUES(90, 0, 'rss_38ddf8536035814fcb18cbfe07f77a11', 'O:9:"MagpieRSS":17:{s:6:"parser";i:0;s:12:"current_item";a:0:{}s:5:"items";a:43:{i:0;a:8:{s:5:"title";s:63:"Basic Thinking: Wordpress: Nur von Wordpress.org/.de downloaden";s:4:"link";s:88:"http://www.basicthinking.de/blog/2008/11/07/wordpress-nur-von-wordpressorgde-downloaden/";s:11:"description";s:137:"sonst läuft man Gefahr, dass man sich eine verseuchte Blog-Software installiert: Achtung: Fake WordPress Website im Netz aufgetaucht";s:4:"guid";s:41:"http://www.basicthinking.de/blog/?p=12775";s:7:"pubdate";s:31:"Thu, 06 Nov 2008 23:06:03 -0800";s:7:"content";a:1:{s:7:"encoded";s:273:"
sonst läuft man Gefahr, dass man sich eine verseuchte Blog-Software installiert: Achtung: Fake WordPress W[...]
What is that ??? Where is that record is coming from ?? I've never heart or written somehing like that. There are nonsense records in my database ... and they are blocking my datatransfer.
Has somebody an idea ?
Best regards,
Snoop
Edit: The sql statement is shown wrong. It's from the "code" tags those tags are also in that sql statement. I've checked that statement and it seems ok.
