| Author |
Message |
gapa
MySQLDumper-Translator
Joined: 10 Sep 2010
Posts: 7
|
 Posted:
2011-11-15, 13:00 error on restore |
  |
Hello,
I am trying to restore database which was created with phpmyadmin. Have tried with sql and I also tried to compress this file with 7-zip to sql.gz. I am getting this error:
Array
(
[max_zeit] => 22
[startzeit] => 1321354755
[xtime] => 1321354732
[fileEOF] =>
[actual_table] => actions
[offset] => 0
[aufruf] => 1
[table_ready] => 1
[part] => 0
[do_it] =>
[errors] => 0
[notices] => 0
[anzahl_eintraege] => -1
[anzahl_tabellen] => -1
[filename] => baza_remote_11_10_26.sql
[actual_fieldcount] => 0
[eintraege_ready] => 0
[anzahl_zeilen] => 100
[summe_eintraege] => 0
[erweiterte_inserts] => 0
[flag] => -1
[EOB] =>
[dump_encoding] => utf8
[compressed] => 0
[tables_to_restore] =>
[filehandle] => Resource id #13
[tablelock] => 0
)
Sql: REPLACE INTO `actions` (`aid`, `type`, `callback`, `parameters`, `label`) VALUES
Erweiterte Inserts: 0
unknown SQL-Command: ('comment_publish_action', 'comment', 'comment_publish_action', '', 'Publish comment'),
REPLACE INTO `actions` (`aid`, `type`, `callback`, `parameters`, `label`) VALUES
What could be a problem? And it would be hard to get database exported again with mysqldumper.
best regards,
gapa
|
|
   |
|
Anzeigen
|
|
Posted:
Anzeigen |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16067
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-11-15, 15:31 (No subject) |
|
In your Backup file replace all occurances of "REAPLCE INTO" with "INSERT INTO".
_________________
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.
|
|
  |
|
gapa
MySQLDumper-Translator
Joined: 10 Sep 2010
Posts: 7
|
|
Posted:
2011-11-15, 18:08 (No subject) |
|
I got one step further. I don't get that error but new one. This is Drupal database. How can I bypass this problem. I know I started to use MySQLDumper because it was working when all the others failed right on this kind of problem.
Quote:
MySQL-ERROR
MySQL says:
MySQL server has gone away
Error in Query:
CREATE TABLE IF NOT EXISTS `cache_page` ( `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Cache table used to store compressed pages for anonymous...';
Fatal error: Couldn't create table or view `cache_page´
|
|
| |
|
gapa
MySQLDumper-Translator
Joined: 10 Sep 2010
Posts: 7
|
|
Posted:
2011-11-15, 21:11 (No subject) |
|
|
| |
|
|
|
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
|
