PDA

View Full Version : Populating Database using GZipped File present on Web Server


atheistrical
08-30-2009, 05:17 PM
I need to populate a database using a GZipped file which is located on the server itself. I tried the phpMyAdmin Import but it only seems to work with local file uploads. The GZipped file is located on say http://abcxyz.com/dump/dump.sql.gz I have access to command line mySQL using the phpMyAdmin SQL Box, but I cannot really guess the relative path of the GZipped file (perhaps my web-host uses a different databse server location).