Author Options:

How do I edit a SQL database? Answered

Hey, I have recently found a clone of the Fiverr Script micro-jobs thing for free and I have no idea of how to set it up. I have set up the installation it says and step 2 says I need to import a file called 'scriptsolution.sql' into my newly created database. I know what this means, but how do I do this? I have setup a MySQL database on http://www.freesqldatabse.com/ and I don't know how to edit it. Then, step 3 says I need to upload some specified files into my web server's public directory and I have no idea on how to do that or what that means. Step 4 says I need to CHMOD 777 the files and directories that it shows, I have no idea what that means. Lastly, step 5 says 'Setup a cron job on your server to run once every hour of every day.' and it says the commend format, I sort of know what this means but I don't know how to do this. That's all I have questions abou so PLEASE HELP!!! Thanks!



Best Answer 7 years ago

I'd recommend you set up a web server locally first. This means it would run on your computer and you would access it by typing http://localhost into your web browser. This would be a lot easier than fighting with file permissions and 3rd party sites if you're a beginner.

What operating system are you using? If Windows, install something called XAMPP. It sets up Apache, PHP, mysql, Perl. You'll be able to visit localhost/phpmyadmin/ and import that sql file you have.

If you're using a different operating system, look at LAMP for Linux. I don't know what for MacOS.