Anyone willing to test some things for me?

Started by [Unknown], October 17, 2004, 01:22:35 AM

Previous topic - Next topic

Fabbritzio

QuoteUndefined index: line in /home/..../forum/restore_backup.php on line 191

What can I do? I have this message when I use restore_backup.php , I don't change nothing in data base.

Charles Maxwell

Alright - running the restore_backup.php on a 7.41 MB SQL file, I get the following error:

Some of the queries were not executed properly. Technical information about the queries:
Line #3434: BLOB column 'post' used in key specification without a key length
Line #3697: Table 'daiship71.ibf_posts' doesn't exist
Line #3955: Table 'daiship71.ibf_posts' doesn't exist
Line #4213: Table 'daiship71.ibf_posts' doesn't exist
Line #4466: Table 'daiship71.ibf_posts' doesn't exist

Anyone able to advise a workaround for this one?

Best regards,

Max

H

What did you use to create the backup?

It looks like the create table statements aren't in the backup.
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Charles Maxwell

Believe it or not, I used the included create_backup.php. Any suggestions?

H

-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Charles Maxwell

SMF?

I'm actually using this to transfer the database between two Invision Power Board installs.

H

You will need to find the posts create table query in the install for ipb and then run it with phpmyadmin or something similar.

I would give you the query but I don't have it as I run SMF not IPB.

Maybe you should consider converting to SMF :P
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Charles Maxwell

If I were to run the default installer for IPB (which creates the database), and then, after that, run the 'restore_backup' script, do you think it might work around the problem?

H

-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Charles Maxwell

Fantastic. Thanks! I'll try that now, and then advise of the result.

Charles Maxwell


ketchup

How can I change this data back into a text type file which I would get from downloading through the database backup feature?

thanks

alexsbrown

I just used it to backup our production forum and restore it to a test environment, and it worked like a charm. It was so much faster and less frustrating than other methods I have used.

Our forum is small, with only about 350 members and 850 messages right now.

I think this utility ought to come out of the "anyone willing to test" post here, and onto one of the FAQ pages. Right now the FAQs make it sound like the php database Admin utility is the only way to migrate data, but this is actually much more effective.

Can anyone do that? If we need basic instructions, like in the current FAQs, I am happy to write something up. I do not want to presume to post these somewhere, though, when they are Unknown's work.

LuckyOne

After my forum grew so large that I could no longer use SMF's built in backup database, I started to use phpMyAdmin for backing up purposes.  When that stopping working, I installed [Unknown]'s create/restore backup utility.  It worked for a while, but now that, too, no longer works.  Instead, the backup gets to 100% and then produces the blank white screen of death.

Does anyone have suggestions on how I can get [Unknown]'s tool to work again?  Or maybe other backup ideas?

Thank you!

-LuckyOne

jefforig

Wow.   :D
That worked great.
Super easy and everything seems to be there.

gupp

I did find that if you have multiple forums and you aren't careful in changing the default paths that you can restore the wrong forum, thereby totally destroying one that wasn't broken in the first place, and that you foolishly didn't back up because, of course, that wasn't the one you were working on. sigh

gilestel

#96
well i used this restore backup thing, but it didn't restore all the data...most of the messages are there, but the topics are not visible...very odd..

BigGunn

yeah I had a problem with a "duplicate entry" in one of the tables "smf_log_search_topics"

all of my members and boards were extracted from the .sql file, but even though it says the posts are there, you can't see them at all. I did a "recount" on the post stats and stuff and it all got set back to zero.

2MinuteDrill

#98
so close.

I'm so close to having the file restored.. as soon as I got it to run.. this is what I got.


Some of the queries were not executed properly. Technical information about the queries:
Line #33: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=3' at line 33
Line #60: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=6' at line 19
Line #95: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=6' at line 24
Line #119: 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 'DEFAULT CHARSET=latin1' at line 13
Line #1027: Duplicate entry '-1-0-poll_view' for key 1
Line #1057: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=30' at line 29
Line #1095: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 19
Line #1114: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=168' at line 18
Line #1286: Duplicate entry '1' for key 1
Line #1300: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=7' at line 13
Line #1322: 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 'DEFAULT CHARSET=latin1' at line 11
Line #1345: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 22
Line #1368: 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 'DEFAULT CHARSET=latin1' at line 22
Line #1375: Duplicate entry '2007-03-03' for key 1
Line #1391: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 15
Line #1409: 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 'DEFAULT CHARSET=latin1' at line 17
Line #1434: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 24
Line #1451: 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 'DEFAULT CHARSET=latin1' at line 16
Line #1472: 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 'DEFAULT CHARSET=latin1' at line 14
Line #1490: 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 'DEFAULT CHARSET=latin1' at line 17
Line #1509: 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 'DEFAULT CHARSET=latin1' at line 18
Line #1552: 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ID_MEMBER` me
Line #1571: 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 'DEFAULT CHARSET=latin1' at line 12
Line #2839: 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 'DEFAULT CHARSET=latin1' at line 11
Line #2859: 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 'DEFAULT CHARSET=latin1' at line 19
Line #2877: 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 'DEFAULT CHARSET=latin1' at line 17
Line #2885: Duplicate entry 'smf-1' for key 1
Line #2897: 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 'DEFAULT CHARSET=latin1' at line 11
Line #2916: 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 'DEFAULT CHARSET=latin1' at line 18
Line #2938: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=33' at line 21
Line #2971: Duplicate entry '1' for key 1
Line #3041: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=370' at line 69
Line #3200: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=13' at line 15
Line #3217: Duplicate entry '1' for key 1
Line #3249: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=88431' at line 31
Line #57057: 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 'DEFAULT CHARSET=latin1' at line 11
Line #57076: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 12
Line #57082: Duplicate entry '1' for key 1
Line #57095: 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 'DEFAULT CHARSET=latin1' at line 12
Line #57139: Duplicate entry '-1-search_posts' for key 1
Line #57158: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=25809' at line 18
Line #59027: 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 'DEFAULT CHARSET=latin1' at line 16
Line #60893: 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 'DEFAULT CHARSET=latin1' at line 13
Line #61432: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=278' at line 18
Line #61545: 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 'DEFAULT CHARSET=latin1' at line 12
Line #61564: 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 'DEFAULT CHARSET=latin1' at line 11
Line #61733: Duplicate entry 'smfVersion' for key 1
Line #61750: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=46' at line 16
Line #61800: Duplicate entry '6' for key 1
Line #61815: 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 'DEFAULT CHARSET=latin1' at line 14
Line #61852: Duplicate entry '1-0-name' for key 1
Line #61878: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4567' at line 25


Although it seems as if 99% stuff transfered.

GP

Rookie question time:  I'm currently trying to restore a small db - 9.25mb .gz

The back up restoration tool seems to have stopped at "step 2".  What would prevent
it from continuing?

Advertisement: