USING SSH/Shell access how to restore

[AbDuLmAtEeNkHaN]

Dear Members and Mods,

I want to know step by step how to restore my xyz.sql data backed up from my old site n hosting want to upload it to bluehost the database only tried with myadminphp but not able to do so now with SSH/SHELL so please guide me will be thankful

Thanks,

[AbDuLmAtEeNkHaN]

When I was restoring the data i got this error what to do now?


ERROR 1153 (08S01) at line 110201: Got a packet bigger than 'max_allowed_packet' bytes

[AbDuLmAtEeNkHaN]

can any one tell me how to see how much max_allowed_packet i have ?

and is there a way i can increase my max_allowed_packet size ? my sql data is 1GB which i want to restore i just restored 104 MB data and got this error



ERROR 1153 (08S01) at line 110201: Got a packet bigger than 'max_allowed_packet' bytes

[areidmtm]

I would suggest contacting Bluehost support on the best way of doing this.

I would think that with a 1GB sql file, you'd going to run into problems. Running a command that large, will take a long time and will max out your CPU.

[AbDuLmAtEeNkHaN]

I would suggest contacting Bluehost support on the best way of doing this.

I would think that with a 1GB sql file, you'd going to run into problems. Running a command that large, will take a long time and will max out your CPU.

thanks for the replay at least i got a replay from some one .. regarding what you are saying to let ya know that its my total data .. just now i am uploaded my 150 MB data which is now i am uploaded in my public_html and restoring ... and getting the above error ....

i have contacted them but no replay from them so far .. :(

[Early Out]

i have contacted them but no replay from them so far .. :(Use Live Chat, instead of submitting a ticket.

[AbDuLmAtEeNkHaN]

Use Live Chat, instead of submitting a ticket.

done .. let see what they say ....

u dont know how to check allowed size? etc

one more Q? how to edit php.ini ..... i am unable to find it in public_html

[Early Out]

If there's no php.ini in public_html, you can just create one - it's a text file. Put in the entries you need for what you're doing. Copy that php.ini to every directory where there's PHP stuff.

I'm attaching the default BH php.ini from my own account, which has never been altered. You should be able to use that one, if you like. I zipped it so the forum software would swallow it (it won't let you attach .ini files to a forum post).

For whatever reason, Notepad doesn't line-break it properly, so you might be better off with another editor, like NoteTab Light (Google for it - it's a freebie).