Gossamer Forum
Home : Products : Others : MySQLMan :

Re: [Andy] Mysql Error restoring Wordpress

Quote Reply
Re: [Andy] Mysql Error restoring Wordpress In reply to
Hi,

1) I made a backup on the server)

Code:
# MySQL dump
# Generated by MySQLMan 1.09 (http://gossamer-threads.com/scripts/)
# Host: localhost Database: rester_wordpress
#--------------------------------------------------------
#
# Table structure for table 'wx_categories'
#
DROP TABLE IF EXISTS wx_categories;
CREATE TABLE wx_categories (
cat_ID bigint(20) DEFAULT '' NOT NULL auto_increment,
cat_name varchar(55) DEFAULT '' NOT NULL ,
category_nicename varchar(200) DEFAULT '' NOT NULL ,
category_description longtext DEFAULT '' NOT NULL ,
category_parent bigint(20) DEFAULT '0' NOT NULL ,
category_count bigint(20) DEFAULT '0' NOT NULL ,
link_count bigint(20) DEFAULT '0' NOT NULL ,
posts_private tinyint(1) DEFAULT '0' NOT NULL ,
links_private tinyint(1) DEFAULT '0' NOT NULL ,
PRIMARY KEY (cat_ID),
KEY category_nicename (category_nicename)
);
#
# Dumping data for table 'wx_categories'
#
INSERT INTO wx_categories VALUES('1','Varie','varie','varie','0','1750','0','0','0');
INSERT INTO wx_categories VALUES('2','Links','links','','0','0','0','0','0');

2) I downloaded it to my pc
3) I replaced all
Code:
DEFAULT ''

with nothing

4) I Uploaded the modified file

Code:
# Generated by MySQLMan 1.09 (http://gossamer-threads.com/scripts/)
# Host: localhost Database: rester_wordpress
#--------------------------------------------------------
#
# Table structure for table 'wx_categories'
#
DROP TABLE IF EXISTS wx_categories;
CREATE TABLE wx_categories (
cat_ID bigint(20) NOT NULL auto_increment,
cat_name varchar(55) NOT NULL ,
category_nicename varchar(200) NOT NULL ,
category_description longtext NOT NULL ,
category_parent bigint(20) DEFAULT '0' NOT NULL ,
category_count bigint(20) DEFAULT '0' NOT NULL ,
link_count bigint(20) DEFAULT '0' NOT NULL ,
posts_private tinyint(1) DEFAULT '0' NOT NULL ,
links_private tinyint(1) DEFAULT '0' NOT NULL ,
PRIMARY KEY (cat_ID),
KEY category_nicename (category_nicename)
);
#
# Dumping data for table 'wx_categories'
#
INSERT INTO wx_categories VALUES('1','Varie','varie','varie','0','1750','0','0','0');
INSERT INTO wx_categories VALUES('2','Links','links','','0','0','0','0','0');
and it gave me the error.
Subject Author Views Date
Thread Mysql Error restoring Wordpress julius2007 16546 Nov 27, 2007, 1:59 AM
Thread Re: [julius2007] Mysql Error restoring Wordpress
Andy 16382 Nov 27, 2007, 2:06 AM
Thread Re: [Andy] Mysql Error restoring Wordpress
julius2007 16388 Nov 27, 2007, 3:04 AM
Thread Re: [julius2007] Mysql Error restoring Wordpress
Andy 16431 Nov 27, 2007, 3:09 AM
Post Re: [Andy] Mysql Error restoring Wordpress
julius2007 16388 Nov 27, 2007, 7:04 AM