Huge Database upload/dumps

1-13-05, 02:48 AM

I have a 119mb database (22mb gziped) that i need to be able to upload into a mySQL. By the look of PHPadmin i can only do around 2mb at a time.. do i have to split it up??? some of my tables are actually around 35mb.. how can i do this? is this possible? will i need someone at Powweb actually do it for me?

Need some help..

1-13-05, 02:58 AM

You could ftp the dump to your server and then use php to do the import.

mitchind · 1-13-05, 12:04 PM

If you can get the output file in tab-delimited format, no header and get your gzip files around 5MB or less you can use a passthru command "mysqlimport" to bring the data in.

Otherwise I read somewhere that Powweb will do the imports for you if databases are large. Send them a support request.

1-14-05, 02:02 AM

how would we go about that?

1-14-05, 11:02 PM

this is what I got from support... seems pretty cut and dry...
_________________
Hello,

Unfortunately for databases of this size the only way to restore it is via
our admins. To submit these requests as efficiently as possible, please
provide us with the following information:

1) Upload the unzipped .dmp or .sql file into the root of your webspace via
FTP. Include the name of this file (and the path if you don't put it in the
root) with your request.
2) FTP username and server name.
3) mySQL database name and server name.
4) The last 4 digits of the credit card on file for identity verification.

With all this information we should be able to process the first request
without any back-and-forth.

_________________

1-13-05, 02:48 AM	#1
syco2000 Posts: n/a	Huge Database upload/dumps I have a 119mb database (22mb gziped) that i need to be able to upload into a mySQL. By the look of PHPadmin i can only do around 2mb at a time.. do i have to split it up??? some of my tables are actually around 35mb.. how can i do this? is this possible? will i need someone at Powweb actually do it for me? Need some help..

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

1-13-05, 02:58 AM	#2
det1smc Posts: n/a	You could ftp the dump to your server and then use php to do the import.

1-13-05, 12:04 PM	#3
mitchind Older not wiser Join Date: Nov 2003 Location: Calgary, AB Posts: 2,473 Reputation: 205	If you can get the output file in tab-delimited format, no header and get your gzip files around 5MB or less you can use a passthru command "mysqlimport" to bring the data in. Otherwise I read somewhere that Powweb will do the imports for you if databases are large. Send them a support request.

1-14-05, 02:02 AM	#4
jeremyp Posts: n/a	how would we go about that?

1-14-05, 11:02 PM	#5
syco2000 Posts: n/a	this is what I got from support... seems pretty cut and dry... _________________ Hello, Unfortunately for databases of this size the only way to restore it is via our admins. To submit these requests as efficiently as possible, please provide us with the following information: 1) Upload the unzipped .dmp or .sql file into the root of your webspace via FTP. Include the name of this file (and the path if you don't put it in the root) with your request. 2) FTP username and server name. 3) mySQL database name and server name. 4) The last 4 digits of the credit card on file for identity verification. With all this information we should be able to process the first request without any back-and-forth. _________________