Page 1 of 1

Need to upload a 3gb SQL file?

PostPosted: 15. July 2015 14:13
by cmebdisme
Just to note - I did not have the option to chose XAMPP for windows 5.5.24 when registering.

Xampp Control Panel 3.2.1
Xampp for Windows 5.5.24
Installed on Windows 7
New Install

I need to upload a 3gb SQL file - and am unable to do so. I have made changes to php.ini and my.ini files from information I found. This has obviously not resolved my problem so I am hoping that someone would be able to help me with some hand holding information on how I can achieve this.

Many thanks
Christine

Re: Need to upload a 3gb SQL file?

PostPosted: 15. July 2015 14:58
by Altrea
Why do you need to upload the file?
If you have physical access to that server, use a portable medium to move the file.
Otherwise use a protocol that is made for file transfering (FTP)

best wishes,
Altrea

Re: Need to upload a 3gb SQL file?

PostPosted: 15. July 2015 15:37
by cmebdisme
Sorry ?syntax? import the SQL file. I have a download of a website from a Linux server and need to use as a "wip" development of the site. I haven't used xampp for many years now and things seem to be quite different the bits I do remember.

Re: Need to upload a 3gb SQL file?

PostPosted: 15. July 2015 23:05
by glitzi85
It sounds like you have a local installation of XAMPP on your computer and you are trying to import your sql file via phpMyAdmin. Correct so far?
In this case: Very bad idea. Use the mysql command line client to import your file into MySQL.

In every other case: Please describe your situation more accurate.