Skip to main content

Hosting FTP server in your Local Machine

I use this method to share some files with my friends across the internet that is too large for Dropbox to handle. I tried hosting SQL data that's around 3G in size so I wanted to try FTP approach.

I installed XAMPP and it has useful stuffs for HTTP and FTP projects. I use it once with my PHP development, but that's it -- nothing FTP related. This is a tutorial on how to basically set-up FTP server locally to host data to be shared by friends, etc.

Once XAMPP is installed, we can directly go to the Control Panel.



Clicking the Admin for FileZilla FTP Server administration might alert you with Security Warning, just allow access to it. Click OK to Connect to Server. We are now presented with the FileZilla server Administration interface. Go to Edit->Users to add users. I usually just add temporary users who can access specific files to be shared periodically, that means I'll disable it once I'm done with the file share and also I don't usually leave FTP server running. Turning it off after use is a good practice.

Adding user is at the right side of the Dialog with Users group box. Click Add and type any user you want, I'm fond of having "test/tset" credentials so we'll use it here. Now check the Password check box to add password to the user. Type in "tset", as in reverse of test. That way it's easy to remember. :D You can of course choose your own username and password. To share file(s) or folder(s) to this user click Shared Folder. Add Shared Folder by clicking Add and browsing for the directory. I normally leave Read permission by default, at least the user can't do damage to the directory. Click OK and we are done!




Now type the credentials we created (test/tset) and you will be redirected to the shared directory we configured. Sample image below for confirmation. Of course, I didn't share my 3G SQL data, lol.



That's it! Have fun everyone!

Comments

Popular posts from this blog

Python Hydrology

Recently I'm learning Python and encountered the Hydrology book. Had to upgrade some of python packages and some libraries needed to get working with the book. There is an instruction though about mostly using pip install packages need for the book. The problem is I can't get it work. It's missing some things so I did a little google and hopefully this is a compilation of the things I need to work with the examples of the book. First off, I updated the apt-get $ sudo apt-get update Next is I installed the pip package manager. I'm not too sure but I have Ubuntu 10 and it doesn't have the pip installed. So I installed using the command below. $ sudo apt-get install python-pip Now the development packages for python. $ sudo apt-get install python-dev Most of the examples uses the scientific number packages so I installed numpy and other packages I'm not quite aware of. It's just that some of the examples probably in the later part of the book use...

Efficient Cleanup of Temporary Database Tables in SQL Server

 In database management, it's not uncommon to create temporary tables for various purposes, such as storing intermediate results or performing complex operations. However, managing these temporary tables and ensuring they don't clutter your database can be a challenge. In this blog post, we'll explore a useful SQL query that simplifies the cleanup process for temporary tables in SQL Server. The Challenge of Temporary Tables Temporary tables are often created dynamically during database operations, especially in scenarios involving complex queries or data manipulation tasks. While temporary tables serve their purpose during runtime, they can accumulate over time and lead to database clutter if not properly managed. Manual deletion of these tables can be time-consuming and error-prone, especially in databases with numerous temporary tables. The Solution: Dynamic Cleanup Query To address this challenge, we can leverage a dynamic SQL query to automate the cleanup of temporary t...

Reasons why you don't apply to some Companies

Just a note, this is just a joke. So for some companies, I would ask you to evaluate me first not base your judgement for hiring me in this post. :) Recently, I planned on getting another job. This time with programming languages I'm not familiar with. Just to get my hands on. Something like Python or Ruby, or JS and NoSQL. You know what I mean. Then came, job posts at some Ads. Recruiters really think they are smart. They're not even reviewing what they're posting and not getting consultation from experts offering a job. For example SEO Experts (20k to 30k) with GREAT “DAYTIME” CAREER OPPORTUNITIES A NEW COMPANY soon to expand OPERATIONS in CEBU!!! I'm sure 30k is not that great. And what's with the DAYTIME? Also Perfect Worklife Balance: “Daytime Work” and Guaranteed 5 day work week only Easy to Manage Accounts Excellent Compensation based on expertise, we are only looking for top talent and pay accordingly Performance and Attendance bonuses...