help restoring database (Page 1 of 2)

How big is your sql file, if it is to big then it can happen that nothing happens.

Maby you can restore it in little bits?

I splited the file but when i tried to import it here is what i got :

CREATE TABLE `bans` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(200) collate latin1_german2_ci default NULL, `ip` varchar(255) collate latin1_german2_ci default NULL, `email` varchar(50) collate latin1_german2_ci default NULL, `message` varchar(255) collate latin1_german2_ci default NULL, `expire` int(10) unsigned default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci -- -- Table structure for categories -- DROP TABLE IF EXISTS `categories`;
MySQL déclare:

Couldn't create table: bans

No way to restore, help please.

That's all but it seems to find another reason for every files

Last edited by MisterAwesome (2008-06-03 21:57:19)

I tried her is what i got :

Error at the line 25: DROP TABLE IF EXISTS `categories`;

Query: CREATE TABLE `bans` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(200) collate latin1_german2_ci default NULL,
`ip` varchar(255) collate latin1_german2_ci default NULL,
`email` varchar(50) collate latin1_german2_ci default NULL,
`message` varchar(255) collate latin1_german2_ci default NULL,
`expire` int(10) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci
DROP TABLE IF EXISTS `categories`;

MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `categories`' at line 10

Stopped on error

-- SQL dump commenced at Aujourd'hui 20:39:29
-- Generated by PunBB Backup Plugin
-- Dumping database `db214573164` - Database type: mysql

--
-- Table structure for bans
--

DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) collate latin1_german2_ci default NULL,
  `ip` varchar(255) collate latin1_german2_ci default NULL,
  `email` varchar(50) collate latin1_german2_ci default NULL,
  `message` varchar(255) collate latin1_german2_ci default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci

--
-- Table structure for categories
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(80) collate latin1_german2_ci NOT NULL default 'New Category',
  `disp_position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)

sorry ? He asked for the first 30 lines.

I got this error now :

Error at the line 37: INSERT INTO categories VALUES ('1', 'La série Futurama', '1');

Query: CREATE TABLE `categories` (
`id` int(10) unsigned NOT NULL auto_increment,
`cat_name` varchar(80) collate latin1_german2_ci NOT NULL default 'New Category',
`disp_position` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci
INSERT INTO categories VALUES ('1', 'La série Futurama', '1');

MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO categories VALUES ('1', 'La série Futurama', '1')' at line 7

If I remember correctly, it's because moved_to on the topics table is set to 0 when it shouldn't be.
Run the following queries:

alter table topics change moved_to moved_to INT(10) UNSIGNED
update topics set moved_to = null where moved_to=0

That is one query on each line. Either add semicolons to the end of each query or run them individually. In general, when people provide you with queries to run, they won't put semicolons at the end and each query is most easily run individually.

With what should I backup my DB in the future ?

I've been using PunBB Backup as well.

Can you link to the recommended Database Management plugin for 1.28?