I access a database (zipped, txt) file via ftp, download it to my laptop, unzip it on my laptop (into a txt file), then upload it to a database on my webhost.
I would like to automate the process. My website is hosted by BlueHost. Any help would be appreciated.
You can try to access the server directly: http://de3.php.net/manual/en/book.ftp.php. You better try it with a sample code because many server are restricted.
Once you have the data, it shouldn't be a problem for you to import the stuff into your database.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.