PhpMyAdmin has an SQL import option under the SQL tab. It'll attempt to upload the file, so make sure your server/internet connection can handle the upload.
Up vote 0 down vote favorite 1 share g+ share fb share tw.
I want to import an SQL file to my database. The problem is that I can't get this file to my computer because it is too big file. I want to import it from the server through it's URL using MySQL or phpMyAdmin Is it possible?
How can I do that? Mysql phpmyadmin link|improve this question edited Apr 21 '11 at 15:05Nishant11.1k11023 asked Apr 21 '11 at 15:03MBAsfoor1.
GET example.com/mysqldump.sql | mysql -D mydb -u myuser -pmypasswd – Quassnoi Apr 21 '11 at 15:07 why can you not download file to your machine and then execute mysql -u USER -p PASSWORD DATABASENAME Download it or not, the data-transfer and most likely the time consumed in the process will stay the same. 600MB is not big file though. You may tar|zip|rar it at the server, download, (un)tar|zip|rar and import to MySQL, is the best.
– Nishant Apr 21 '11 at 15:18.
The file is on the server not on my computer – MBAsfoor Apr 21 '11 at 15:09.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.