HyperSpin Owed Gambling Debts

[Visitor Q]

http://www.hyperspin-fe.com/

Down but not out. 

[Dazz]

We moved the site to a new server. 

For the most part everything is ready to go, but I am still uploading the Downloads section (3gb).  I am also having an issue getting one freaking table imported into the database. 

[Ginsu Victim]

Must be that time of year....

[pinballwizard79]

lol at title 

[Dazz]

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!

[RayB]

Persnonally, I use PhpMyAdmin, and export the source DB to an sql file. Then on the new server, again use PhpMyAdmin and just paste in the SQL syntax to import the DB

[Dazz]

Persnonally, I use PhpMyAdmin, and export the source DB to an sql file. Then on the new server, again use PhpMyAdmin and just paste in the SQL syntax to import the DB

The database is 181mb... PhpMyAdmin times before the DB can be completely imported.

[Dazz]

Alrighty, I have the database backup and running...  I am doing a little testing to make sure that everything is working and will re-open the site shortly.

[Visitor Q]

Good to see it back up. 

Rumor is they took Billy's figure off in exchange. 

[Dazz]

Good to see it back up. 

Rumor is they took Billy's figure off in exchange. 

I wish someone would take my figure off... perhaps down to 145lbs and BUFF.

[Martijn]

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!

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