Need to upload a 3gb SQL file?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Need to upload a 3gb SQL file?

Postby cmebdisme » 15. July 2015 14:13

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
cmebdisme
 
Posts: 2
Joined: 15. July 2015 13:32
Operating System: Windows 7

Re: Need to upload a 3gb SQL file?

Postby Altrea » 15. July 2015 14:58

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Need to upload a 3gb SQL file?

Postby cmebdisme » 15. July 2015 15:37

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.
cmebdisme
 
Posts: 2
Joined: 15. July 2015 13:32
Operating System: Windows 7

Re: Need to upload a 3gb SQL file?

Postby glitzi85 » 15. July 2015 23:05

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.
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 44 guests