| Author |
Message |
ghundermark
knows MySQLDumper
Joined: 03 Dec 2011
Posts: 4
|
 Posted:
2011-12-03, 23:08 An Error I can't make sense of. |
  |
Hello,
MySQLDumper appears to run successfully for a large database import ( for approximately 32 minutes) and then crashes. Here are some more details.
1. MySQLDumper Version 1.24.4
2. I am using MySQL-Version: 5.5.16 & PHP-Version: 5.3.8
3. The only further information that I know is that this is during an SMF forum database import. I also have a screenshot that is attached (sorry for not copying and pasting).
4. N/A
5. I have not been able to troubleshoot much because I do not know a lot about mySQL databases and the error message I got is not in English. I tried to search the forum for errors similar to mine but I wasn't able to get very far.
6. The server is localhost via xampp.
7. The goal is to get the database imported into phpMyAdmin, which I have used moderately in the past.
Thank you in advance. Let me know if you need any other information.
EDIT: I just tried to re-import and and I was able to copy and paste the error this time. It does not appear to be completely identical to the error below.
Array
(
[max_zeit] => 22
[startzeit] => 1322949413
[xtime] => 1322947343
[fileEOF] =>
[actual_table] => smf_messages
[offset] => 655018505
[aufruf] => 324
[table_ready] => 121
[part] => 0
[do_it] =>
[errors] => 0
[notices] => 0
[anzahl_eintraege] => -1
[anzahl_tabellen] => -1
[filename] => atwdb_backup.sql
[actual_fieldcount] => 0
[eintraege_ready] => 5468013
[anzahl_zeilen] => 28982
[summe_eintraege] => 5447715
[erweiterte_inserts] => 0
[flag] => -1
[EOB] =>
[dump_encoding] => utf8
[compressed] => 0
[tables_to_restore] =>
[filehandle] => Resource id #15
[tablelock] => 0
[insert_syntax] => INSERT INTO `smf_messages`
)
Sql: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
Erweiterte Inserts: 0
unknown SQL-Command: "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
   |
|
Anzeigen
|
|
Posted:
Anzeigen |
|
| Description: |
|
| Filesize: |
1.01 MB |
| Viewed: |
174 Time(s) |
|
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-12-04, 00:01 (No subject) |
|
This is easy.
Your backup is not complete. The part
DOCTYPE html ...
is part of your backup and therefor is not valid SQL. Instead it is part of the html error page that was sent while doing the backup.
That means: the programm you made the backup with didn't complete its job and instead of informing you about the error, it simply said nothing.
That also means: this backup is worthless because it doesn't hold all data of all tables. If you used phpMyAdmin to create a backup your are just one more victim of it's timeouts. That's why we created MySQLDumper. 
So the problem is not MySQLDumper restoring the backup, but your incomplete backup file.
If you still have access to the original database, try doing a backup using MySQLDumper.
_________________
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.
|
|
  |
|
ghundermark
knows MySQLDumper
Joined: 03 Dec 2011
Posts: 4
|
|
Posted:
2011-12-04, 00:10 (No subject) |
|
« DSB » wrote: This is easy.
Your backup is not complete. The part
DOCTYPE html ...
is part of your backup and therefor is not valid SQL. Instead it is part of the html error page that was sent while doing the backup.
That means: the programm you made the backup with didn't complete its job and instead of informing you about the error, it simply said nothing.
That also means: this backup is worthless because it doesn't hold all data of all tables. If you used phpMyAdmin to create a backup your are just one more victim of it's timeouts. That's why we created MySQLDumper.
So the problem is not MySQLDumper restoring the backup, but your incomplete backup file.
If you still have access to the original database, try doing a backup using MySQLDumper.
Thank you. I will try that now...
It's so disturbing to realize that I could have been doing incomplete backups of my database via Godaddy & phpMyAdmin for years and not even know it!
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16049
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-12-04, 00:32 (No subject) |
|
« ghundermark » wrote: It's so disturbing to realize that I could have been doing incomplete backups of my database via Godaddy & phpMyAdmin for years and not even know it!
Yes. I do love PhpMyAdmin as a program to edit your data. It is really brilliant for such things.
But when it comes to backups I absolutely hate it. It echos the data to a file stream - and so it does if an error occurs! So you get your download file and you have no idea that an error occured. This even is the case in the actual version and I can't understand why their developers are not willing to change this. Users have no idea that something went wrong. I think this is irresponsible.
The net is full with screams of people with incomplete backups.
_________________
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.
|
|
| |
|
|
|
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
|
