MySQLDumper-Board Forum Index Follow me on Twitter

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


 Error when restoring with mysqldumper

Post new topicReply to topic
Author Message
gock
knows MySQLDumper
knows MySQLDumper





Joined: 10 Nov 2011
Posts: 3


blank.gif

PostPosted: 2011-11-10, 20:36    Error when restoring with mysqldumper Reply with quoteBack to top

Hello guys,

I'm having this trouble when using mysqldumper to restore a database (made with auto daily backup) to another database.

here is the error

Array
(
    [max_zeit] => 22
    [startzeit] => 1320949866
    [xtime] => 1320949865
    [fileEOF] =>
    [actual_table] => unbekannt
    [offset] => 0
    [aufruf] => 1
    [table_ready] => 0
    [part] => 0
    [do_it] =>
    [errors] => 0
    [notices] => 0
    [anzahl_eintraege] => -1
    [anzahl_tabellen] => -1
    [filename] => forum-2011-11-10.tar.gz
    [actual_fieldcount] => 0
    [eintraege_ready] => 0
    [anzahl_zeilen] => 198
    [summe_eintraege] => 0
    [erweiterte_inserts] => 0
    [flag] => -1
    [EOB] =>
    [dump_encoding] => utf8
    [compressed] => 1
    [tables_to_restore] =>
    [filehandle] => Resource id #15
    [tablelock] => 0
)

Sql: home/sever/new_bk/forum_backup.sql0000644000175100017520551201610111656574011016654 0ustar seversever-- MySQL dump 10.11
Erweiterte Inserts: 0
unknown SQL-Command:

home/sever/new_bk/forum_backup.sql0000644000175100017520551201610111656574011016654 0ustar seversever-- MySQL dump 10.11


Can anyone help me to find a solution of it?

Thank you

OfflineView user's profileSend private messageAIM Address    
Anzeigen











Posted:    Anzeigen Back to top


    
Jens_K
Moderator
Moderator




Age: 37
Joined: 04 Sep 2007
Posts: 1709
Location: Nähe Bielefeld


germany.gif

PostPosted: 2011-11-10, 21:26    (No subject) Reply with quoteBack to top

That seems not to bee an SQL file you are trying to import.

Normally, backup files have the extension .sql.gz, not .tar.gz ...

_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog

OfflineView user's profileSend private messageVisit poster's website    
gock
knows MySQLDumper
knows MySQLDumper





Joined: 10 Nov 2011
Posts: 3


blank.gif

PostPosted: 2011-11-10, 22:26    Hi Reply with quoteBack to top

One of my customer sent it to me using his daily backup.

any chance to test if it was a database backup or converter to sql.gz so it can work with mysqldumper?

Anw thank you so much for your quick response

OfflineView user's profileSend private messageAIM Address    
gock
knows MySQLDumper
knows MySQLDumper





Joined: 10 Nov 2011
Posts: 3


blank.gif

PostPosted: 2011-11-10, 22:28    (No subject) Reply with quoteBack to top

Nvm, you are absolutely right. it was a wrong type of database, correct file resolved the problem.

Thank you for providing this great product.

Edited:

I'm now having this error, any idea?

Warning: mysql_query() [function.mysql-query]: MySQL server has gone away in C:\Program Files (x86)\VertrigoServ\www\dumper\restore.php on line 131

Warning: mysql_query() [function.mysql-query]: Error reading result set's header in C:\Program Files (x86)\VertrigoServ\www\dumper\restore.php on line 131
MySQL-ERROR
MySQL says:
MySQL server has gone away

Error in Query:
CREATE TABLE `customprofilepic` ( `userid` int(10) unsigned NOT NULL default '0', `filedata` mediumblob, `dateline` int(10) unsigned NOT NULL default '0', `filename` varchar(100) NOT NULL default '', `visible` smallint(6) NOT NULL default '1', `filesize` int(10) unsigned NOT NULL default '0', `width` smallint(5) unsigned NOT NULL default '0', `height` smallint(5) unsigned NOT NULL default '0', `importcustomprofilepicid` bigint(20) NOT NULL default '0', PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Fatal error: Couldn't create table or view `customprofilepic´

Regards,

OfflineView user's profileSend private messageAIM Address    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Serverumzug - von Hoster zu Hoster mi... soigroeg Allgemeine Fragen zu MySQLDumper 1 2012-05-21, 13:36 View latest post
No new posts Autodelete without visiting MySQLDump... DrewC Errors and questions 5 2012-04-13, 17:37 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
No new posts Error beim wiederherstellen der Daten... nefertia Errors and questions 4 2012-03-28, 18:59 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