I have my .sql file that I'm trying to import via phpmyadmin but when I import nothing ever happens. The file is quite large so maybe timing out? What are my options? and could you point me on how to exercise these options.
Announcement
Collapse
No announcement yet.
Invision Free Help
Collapse
X
-
I found this list for 2.0 http://forums.invisionpower.com/lofi...p/t153927.html but not sure if that works with 1.3
Comment
-
If the backup was made correctly, then it should create the necessary table.
Note: The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:
http://www.vbulletin.com/docs/html/m...ce_ssh_restoreSteve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Originally posted by Steve Machol View PostIf the backup was made correctly, then it should create the necessary table.
Note: The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore
Comment
-
That's correct. And if this file was created correctly it has all the commands neccessary to create those tables, otherwise it's not a real backup.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Just follow the restore instructions I posted previously.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Some people have reported success with these scripts:
MySQLDumper:
http://www.mysqldumper.de/en/index.php
MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopySteve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Ok I did the mysqldumper thing and got this when I tried to restore.:
Code:Array ( [num_table_fields] => Array ( ) [max_zeit] => 22 [startzeit] => 1159813252 [xtime] => 1159813252 [fileEOF] => [actual_table] => ibf_badwords [offset] => 0 [aufruf] => 1 [table_ready] => 0 [part] => 0 [do_it] => [errors] => 0 [notices] => 0 [anzahl_eintraege] => -1 [anzahl_tabellen] => -1 [filename] => 1159775083.sql [actual_fieldcount] => 0 [eintraege_ready] => 0 [anzahl_zeilen] => 110 [summe_eintraege] => 0 [erweiterte_inserts] => 0 [flag] => -1 [EOB] => [insert_syntax] => [kind] => 0 [compressed] => 0 [filehandle] => Resource id #12 ) Couldn't read rowcount for table ibf_badwords! Restore:ibf_badwords
Comment
-
It looks like this is a bad backup file. I'd ask them to provide a new one.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment