MySQLDumper-Board Forum Index Follow me on Twitter

Portal  •   Forum  •  Downloads  •  Profile  •  Search   •  Register  •  Log in to check your private messages  •  Log in  •  


 Backup Fine, but during restoring error

Post new topicReply to topic
Author Message
damage.revolution
knows MySQLDumper
knows MySQLDumper





Joined: 28 Nov 2008
Posts: 8


blank.gif

PostPosted: 2008-11-28, 23:06    Backup Fine, but during restoring error Reply with quoteBack to top

Hi

I am backing up my database through mysqldumper.

which file format backup should i checked?

Image

tried to leave it to the default checking "Complete Inserts", when i restored to the new server i received following error through bigdump


    Error at the line 1350488: INSERT INTO `phpbb_search_wordmatch` (`post_id`,`word_id`,`title_match`) VALUES ('545104','1426','0');

    Query: INSERT INTO `phpbb_search_wordmatch` (`post_id`,`word_id`,`title_match`) VALUES ('545104','1426','0');

    MySQL: Duplicate entry '1426-545104-0' for key 1

    Stopped on error



please help

thx

OfflineView user's profileSend private message    
Anzeigen











Posted:    Anzeigen Back to top


    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2008-11-28, 23:23    (No subject) Reply with quoteBack to top

The backup is fine. The problem you ran into has to do with different MySQL-Versions but can be ignored. All data is handled correctly.

Just go to the configuration, choose "general" and at the "restore"-section switch "Error Handling while restoring" to "continue and log errors". Save your new configuration and restart the import.
This should do the job.

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
damage.revolution
knows MySQLDumper
knows MySQLDumper





Joined: 28 Nov 2008
Posts: 8


blank.gif

PostPosted: 2008-12-02, 09:50    (No subject) Reply with quoteBack to top

thanks alot DSB

currently i am restoring my backup files and it stopped at 47,42% for more than half an hour now.

it didnt show any sign of restoring either anything to higher percentage, perhaps i am doing something wrong here?

please advise. thanks

OfflineView user's profileSend private message    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2008-12-02, 14:21    (No subject) Reply with quoteBack to top

The server didn't answer for some reason I don't know.
Just hit the "back"-button of your browser.

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Ältere Beiträge und User aus früherem... abelius-kiel Allgemeine Fragen zu MySQLDumper 3 2012-04-22, 10:16 View latest post
No new posts Backup bricht ab Timm85 Fehler / Probleme 2 2012-04-21, 00:20 View latest post
No new posts Backup mit FTP ist leer pelikan1999 Gelöst/Erledigt 9 2012-04-07, 18:05 View latest post
No new posts Backup Error Vengeance66 Errors and questions 4 2012-04-02, 16:52 View latest post
No new posts MySQL-ERROR / nach phpmyadmin passwor... stone_22 MySQLDumper 1.24 4 2012-03-31, 00:40 View latest post

 
CrackerTracker © 2004 - 2012 CBACK.de

Powered by Orion based on phpBB © 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours

phpBB SEO