Tag: dump
WordPress Error: Unknown column ‘post_category’ in ‘field list’
by admin on Oct.24, 2012, under Linux, Web Development
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 |
Output:
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:
- unknown column \post_category\ in \field list\
- error 1054 (42s22): unknown column \ in \field list\ wordpress
- error 1054 post_category wordpress
- select database error 1054 (42s22): unknown column in \field list\
- unknown column post_category in field list
How to Create a MySQL Backup of a big Database
by admin on Feb.02, 2010, under Linux, Web Development
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…)
Incoming search terms:
- backup big mysql
- mysql backup big database
- backup big database
- how to create backup from big database
- how to create backup from huge database
