Build Your Own Arcade Controls Forum

Main => Main Forum => Topic started by: Visitor Q on February 05, 2009, 02:04:51 pm

Title: HyperSpin Owed Gambling Debts
Post by: Visitor Q on February 05, 2009, 02:04:51 pm

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

Down but not out.  ;)

Title: Re: HyperSpin Owed Gambling Debts
Post by: Dazz on February 05, 2009, 04:34:09 pm

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. 

Title: Re: HyperSpin Owed Gambling Debts
Post by: Ginsu Victim on February 05, 2009, 04:36:48 pm

Must be that time of year....

Title: Re: HyperSpin Owed Gambling Debts
Post by: pinballwizard79 on February 05, 2009, 08:11:43 pm

lol at title  :cheers:

Title: Re: HyperSpin Owed Gambling Debts
Post by: 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!

Title: Re: HyperSpin Owed Gambling Debts
Post by: RayB on February 05, 2009, 10:26:39 pm

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

Title: Re: HyperSpin Owed Gambling Debts
Post by: Dazz on February 05, 2009, 11:30:44 pm

Quote from: RayB on February 05, 2009, 10:26:39 pm

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.

Title: Re: HyperSpin Owed Gambling Debts
Post by: Dazz on February 06, 2009, 01:16:55 am

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.

Title: Re: HyperSpin Owed Gambling Debts
Post by: Visitor Q on February 06, 2009, 07:19:57 am

Good to see it back up.  :applaud:

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

Title: Re: HyperSpin Owed Gambling Debts
Post by: Dazz on February 06, 2009, 08:33:53 am

Quote from: Visitor Q on February 06, 2009, 07:19:57 am

Good to see it back up.  :applaud:

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

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

Title: Re: HyperSpin Owed Gambling Debts
Post by: Martijn on February 06, 2009, 08:43:00 am

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!

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