Restore Questions

[hotshot]

For some reason my two rotation backups are ZERO KB! I do have some other backups, but when I restore from the one, I have no threads except stickys. Is there a way I could manually move over the MYD? Any advice. I have both MySQLadmin and mysql command line dumps on a Windows machine.

For some reason most of my databases won't restore even with a clean empty database. I get errors.

[hotshot]

For some reason my two rotation backups are ZERO KB! I do have some other backups, but when I restore from the one, I have no threads except stickys. Is there a way I could manually move over the MYD? Any advice. I have both MySQLadmin and mysql command line dumps on a Windows machine.

For some reason most of my databases won't restore even with a clean empty database. I get errors.

ERROR On restore without threads:

Table '2003forum.postparsed' doesn't exist

[Zachery]

What are the errors and how are you making the backups?

[hotshot]

What are the errors and how are you making the backups?

I have backups from three sources:

1) Vbulletin control panel
2) MySQL
3) MySQL Administrator

[hotshot]

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u myforum -p 2003for
um < backup.sql
Enter password:
ERROR 1062 (23000) at line 571691: Duplicate entry 'high?' for key 2


This sucks, I have tons of backups, and none will restore.

[Zachery]

Try creating a fresh database and importing.

[hotshot]

Try creating a fresh database and importing.

Like I said above, I tried it with clean installs no beans.

[Zachery]

What do you mean clean installs?

I'm asking you to create a fresh unused database and restore the backup.

[hotshot]

If you mean drop the database, and then create it again from scratch with no tables, I already tried that.

[hotshot]

I get all kinds of errors, I did a blank database with Vbulleting install creating the tables, I also tried just doing a restore with no database and the restore creates the database.

I am running it now with ignore errors and have gotten the following:

Warning: Error while executing this query:CREATE TABLE `access` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`accessmask` smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY `userid` (`userid`,`forumid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'access' already exists
Warning: Error while executing this query:CREATE TABLE `adminhelp` (
`adminhelpid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`action` varchar(25) NOT NULL default '',
`optionname` varchar(25) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '1',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`adminhelpid`),
UNIQUE KEY `phraseunique` (`script`,`action`,`optionname`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'adminhelp' already exists
Warning: Error while executing this query:CREATE TABLE `administrator` (
`userid` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`navprefs` mediumtext,
`cssprefs` varchar(250) NOT NULL default '',
`notes` mediumtext,
`languageid` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'administrator' already exists
Warning: Error while executing this query:CREATE TABLE `adminlog` (
`adminlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`script` varchar(20) NOT NULL default '',
`action` varchar(20) NOT NULL default '',
`extrainfo` varchar(200) NOT NULL default '',
`ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`adminlogid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'adminlog' already exists
Warning: Error while executing this query:CREATE TABLE `adminutil` (
`title` varchar(50) NOT NULL default '',
`text` mediumtext NOT NULL,
PRIMARY KEY (`title`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'adminutil' already exists
Warning: Error while executing this query:CREATE TABLE `announcement` (
`announcementid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`startdate` int(10) unsigned NOT NULL default '0',
`enddate` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`forumid` smallint(6) NOT NULL default '0',
`allowhtml` smallint(5) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`allowbbcode` smallint(5) unsigned NOT NULL default '0',
`allowsmilies` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`announcementid`),
KEY `forumid` (`forumid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'announcement' already exists
Warning: Error while executing this query:CREATE TABLE `attachment` (
`attachmentid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`filedata` mediumblob,
`visible` smallint(5) unsigned NOT NULL default '0',
`counter` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`filesize` int(10) unsigned NOT NULL default '0',
`thumbnail` mediumblob,
`filehash` varchar(32) NOT NULL default '',
`posthash` varchar(32) NOT NULL default '',
`thumbnail_dateline` int(10) unsigned NOT NULL default '0',
`thumbnail_filesize` int(10) unsigned NOT NULL default '0',
`extension` varchar(20) NOT NULL default '',
PRIMARY KEY (`attachmentid`),
KEY `posthash` (`posthash`,`userid`),
KEY `postid` (`postid`),
KEY `filesize` (`filesize`),
KEY `filehash` (`filehash`),
KEY `userid` (`userid`),
KEY `visible` (`visible`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
The server has returned this error message:Table 'attachment' already exists

[Zachery]

You do not need to install vBulletin before restoring the backup if anything this is going to cause more problems.

[hotshot]

You do not need to install vBulletin before restoring the backup if anything this is going to cause more problems.

I have already tried it with an empty database, nothing will import correctly.

[hotshot]

I'm getting closer, noticed in one of the backups that the following is causing the backup to stop. Basically the following line is in there twice except the 101275 value is different. I remove one and it goes on to the next stage of the backup. So far three duplicate word entries.


INSERT INTO word VALUES('101475', 'high');


and the restore will generate this at the command line:

ERROR 1062 (23000) at line 571691: Duplicate entry 'high?' for key 2

[Steve Machol]

Try repairing that database then making a new backup and restoring that.

[hotshot]

I pulled a backup from 6/2006 of the web site and the SQL database, restored the database, and site, and everything works.

The problem now is when I try to run the install wizard for 3.62 it does not work. :-(
I am running MySQL 4.15


Also if you read more you will see one database restore generates: ERROR 1062 (23000) at line 571691: Duplicate entry 'high?' for key 2

Sure enough, you look in the word list and it's trying to add high? twice.