Active Oldest Votes. Improve this answer. As i mentioned i'm a newbie so not so many knowledge in Php but Java : ok, i'm going through it and getting back to you.
RajdeepRoy you might find this answer useful - it should help you localize php. If it will not help you, please come back to me. It will be useful to know what OS you are using — mkk. RajdeepRoy do you really need to use phpmyadmin after that?
If you do not have password you do not need to use -p option. That will be simpler approach : — mkk. Show 3 more comments. Sign up or log in Sign up using Google. Create a zip or tar file and upload in phpmyadmin thats it..! Sachin from Pune Sachin from Pune 6 6 silver badges 16 16 bronze badges. Daniel Karatha Daniel Karatha 41 3 3 bronze badges.
Nikunj K. Thanks you, that was perfect. Marlon Marlon 1, 2 2 gold badges 16 16 silver badges 32 32 bronze badges. I stumbled on an article and this worked best for me Open up the config. Take that large. JAL 40k 22 22 gold badges silver badges bronze badges.
Bobin Thomas Bobin Thomas 51 1 1 gold badge 1 1 silver badge 3 3 bronze badges. This is actually good solution, but You got downvote because of URL which can be invalid one day. Please add some informations about this script, escpecially the name of it. Lewis Browne 7 7 silver badges 23 23 bronze badges. Ejalee Ejalee 31 4 4 bronze badges. You could load any file now!! Saad Joudi Saad Joudi 2 2 silver badges 4 4 bronze badges. Tschallacka Tschallacka This does not provide an answer to the question.
To critique or request clarification from an author, leave a comment below their post. So I do not see how this does NOT provide an answer.
Yes, I didn't lead him by the hand how to set up exactly becuase he hasn't provided which server he's using, apache, ngix, iis, other.
Teo Mihaila Teo Mihaila 1 1 gold badge 2 2 silver badges 17 17 bronze badges. Not a good practice! Large texts will cause big problems when you do this.
Best way is configure php. Dharman Solomon Suraj Solomon Suraj 5 5 silver badges 7 7 bronze badges. Meawhile, Navigate to mysql bin folder eg if you are using xampp, run or type the code below. Sign up or log in Sign up using Google.
Sign up using Facebook. It's a simple PHP script that loads a chunk of the database at a time before restarting itself and moving on the the next chunk. Open config. You no need to edit php. Click that and [follow steps below]. You can also try compressing zipping the file. It sometimes works for me if I can't get to php. If zipping reduces the file size below the maximum file size, it just might work!
If you do not want to change the settings or play with command line. There is option to compress the file and upload in phpMyAdmin. It should bring down the size considerably. How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Can't import database through phpmyadmin file size too large Ask Question.
Asked 9 years, 10 months ago. Active 12 months ago. Viewed k times. Please help I really need this to work. PHP usually has a file size restriction for uploads.
Your best bet is to FTP the file and login through ssh and import the sql script through the mysql command line. Use gzip, bzip2 compressions for exporting and importing. Try to avoid Winrar and Winzip.
In my personal suggestion, Not recommended. Using PHP INI setting dynamically change the max upload and max execution time as already mentioned by other friends is fruitful but not always. Try compressing the. SQL file before uploading it. Fatal error: Allowed memory size of bytes exhausted tried to allocate bytes. If your uncompressed. SQL file is less than or equal to 94MB it should work just fine to zip it and upload.
How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.
0コメント