I wanted to move one WordPress installation from one server to another. Therefore I began with a clean WordPress and tried to import the wp_posts table via sql:
wordpress@t30700:~/public_html/dev/blog$ mysql -u wordpress -p*PASSWORD* --database=wp_blog < wp_blog.sql
ERROR 1054 (42S22) at line 2: Unknown column 'post_category' in 'field list' ERROR 1054 (42S22) at line 2: Unknown column 'robotsmeta' in 'field list'
Incoming search terms:
It’s not possible to create a backup from a MySQL database with phpMyAdmin which is bigger than 2 MB. If you are running MySQL on a Linux based system, try this: (continue reading…)