Im trying to re install a saved DB via ssh and Im running this cmd:
/usr/local/psa/mysql/bin/mysql -uXXXXX -pXXXXX forum < httpdocs/skytronic.sql
And its coming back with this error?
ERROR 1065 at line 19: Query was empty
Does anyone know if this cmd is correct or Am I trying to it all wrong?
Thanks,
Brian
Its the only backup I have and if its gone so has 50,000 posts, 2,000 members and god knows what else.
I still have the sql file but I get errors when I try via ssh.
The original forum is gone. It ws on a dedicated server but I closed it down.
How can I view the sql file and edit it etc?
Thanks M8,
Brian :) i'm not sure how you'd identify corrupted entries since i never actually had to do this .. Chris Schreiber did this for bigsoccer.com's corrupted forum database a few months back
as to viewing and editing any txt editor other than windows notepad would be sufficient i.e. www.notetab.com notetab light or ultraedit would be able to do this
bear in mind that you might run out of memory if the sql file size is more than your phyiscal memory + pagefile
the sql file can be salvaged if you manually hand edit and remove corrupted entries of course do this on a copy of the sql file not the original one just in case
nothing wrong with your command's syntax
The original forum is gone. It ws on a dedicated server but I closed it down.
How can I view the sql file and edit it etc?
Thanks M8,
Brian :)
#If you have any other info about this subject , Please add it free.# |