So I acquired a database that is 70 megs when compressed. It is a .sql file and when i open it, i get a message saying my virtual memory is too low. Since, myphpadmin has an upload limit of 50 megs it won't upload the fiel and build the database. I thought of cutting it up into smaller text fiels but again I can't even open it properly because my virtual memory runs too low. Any ideas on how to upload the database onto my server. Willing to pay if you can help me out.
Thanks

9/9/2005 4:50:41 PM

Do you have access to a shell? You could just import it using mysqlimport

[Edited on September 9, 2005 at 5:09 PM. Reason : .]

9/9/2005 5:09:40 PM

nope, any other ways?

9/9/2005 5:19:57 PM

uh

I'd either

a) increase the virtual memory settings on your computer

or

b) increase the virtual memory settings on your computer

9/9/2005 5:31:57 PM

how?
yeah go ahead and make fun of me, but i don't know how to do it

9/9/2005 5:34:50 PM

Solution A.)

start by hitting F1

then search for virtual memory

it will tell you how

Solution B.)

go to microsoft.com

search for increasing virtual memory


OH SNAP I'M GOOD

9/9/2005 6:22:45 PM

or c) right click "my computer". hit properties. click the advance tab and click the first button on that tab and on the advanced tab of the new window you can edit the virtual mem.

9/9/2005 6:25:02 PM

I appreciate the help

9/9/2005 8:52:17 PM

use the CLI tool to insert it
at console run

mysql -uusername -ppassword databasename < data.sql

[Edited on September 10, 2005 at 5:37 PM. Reason : now plz to send me $$]

9/10/2005 5:37:16 PM

Can you uncompress it and split the files into <50 meg chunks? Just run them in order and you should be OK.

9/13/2005 9:20:30 PM

50 meg limit is a phpmyadmin limit
probably php upload size limit
there is no limit if you do it using the mysql binary
i have restored multi-gig databases using it...

9/13/2005 11:34:49 PM

That's cool but 3rd post above says he has no shell access, that's why he's looking for other ways to use the tool that has the 50 meg limit.

9/14/2005 9:29:35 AM

yeah i was going to split it up but for some reason my shitty ass computer froze every time i opened it, so i just emailed my host and they did it for me.

9/14/2005 11:09:59 AM

I have uploaded mysql files that are many times larger than your file using a php script I found on the web a few years ago. First you upload the file via ftp to the server and then run the script which connects to the mysql database and transfers it over several hundred records at a time.

Send me a pm with your email address and I will email you the script. ...of course it does require PHP which you should already have for phpmyadmin.

9/15/2005 1:03:28 AM

hey I have this neat 'rootkit' utility that does the same thing

PM me your host, username and password and I'll run it for you

9/15/2005 4:46:53 AM

woah, cool, can i send you mine too!?

[Edited on September 15, 2005 at 8:28 AM. Reason : neato!]

9/15/2005 8:28:06 AM

sure you can have my root access
host= ftp.google.com
username = yomamma
password = isaslut

9/15/2005 9:44:25 AM