dallassmith
08-22-2002, 07:29 PM
Hi, I am currently loading a dump file in phpmyadmin and it is 150mb big... I was wondering will phpmyadmin handle this or is their a limit? If so how else do i dump this file, and how do I make a database using ssh?
Thanks!
Aaron
The Prohacker
08-22-2002, 07:43 PM
It won't...
The typical max upload on PHP is 2mb... Besides, the script would prolly timeout in the proccess of uploading...
So the max upload and timeout would both need to be extended, and this can only be done as root...
It would be better todo this in shell...
Andrew
08-22-2002, 07:47 PM
Yeah, that's one of those 'valid reasons' hosts give SSH access for.
dallassmith
08-22-2002, 07:47 PM
Whats the command to change the limit?
dallassmith
08-22-2002, 10:44 PM
This is really important! I need to move a sql database from my acct to another clients whos shell acct is disabled. By the way it is XMB forums
Do a search here for 'mysqldump'.
Lats...
I believe you could upload the file via FTP, and then access it from phpmyadmin. Or, atleast ask the host to load the data.