Main > Main Forum

HyperSpin Owed Gambling Debts

<< < (3/3)

Martijn:

--- Quote from: Dazz on February 05, 2009, 09:48:22 pm ---Is anyone around here familiar with SSH and MYSQL setup? 

I have one table that is 111MB in size and I have not been able to get this one table imported into the database.  Unfortunately I am not familiar enough with MYSQL or SSH to change max_allowed_packet in order to get this imported.  I have searched online to see how to do it and I've tried, but no luck...

I can get logged into root via SSH,

I enter the following:

mysql -h localhost -u admin -p
Passcode:

max_allowed_packet=32M

but it doesn't appear to do anything after that and I don't know what to do.  We have sent a message to the hosting company and uploaded this database table to the site and asked if they could import it, but we have not heard from them.

I know I could manually edit my.cnf, but I can't figure out  how to even access that file to download/edit/upload it via SSH.  Anyone have any idea on how to do this?   If so please shoot me an IM at any of the IM's in my profile.  Thanks!




--- End quote ---

you should edit 2 settings  in php.ini

; Maximum size of POST data that PHP will accept.
post_max_size = 190M

; Maximum allowed size for uploaded files.
upload_max_filesize = 190M

and restart php

Navigation

[0] Message Index

[*] Previous page

Go to full version