User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » mysql help Page [1]  
bulldog1256
Veteran
145 Posts
user info
edit post

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

Stein
All American
19842 Posts
user info
edit post

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

bulldog1256
Veteran
145 Posts
user info
edit post

nope, any other ways?

9/9/2005 5:19:57 PM

Maugan
All American
18178 Posts
user info
edit post

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

bulldog1256
Veteran
145 Posts
user info
edit post

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

ScHpEnXeL
Suspended
32613 Posts
user info
edit post

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

HaLo
All American
14273 Posts
user info
edit post

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

bulldog1256
Veteran
145 Posts
user info
edit post

I appreciate the help

9/9/2005 8:52:17 PM

tjoshea
All American
4906 Posts
user info
edit post

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

dmann
All American
522 Posts
user info
edit post

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

tjoshea
All American
4906 Posts
user info
edit post

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

dmann
All American
522 Posts
user info
edit post

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

bulldog1256
Veteran
145 Posts
user info
edit post

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

NateP
New Recruit
18 Posts
user info
edit post

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

Incognegro
Suspended
4172 Posts
user info
edit post

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

qntmfred
retired
40810 Posts
user info
edit post

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

bulldog1256
Veteran
145 Posts
user info
edit post

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

9/15/2005 9:44:25 AM

 Message Boards » Tech Talk » mysql help Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.