phpMyAdmin import/dump from url

Is this possible? I'm trying to dump a 11mb file into sql, the problem is my internet is unreliable and it keeps failing. I have the file in question uploaded to my server, is there any way I can tell it to read the file on my server and dump from there? Its an sql file

Thanks

 

yes a simple cron job will do this easily

 

Do you know the code I'd need for that on a linux server? All I want to do is import the database once (I'm installing a script that requires a database setting up).

Cheers

 

Hello,
You can do it directly from ssh (putty)..

Here you have a quick guide
http://www.html-resource.com/mysql.html

Best regards,
Jakomo

 

yah if u have ssh access on Your hosting account, Use this

You will need the database username, password and database name.
After you ssh into OLD server, type "mysqldump -u USER_NAME -p DB_NAME | gzip > FILE.sql.gz"
Enter the database password when it asks. Then, usinf FTP or sFTP, copy the FILE.sql.gz file from the OLD server to the NEW server. (Presumably by copying it from OLD server to your PC and then to NEW server.)
After you ssh into NEW server, type "gunzip < FILE.sql.gz | mysql -u USER_NAME -p DB_NAME"
Enter the database password when it asks. When it is done, your database will be copied to the new server.


or zip the files and Do you have Access to PhpMyAdmin? Most cpanel powered server has it. you can export the database from there.