Is it possible to import sql file to mysql database from a url?

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.

Related Questions