vb.org Archive - Restore

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)

- - Restore (https://vborg.vbsupport.ru/showthread.php?t=152303)

Symbian Galaxy

07-15-2007 07:01 AM

Restore

I get error while restoring by SSH

Enter password:
ERROR 1064 (42000) at line 1: 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 '
Ô[ù¬ù¦cfP
ùõwn^Ýæ«2¿}s»<`zöIcîGfOéÎ6_ÅYüw¨gc(� �ñöõÏ?½¸3{²]0z¤' at line 1

Kirk Y

07-15-2007 08:17 PM

How was the dump you're restoring generated?

Shazz

07-15-2007 08:29 PM

If you back up from SSH and restore SSH you should have no problems.

Symbian Galaxy

07-16-2007 07:44 AM

I took that dump by mysqldumper

Snake

07-16-2007 10:49 AM

That's the worst mySQL tool I've ever seen so far. I highly recommend you to use BigDump. Much better, easier and faster. :)

http://www.ozerov.de/bigdump.php

encryption

07-16-2007 03:09 PM

Quote:

Originally Posted by Symbian Galaxy (Post 1291643)

I get error while restoring by SSH

Enter password:
ERROR 1064 (42000) at line 1: 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 '
?[????cfP
??wn^???2?}s?<`z?Ic?GfO??6_?Y?w?gc(????????3{?]0z?' at line 1

I could be wrong but it appears that the error was generated restoring the attachments table ? Try copying and pasting just that table via phpmyadmin.

Quote:

Originally Posted by Snake (Post 1292643)

That's the worst mySQL tool I've ever seen so far.

what makes you say that, I've used it endlessly on client transfers and have had more success rates on the whole. Even done restorations across different mysql versions and never noticed any screwups till date.

All times are GMT. The time now is 04:45 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01003 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: