Page 1 of 1

SQL upload problem

PostPosted: 17. July 2007 01:01
by testlab
Hello, All

Im having problems uploading a 250mb sql DB thru Phpmyadmin in localhost. Can someone please help me out with this one? Is there a better way to do this. It keeps telling that the file is too large to upload thru phpmyadmin.. I have edit the php.ini file but no luck it still says the same thing.

Thank You

PostPosted: 17. July 2007 01:08
by testlab
What I basicly just want to do is to look at my old database tables that I had from my old site. I need all my members information so that I can start migrating info. Is there a soft ware that just allows me to look at my sql DB ? I have a local copy in my hard drive.

Thank You

PostPosted: 18. July 2007 07:15
by delftdamage
You edited the right php.ini?
The one in c:/prog..files/xampp/apache/bin/php.ini ?

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
upload_tmp_dir = "C:\Program Files\xampp\tmp"

; Maximum allowed size for uploaded files.
upload_max_filesize = 16M

-----------------------------------------------------
And changed this 16M value to 300M?

What kind of file do you have?
If there is SQL in it you can try to use the import SQL function.

Not by uploading the file but by pasting the SQL text and run all queries.