Hi, Over in the Buy Sell Trade section of Digital Point, I see people selling Data Base files and I was wondering how do you compile all your information and turn it into a sellable database? I've seen some programs/software available that create database files, but not sure these are the same thing. Info to a simple tutorial on this would be appreciated. I've Googled and got some info, but I'm not sure what I am looking for exactly. Obviously, Googling "how do you make those nifty database files like they sell on DP" is not bringing up much info! Thanks for reading.
these database are collected from differnt resources. mostly have their own site database, those they are selling. i am also selling, as u can see my signature.
Most of the db info I assume you are referring to is posts and link info? If so, its usually packaged in the form of a "tar" file for compression from MYSQL program.
Well, I would say it is basically your knowledge and sources, which you use, to collect and organize a nifty niche database and make it available for sale. Based on what the niche is, you may get 100 sales or none. It really varies.
Hi, let's say I already have a collection of "data" say I have 500 poems or something. What do I do that makes it a database to sell and use? Sorry, but if you already answered this up above, I didn't quite absorb it.
I have never sold this kind of data but I have dumped many files on a db server for web site use. The following might not be the easiest way to accomplish this but this is what I would do . . . If you are trying to create something like host_planner's list above, it will take some massaging of the data. If you have this info in an excel spreadsheet what you should do is create a mysql table on the database on your server (tutorial: http://www.w3schools.com/sql/sql_create.asp). Save your excel spreadsheet as a csv (comma separated value) file and use the Import feature in phpMyAdmin to stick your data in the table. From there you just have to use the Export feature in phpMyAdmin to export it as an SQL dump. The above process might be a little technical but you can find 1,000's of tutorials online to guide you. Again, there might be an easier way to get this kind of SQL dump file for selling (perhaps an xls plugin) but this is how I know this can be accomplished. This final Exported SQL dump is basically the database & table structure with all data wrapped up in one file. This way once it is sold the other person just has to "dump" the SQL file in place on their server and start using the data. Just a thought, but could you not just sell the xls or csv file? Do you have to have this as a SQL file? I realize for web use this would be much more beneficial for MySQL users but there are tons of other database types out there. Again, selling data is not my job description so please forgive the last questions if they are dumb.
Many many thanks exe. I have been using mysql for the last 3 years and never heard of this... Always used text editors like textpad, pspad... Other than phpmyadmin(webbased), there was no good tool available. I am going to try that....
When the db is on the site how would you use the info? How would you see the contents? How would you (hopefully easily) manage, manipulate, add and remove etc. I have a large file and when I look at it on my desktop its just junk yet I am assured that it contains a lot of useful data. How would I "see" that data in a website/page? This has been driving me nuts for over a week and most of the info "out there" is over my head. I just want to connect to the mysql somehow and look at the individual files and then, maybe, copy and paste the contents into notepad. I dont want to search with phpmyadmin or compress files or mess with fields and such - I just want to get the sensible text from inside the db and manipulate it with a word processor. Thanks in advance.
Got it, you mean database content. I though this thread was about people selling databases hosted on they servers that you can access remotely when your host does not provide you with this facility.
For someone just learning MySQL at the moment along with PHP, is it worth looking at MySQL Workbench yet or would you say wait until an understanding of MySQL is in place?