• Registered: 2005-03-10
  • Posts: 31

Topic: Backups giving a hard time

I made a backup of my forum before wiping it completely clean. I installed a fresh 1.2.5, and then put the plugins in. I attempted to restore my backup, and all I keep getting is this:

Error imported backup file, the database probably has not been restored

What the hell!

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Backups giving a hard time

the old db backup plugin had some errors in it (basically it doesn't backup correctly) but don't worry you can fix the files,

open the backup

find (in create table forum_perms)

PRIMARY KEY (group_id)
or
PRIMARY KEY (forum_id)

replace with

PRIMARY KEY (group_id, forum_id)

find (in create table search_words)

PRIMARY KEY (id)
or
PRIMARY KEY (word)

replace with

PRIMARY KEY (word, id)

then try it

FluxBB.
Connorhd.co.uk.

Connorhd's Website

3 Reply by Daimon Link (edited by Daimon Link 2005-04-16 23:12)

  • Registered: 2005-03-10
  • Posts: 31

Re: Backups giving a hard time

Just tried it, I keep on getting the same error. sad

I had mods on my forum before, but they aren't exactly compatible with 1.2.5, so I didn't put them on. Please to God don't tell me that I need them in order to have my forums working.

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Backups giving a hard time

try restoring it in phpmyadmin so you can see what the actual error is

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-03-10
  • Posts: 31

Re: Backups giving a hard time

I know little, if anything, about phpmyadmin.. >.<

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Backups giving a hard time

can you come on #punbb @ irc.quakenet.org or email me the backup connorhd@mypunbb.com and i'll sort it out and mail it back

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-03-10
  • Posts: 31

Re: Backups giving a hard time

I sent you the email. Thank you very much for offering your help, I appreciate it.

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Backups giving a hard time

ok i've mailed you it back should work now

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-03-10
  • Posts: 31

Re: Backups giving a hard time

Thank you for your help, however it just isn't working. sad I fear for the worst...

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Backups giving a hard time

well that backup does work, i tried it myself, i suggest you setup http://www.phpmyadmin.net/ and try to restore it in that

FluxBB.
Connorhd.co.uk.

Connorhd's Website

11 Reply by Daimon Link (edited by Daimon Link 2005-04-16 23:56)

  • Registered: 2005-03-10
  • Posts: 31

Re: Backups giving a hard time

Do you think it could have anything to do with the version of PunBB? And also, if I were to have to use phpmyadmin, is there a line of code or something that I would need to input in order to use the .sql file? Oh yes, I also changed the name of the forum MySQL database, will that affect it?

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Backups giving a hard time

no, if you setup phpmyadmin, then go to the database you have punbb installed in, then press the SQL tab at the top, browse for the file and upload

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-03-10
  • Posts: 31

Re: Backups giving a hard time

Thank you very much ^_^ It worked!