How to Backup and Restore Data in MySQL

Multiple backups should be taken. E.g.

• One copy on the same computer or locally networked computer that can be used to quickly replace a database that is in use.
  
• Another copy in a physically different location in case something happens at the current location (fire, flood). This could be another computer at a remote site or some portable medium like a tape or CD.
  

If using Windows, open a command prompt window.
If using Linux, execute the commands on the command line.
The examples below are for Linux - convert backslashes and add .exe to the command for the Windows equivalents.

Steps

1. To make a backup:
   
   • mysqldump --user=username --password=password databasename >path/backupfilename
     
   
   
2. To repair a table:
   
   1. Stop the MySQL server:
      
      • mysqladmin -u username -p shutdown
        
      
      
   2. Start the repair:
      
      • myisamchk -r databasepath/databasename/tablename.MYI
        
        • databasepath - The complete path to your data directory.
          
        • tablename can be "*" which means fix all tables.
          
        
        
      
      
   3. You should see output on the screen telling you which tables are being checked.
      
   4. Restart the MySQL server:
      
      • mysqladmin -u username -p start
        
      
      
   
   
3. If the repair doesn't work, you may need to delete the table and restore from the backup file:
   
   1. Delete the table - in MySQL, send the query:
      
      • DROP TABLE tablename
        
      
      
   2. Back at the command prompt:
      
      • mysql -u username -p databasename < path/backupfilename
        
      
      
   
   

Warnings

• The backup file contains all INSERT commands to restore all tables you specified when you made the backup. If you only want to restore some of the tables, you'll need to edit the backup file before running the restore command.
  

Related wikiHows

• How to Install the MySQL Database Server on Your Windows PC
  
• How to Retrieve Data from Mysql
  
• How to Make Changes to the Database Structure in Mysql
  
• How to Create a Database in Mysql
  

Article provided by wikiHow, a collaborative writing project to build the world's largest, highest quality how-to manual. Please edit this article and find author credits at the original wikiHow article on How to Backup and Restore Data in MySQL. All content on wikiHow can be shared under a Creative Commons license.

How to Capture TV Clips and put them on Youtube using a Camera

This will only work if your camera has an "AV IN" port and an "AV cable".

Steps

1. Make sure the show is on, or make sure the DVD is in the DVD player.
   
2. Plug one end of the AV cable into your camera.
   
3. Plug the other ends(the red tip, white tip, and yellow tip) into the "AV OUT" or "OUTPUT" on the DVD Player according to color.
   
4. Start recording on the camera. (turn on the episode you wish to record if you are recording it from a DVD.
   
5. When you are done, stop recording, and plug your camera into your computer (if you are using an SD card, put it in the computer now)
   
6. Save the file of the recorded show onto your computer
   
7. Upload it to Youtube!
   

Tips

• The OUTPUT is usually on the back of the DVD player.
  
• Not all cameras are able to do this
  

Warnings

• The show you are recording is copyrighted and youtube may take it down. UPLOAD AT YOUR OWN RISK!
  

Things You'll Need

• A camera
  
• An AV cable
  
• A DVD Player
  
• A Youtube account
  

Related wikiHows

• How to View PowerPoint on YouTube with Acoolsoft PPT2Video Converter
  
• How to Film Videos With a Video Camera and Put Them on Youtube
  
• How to Put YouTube Videos on Your iPod Without Any Software
  
• How to Find a Television Episode Videos without YouTube
  

Article provided by wikiHow How to Capture TV Clips and put them on Youtube using a Camera. All content on wikiHow can be shared under a Creative Commons license.

How to Bypass a Mirage OS Password

This explains how to bypass a Mirage OS password for the calculator. It tells you how to bypass it when it's turned on and it's there or when you just need to get in!

Battery Method

1. Take out the batteries and put them back in (when the calculator is turned off). This should clear the RAM memory.
   
2. After the memory is cleared, you can go into the calculator password free.
   

Memory Method

1. Go to 2nd [MEM].
   
2. Press 2 (or scroll down to Mem Mgmt/Del).
   
3. Press ALPHA B or scroll down to AppVars.
   
4. Go to the Application Variable named MirageOS.
   
5. Delete it by pressing DEL.
   
6. If it asks for a confirmation, go to yes and press ENTER.
   
7. Go to the App MirageOS.
   
8. You can now enter without a password.
   

Self test method

-this method works when you have the memory access blocked

1. press mode
   
2. press [alpha] + "s"
   
3. press ok to begin the self test
   
4. this will erase the RAM memory, and you will be able to get in the program
   

Tips

• This should work for most, if not all versions of Mirage OS.
  
• There are really good games and applications out there, so below are some links to learning and/or getting games or other useful stuff!
  
• If you need to get in at the home screen, follow the steps in the "Battery Method", only don't pull out the batteries. If you need to unblock the memory, then make sure everything is archived, and pull out the batteries. Go to the memory, and follow the steps located in the "Memory Method" section.
  
• If you have the memory menu blocked, first pull out the batteries. After you turn back on the calculator, imediatly go to the Memory Menu (before the "RAM Clear" shows up). After this, follow the above instructions for Memory Method.
  

Warnings

• Clearing the RAM can delete anything from the RAM memory, including programs and data, so make sure it's your calculator if you forgot the password, you won't want your friends to be mad at you for a big program they were making or a really good game deleted.
  
• If you blocked the memory menu from access, or (for some Mirage-based programs that run programs from Mirage) password-protected your memory menu, this will not work.
  

Sources and Citations

• http://www.ticalc.org/pub
  
• http://ostermiller.org/ti82/games.html
  
• http://www.detachedsolutions.com
  
• http://www.digg.com/gaming_news/3000_Graphing_Calculator_Games_
  
• http://www.calcware.org/
  
• http://education.ti.com/educationportal/sites/US/nonProductSingle/student_games.html
  

Related wikiHows

• How to Burn a Playstation Disc Using Nero
  
• How to Know if You Have Spyware on Your Computer
  
• How to Make a Motion Detector
  
• How to Zoom in on a Photo in Microsoft Paint
  

Article provided by wikiHow, a collaborative writing project to build the world's largest, highest quality how-to manual. Please edit this article and find author credits at the original wikiHow article on How to Bypass a Mirage OS Password. All content on wikiHow can be shared under a Creative Commons license.

How to Buy a Nitro Rc Vehicle

One of the newest trends in the Radio Control car industry is the rapid growth of Nitro gas powered RC vehicles. Before you purchase a RC car or buggy, it is important to have some background information. What do you need for start up,
how they work, fuel requirements, maintenance tips, and simple suggestions for beginners. Racing Nitro cars is popular sport. The adrenalin rush and competition can make for fun times with friends and family.
When shopping for a car, you will encounter terminology that may be new to you. RTR refers to vehicles that are sold “Ready to Run”. This is ideal for the beginner. There is no assembly required and everything should be included in the kit. ARTR are cars or trucks that will need assembly and often require a separate purchase of the radio control system.

Steps

1. The radio control is composed of three systems. First is the transmitter. This is the hand control; usually rechargeable batteries power it. They are availiable in FM and AM frequencies. Both transmitters and recievers have changeable crystals or frequency chips. The transmitter emits the signal to the antenna, which will be carried to the reciever. The receiver usually has a power supply, and is built into the vehicle to control the transmitters signal to the final part of the radio controller, the servo. The servos, or servomotors are the devices which are responsible for controlling the throttle and or brakes,( some machines have separate throttle and brake servos ), steering, and shifting (for units with reverse). The servos use linkages, usually adjustable, to control the vehicle.
   

1. Fuel for these RC cars and trucks is a blend of nitro methane, alcohol and natural and synthetic oils, this product is carried at many hobby stores. Always follow recommendations for storage and use of this product since it is combustible. There are several different blends of nitro methane available. Higher concentrations of nitromethane will run hotter, but will decrease the total run hours of the machine.
   

1. Choosing a vehicle will depend on the surface you plan to drive on. On-road nitro cars are ideal for racing on a hard surface. They are designed for speed and more difficult to control. Because they can be easily damaged in a crash, these are not suggested for beginners. Off Road vehicles are ideal for beginners . Capable of huge jumps and difficult climbs, they are suitable for almost any terrain. The durability and power make these a great choice for the novice. The ultimate for speed, acceleration, handling and durability of all is the Nitro Buggy.
   
2. With proper maintenance and operation your RC truck, car or buggy will perform and provide hours of fun and excitement. Always follow recommended steps from manufacturer. Often a “slow break in” is suggested. This allows more fuel to enter the engine, thus allowing it to run at a lower temperature. RTR cars will be set up for a break in at the manufacturers default setting. After each use shake out loose dirt and clean with a soft cloth. Routine cleaning of the outer air filter is recommended. An air compressor will to the trick. Replace all worn components of the clutch system and air filters. Pay close attention to the Clutch ball bearings, these will take most of the abuse from regular use of your vehicle. Clean them often.
   
3. Use caution when racing; choose a well-maintained paved or hard surface. Beginning drivers need to master control of the vehicle. By rolling into the throttle smoothly the car will handle better. Before cranking up the speed, take a few accident free laps around the track.
   
4. Most RTR cars and trucks have low power, slow speed servos with plastic gears. should you damage a servo, you should definitely consider upgrading to higher torque servos for faster throttle response, harder braking, and tighter turns under high speed. these servos also consume more power from your battery packs, so consider upgrading battery packs also.
   
5. Tweaks are key. understand how systems work, spend lots of time looking at the workings of it, you may see a way for something to work better. examples are changing differential oils, adjustment of ride height, possibly adjusting battery pack locations to allow better balance.
   
6. be aware that your engine will not last forever. some people get to run only a few gallons of fuel before repair/replacement is needed, while others get 20+ gallons of fuel through an engine.
   
7. keep extra air filters on hand. dirt ingestion will destroy an engine very quickly.
   
8. Make it Yours! colorful graphics, led lighting systems, brake and headlights, flashy stickers and bright colors let everyone know which car is yours!
   
9. 
   

Tips

• Nitro RC cars, trucks and buggies are an ideal gift and will provide hours of fun for you and your family. I hope these tips will help you make a good educated decision.
  

Related wikiHows

• How to Start up a Nitro RC Vehicle
  
• How to Start a Remote Control Car Hobby
  
• How to Fly a Remote Control Plane
  

Sources and Citations

• http://www.familygokarts.com/remote_control_cars
  

Article provided by wikiHowHow to Buy a Nitro Rc Vehicle. All content on wikiHow can be shared under a Creative Commons license.

How to Brighten up a Dark Video

Do you have some dark videos which you would like to brighten up so you can see them better? Let's lighten them up!

Steps

1. Get a software named "VirtualDub" from http://virtualdub.sourceforge.net/
   
2. Launch VD (Virtual Dub) and open your video file.
   
3. Now we need to recompress the video and audio. If you skip this step the output video size will be colossal (a few GB if is a long video). The video I'm about to use is very bright already so it will not stay with very good looking...but whatever, its just an example. Choose a codec to compress the video (if you have divx on that list I recommend)
   
4. Do the same with audio.
   
5. Now lets do the thing. Go the video/filters (Is at the same place where you went to compress the video...you did that right? ) Now add the brightness/contrast filter.
   
6. Raise a bit the brightness or contrast as you wish, try some combinations until the output is the way you want.
   
7. Now go to File/Save as avi (or press F7).
   
8. Virtual Dub will start to process your video, wait until it finish. This may take long or not depending on your video length.
   

Things You'll Need

• Virtual Dub
  
• A video to bright.
  
• A computer
  

Related wikiHows

• How to Make a Home Video
  
• How to Upload a Video on YouTube
  
• How to Turn a Regular Video Camcorder Into a Webcam
  

Article provided by wikiHowHow to Brighten up a Dark Video. All content on wikiHow can be shared under a Creative Commons license.

How to Become a Free Software Hacker

Writing and using Free software is not just a programming, is a kind of philosophy. While programming language is all you need to program, this article is about how to join the community, get friends, do a great work together and become a respected specialist with profile you cannot get anywhere else. In a world of Free software you may rather easily get tasks that in a company only the elite, top level programmers are allowed to do. Think about the amount of experience this can bring. However if you once decided to become a Free software hacker, you must be ready to invest some your time into achieving this goal. This remains true even if you are an IT student already. Also, this article is not about how to become a cracker.

Steps

1. Learn some popular programming language (C, C++, java or similar) till the more or less satisfactory level. Without this, you are useless to the hacker community and nobody will talk to you. To be more productive, learn Eclipse or other similar integrated development tool.
   
2. Learn version control (CVS, SVN). It is likely the most important co-operation tool for shared software development. Understand how to create and apply patches (text difference files). The most of Free software development in the community is done creating, discussing and applying various patches.
   
3. Find the suitable small Free software project which you could easily join to get experience. Most of such projects now can be found on SourceForge.net. The suitable project must:
   
   1. Use the programming language you know.
      
   2. Be active, with recent releases.
      
   3. Already have three to five developers.
      
   4. Use version control.
      
   5. Have some part you think you can immediately start implementing without modifying the existing code too much.
      
   6. Apart the code, a good project also has the active discussion lists, bug reports, receives and implements requests for enhancement and shows other similar activities.
      
   
   
4. Contact the administrator of the selected project. In a small project with few developers your help will usually be immediately accepted.
   
5. Carefully read the rules of the project and more or less follow them. The rules of the coding style or necessity to document your changes in a separate text file may first appear ridiculous to you. However the purpose of these rules is to make the shared work possible - and the most of projects do have them.
   
6. Work in this project for several months. Listen carefully that the administrator and other project members say. Apart programming, you have a lot of things to learn. But if you really do not like something, just go away to another project.
   
7. Do not stick with the underground project for too long. As soon as you find yourself successfully working in that team, it is time to look for the serious one.
   
8. Find a serious, high level Free software or Open source project. The most of such projects are owned by GNU or Apache organizations.
   
9. As we are doing a serious jump now, be ready for the far cooler acceptance. You will likely be asked to work for some time without direct write access to the code repository. The previous underground project should, however, teach you a lot - so after several months of the productive contribution you may try do demand rights you think you could have.
   
10. Take and do a serious task. It is time. Do not be afraid. Go on even after you discover that the task is lots more difficult than you initially thought - in this step it is important not to give up.
    
11. If you can, apply with your serious task to the Google's "Summer of code" to get some money from this adventure. But just do not care if the application would not be accepted as they have far less funded positions than really good hackers working around.
    
12. Look for a suitable conference happening nearby ("Linux days" or something similar) and try to present your project there (all project, not just the part you are programming). After you tell you are representing a serious Free / Open source project, the organizers frequently release you from the conference fee (if they do not, the conference is likely unsuitable anyway). Bring your Linux laptop (if you have one) and run demos. Ask the project administrator for the material you may use when preparing your talk or poster.
    
13. Search the web for announcement about the install party happening nearby and try to join it first time as a user (watch for all problems and how hackers solve them) and next time as an installer.
    
14. Complete the task, cover with automatic tests and contribute to the project. You are done! To be sure, try to meet some hackers of the project physically and have a glass of beer.
    
15. 
    
16. For better understanding, look into real example of the development history for a Free Software project (above). Each raising curve represents a contribution (lines of code) from single developer. Developers tend to become less active over years but the project frequently even accelerates as new people join. Hence if you already come with some useful skills, there are no reasons why the team would not invite you.
    

Tips

• If you still do not trust yourself enough, start from some part of code that you think is missing and can be written from scratch. Changes in existing code are much more likely to attract criticism.
  
• For the beginning, select a class, module or some other unit under which nobody is very actively working at the moment. Working together on the same class or even function needs more skills and a lot of care from all sides.
  
• Before asking any question about the working rules inside the project, try to search for the answer in the project documentation and mailing list archives.
  
• The employers of some hackers seem motivated enough to allow contributions during they working time (usually because the institution uses the Free/Open source program that the hacker is developing). Think, maybe you can get at least part of the needed time this way.
  
• Always continue the hacking you started. Does not build, does not run, crashes? There are reasons for everything and if you have source code this usually means that you can force the system to do whatever you want, especially with the help of the web search. This rule has its limits, but, indeed, never yield easily.
  
• Only say you are a hacker after some true hacker community recognizes you as such.
  

Warnings

• If you plan to meet Free software hackers eye to eye, always leave your Windows laptop at home. Mac OS is tolerated somewhat better, but also not welcome. If you do bring your laptop, it must run Linux or other operating system that they consider as "Free software".
  
• If you mail client supports html messages, turn this feature off. Never attach documents that only proprietary software (like MS Word) can open properly. Hackers understand this as insulting.
  
• While the word "hacker" sounds with respect in the most of the academic environments, for some uninformed people it may associate with breaking into security systems and other computer-related crimes that a different social group (crackers) do. Unless you are ready to explain, look to whom are you telling this word. Real hackers as they are meant in this article never join programming activities that seem for them illegal. First, they are proud of following the hacker ethic. Second, the law violations are not necessarily better paid.
  
• Do not volunteer to the company-owned projects that are not releasing some parts of they code under approved Open Source license. In such cases the really important parts of the project are likely to stay behind the closed doors of the owner, preventing you from learning anything useful.
  
• Do not start from small code optimizations, extra comments, coding style improvements and other similar "small-scale" stuff. It may attract far more criticism than any serious contribution.
  
• Avoid like pest asking any question, related to fundamentals of programming or programming tools. The time of the Free software programmer is as valuable as gold and nobody can afford to teach you the basic.
  
• For the same reason, never expect an older hacker to write a detailed description of your task or even provide any kind of supervision for you. While open source projects may have a lot of strict rules, they usually work along the lines of what is known as extreme programming in the programming methodology.
  
• Do not begin from starting your own project, unless you want to stick in a proud loneliness for ever. For the same reason, do not start from the attempt to revive the abandoned project which has already lost its previous team (see why).
  

Things You'll Need

• Linux. Many Free software projects are either more complicated to build under Windows or do not build properly at all. This is especially true for the advanced projects, devoted to the programming of mobile phones, minature computers, USB keys and other amazing devices.
  
• A computer with relatively good Internet connection. If you want to keep the dual boot with Windows, a second hard drive for Linux would be a good solution.
  
• Basic knowledge of at least one programming language and a strong intention to learn more. The most popular languages currently seem being C and java.
  
• Considerable amount of time, at least 5 hours a week (a typical hardcore hacker contributes as many as 14).
  
• While the formal education in informatics would make your way lot easier, you do not need it as a mandatory condition and no any real hacker community will ever ask you. Hackers judge about each other by one's hacking, not bogus criteria such as degrees, age, race, or position. However at least 60 % of hackers that watch you patches do have the "right" university degree and will not allow you to do any nonsense in the project.
  
• During the last steps (conference and install party) you would benefit from your own laptop. However it is not good for working at home, so only buy it if you can afford the second machine.
  
• The described path of becoming a hacker needs at least about two years to be completed.
  

Related wikiHows

• How to Volunteer
  
• How to Know when Not to Volunteer
  
• How to Learn to Use Linux
  
• How to Build a Typical Linux Project
  
• How to Look Like a Cracker
  

Sources and Citations

• http://www.gnu.org/fun/humor.html - the humour site in the GNU website. To be a Free Software hacker, you must find the majority of jokes funny.
  
• http://sourceforge.net - place to find the first project to join.
  
• http://www.fsf.org/campaigns/priority.html - list of the top level, high priority projects at GNU.
  
• http://www.apache.org/ - Apache community (they call they software "open source" and have slightly different license)
  
• http://catb.org/~esr/faqs/smart-questions.html - A true and useful guide how to ask questions to other hackers.
  
• http://freesoftware.mit.edu/papers/lakhaniwolf.pdf - A serious scientific study about Free software hackers.
  
• http://www.gnu.org/software/classpath/docs/hacking.html#SEC8 - Rules of the typical Free Software project
  
• http://www.advogato.org - A united blog where various hackers post they thoughts, many interesting topics.
  

Article provided by wikiHowHow to Become a Free Software Hacker. All content on wikiHow can be shared under a Creative Commons license.

How to Become Computer Literate

Are you the kind of parent who has absolutely no idea how to use a computer? Some one who has never touched a computer before and just got here by luck? This article will help you become computer literate.

Steps

1. Get a real person to help you; not just someone online. Some good people to ask are your own kids. They know a lot about the computer, but they may be annoyed if you ask too much. Also, check out some books at the library about computers. There are a couple of good books out there.
   
2. Learn the basic steps to get on the computer. Learn how to turn the computer on, off, on standby if applicable, how to log off if using Windows XP, and how to put disks in the disk drive.
   
3. Learn about the assorted programs and applications that you will be using. Install them on the computer by placing the CD into the disk drive, and following the installation wizard that pops up on the screen. After installing, play around with the application. this will help you understand the program better.
   
4. Learn a little about some of the chat jargon or chatspeak. Some examples are lol-laugh out loud, and btw-by the way. Also try to learn 1337 speak. 1337 means leet or elite. Check out the external links for more information. Also remember that this will help you figure out what you children are saying online when you look at their IM's, or instant messages.
   
5. On the same note, remember that there are some programs which can send where your child is going online right to your email inbox.
   
6. To set up an email account, which you will probably need to sign up for many websites, find a email providers like yahoo, google mail, aol, and bellsouth, and pick the one best for you. Sign up using the instructions.
   
7. Learn a little about bad people online. First there are pedophiles which are a danger to your kids. There are also scams, viruses, cookie grabbers, and trojan horses. See external links for more info. Also, always keep your computer up to date with security patches and whatnot.
   
8. Explore a little on the web. Go to google.com and google some of your interests. It might come up with great websites to go to that are about your interests.
   

Tips

• Some applications can help simplify things.
  
• Before making choices, learn about the advantages and disadvantages of the program.
  
• Remember, don't download anything if you are not sure about it.
  
• Make sure your computer is good for your use.If you want to just use it for taxes and email, performance is less useful but if you want to do 3D art you need a a more beefed up computer.
  
• Get enough hard drive space! This is basically how much room your computer has for files. 50 GB should be sufficient.
  
• Make sure the books you look at are up to date.
  
• On many programs such as Wordpad, there will be a button in the upper part of your screen that says "Help". This is a useful and quick access way to get answers.
  

Warnings

• Do not be fooled by unrealistic claims. A good rule of thumb is "if it sounds too good to be true, it usually is!". And DO NOT put your mobile number anywhere unless you have read and understood ALL the terms and conditions. You could be getting a free ringtone for $20 a week!
  
• Do not over estimate how good your computer is or how much room because your computer could overload.
  
• Do not pay for help unless you need it very, very badly.
  
• If you download something, make sure to run a virus check on it before hand because it might give you viruses. If you install McAfee Siteadvisor it will inform you whether the site and the downloads are safe.
  
• Be careful about opening attachments in emails, especially from people you don't know, since the attachment may give you a virus.
  

Things You'll Need

• Common sense
  
• A computer
  
• A helpful person
  
• A helpful resource
  

Related wikiHows

• How to Get a Job in Computers
  
• How to Connect Two Computers
  
• How to Buy Inexpensive Quality Computers and Electronics
  
• How to Learn Internet Terms
  

Article provided by wikiHowHow to Become Computer Literate. All content on wikiHow can be shared under a Creative Commons license.

How to Be a Computer Geek/Wicked Video Gamer

This is a post that will explain how to be a wicked video gamer and a computer geek, and if you want a geek in itself. Lots of people think geeks are nerds but they are full of intellegence and a young and optimistic mind.

Steps

1. Dress the part, you can dress anyway you want.
   
2. Get a normal shirt. Generally a black one with a logo will do just fine (any logo will do).
   
3. Get a button up shirt with long or short sleeves, doesn't matter. generally if you have one with long sleeves, roll them up.
   
4. Grow you hair long a bit. You can have it growing any length you want.
   
5. Generally you should also have you hair neatly combed.
   
6. Wear slightly baggy pants (if its winter or cold out) and shorts the go just below your knees in the summer.
   
7. Wear shoes an socks and get a few wrist bracelets.
   
8. If you want you can wear a USB stick around your neck if you want gloves.
   
9. For video gaming, generally play stuff like Battlefield 2, F.E.A.R., MMORPG games (World of Warcraft is an excellent MMORPG and so is MapleStory), Metroid, Medal of Honor, just basically any shooting games, zombie games, and horror games. Gears of War is an excellent game, too.
   
10. Learn stuff about computers. As much as you can. Learn a few basic hacking skills too, as well as basic repairs, and procedures.
    
11. Learn a computer language. A great starter is KPL (kids programming language) cause its REALLY EASY and its a good starter. Then move onto C++,C,Python etc.
    
12. Learn binary (optional)
    
13. Learn HTML (preferably XHTML), CSS, PHP, and Javascript at w3schools.com
    
14. Learn 1337. This is generally how gamers talk online. Words such as noob, pwned, fugly, w00t, etc. are used.
    
15. Watch star wars, star trek, zombie killing movies, horror movies, war movies, and Hogan's Heroes
    
16. 8Learn cheats for games an stuff and you're ready to go!
    

Tips

• You have definitely got to learn not to TAKE THINGS PERSONALLY WHEN PEOPLE CALL YOU NAMES AN STUFF ONLINE!!!
  
• Put a sign on your bedroom door and or computer room door with something geeky or something on it.
  
• Get USB sticks.
  
• Look up a bunch of stuff to learn more about being a geek.
  

Warnings

• Geeks generally get pushed around..careful of this.
  
• L337 talk generally works only in games.
  

Article provided by wikiHow All content on wikiHow can be shared under a Creative Commons license.

How to Be a Computer Geek

Little known to most, there are many benefits to being a computer geek. In our high-tech society, being a computer guru can be one of the most high paying jobs available. By tapping into your inner geek, you can develop a most useful skill that will be sure to pay off later in life.

Steps

1. Learn what hardware is.
   
2. Learn what software is.
   
3. Learn the specs (technical specifications) of your computer.
   
4. Learn to navigate a computer without using the explorer window, only by using the command line. Here are some common commands:
   
   • cd folder (*nix/Windows) to change the directory to folder
     
   • ls (*nix) or dir (Windows) to list the files or folders in the current directory
     
   • rm file (*nix) or del file (Windows) to remove file
     
   • mkdir name (*nix/Windows) or md name (Windows) to make a directory with a name of name
     
   • cp origfile newfile (*nix) or copy origfile newfile (Windows) to copy origfile to newfile
     
   • Note: *nix is any Unix based system such as Linux, BSD, or MacOS X (previous versions of Mac OS are not based off of Unix)
     
   
   
5. Learn to type without looking at the keyboard,
   
6. Ask. If someone does something on a computer that you would like to know, ask them about it.
   
7. Learning a programming language is a must-do. html is not considered a geeky programming language, nor CSS, HTML is a markup language and CSS is a presentation language. Python and PHP are excellent programming languages for beginner geeks, while Perl and C should only be learned after grasping the basic "geeky" computer and Internet concepts. If you chose to learn HTML learn XHTML.
   
8. Start learning basic repair procedures. This can help you out a lot if your or someone else's computer breaks down, which will also increase your reputation as a computer geek. You may learn the advanced methods, but that may require lessons from an actual computer geek.
   
9. Work with others with their computer problems. By interacting with other PC users, you may find that they know things that you don't and vice versa. However as a computer geek wannabe, you'll want to know more about computer than your friends, at any given time.
   
10. Help others out with their computer problems. Not only will you build a name for yourself, but it is good practice and can help you learn about situations and problems you have not encountered before.
    
11. Offer to help others with their computer problems even if they claim they don't have a problem.
    
12. Learn to recognize malware(computer viruses, spyware and the other nasty stuff) before running the daily antivirus/antispyware scans.
    
13. Use a restrictive firewall, that would cause normal people to cry because they don't understand how to use it. Of course, you should know how to use it!
    
14. Use an Open Source Operating System
    
    • Most computer geeks will use an open OS, because it is (usually) free and allows them to do geeky stuff such as programming, running servers and using a command line interface (CLI).
      
    
    
15. Know the expression "Free as in beer or free as in speech" and what it means.
    
16. Use FireFox and install the NoScript addon.
    
17. Use Shortcuts.
    
18. Know the inner workings of the Internet.
    
19. Shop at ThinkGeek
    

Tips

• Obtain an anti-virus and spyware software, as this can keep your computer infection-free. Be sure you are wary of what anti-virus and spyware programs you download, however, as many turn out to be more malicious than the problems they are supposed to prevent.
  
• When fixing computers, it may be good to keep a flash drive or IPod to carry utilities, diagnostics, or just the drive for space to move files from/to computers for diagnostic purposes.
  
• When fixing software, keep a CD with you, containing at least 5 different antiviral and antispyware products and an open OS.
  
• Always have a better sort of cooling system(preferably liquid nitrogen) when overclocking computers.
  

Warnings

• Trying to fix computer problems(specifically: hardware problems) may void the said hardware's warranty. But of course, computer geeks do that every day.
  
• Being a computer geek may seriously damage your social life. Be prepared to live with it.
  

Related wikiHows

• How to Learn a Programming Language
  
• How to Be a Techno Geek
  
• How to Be a Geek and Be Popular
  
• How to Become a Geek
  

Article provided by wikiHow All content on wikiHow can be shared under a Creative Commons license.

Add Songs to Your Movies on Windows Movie Maker

How to Add Songs to Your Movies on Windows Movie Maker

A simple step-by-step guide on how to add music to Windows Movie Maker.

Steps

1. Make sure you have the music file you want saved onto your computer.
   
2. Open the Windows Movie Maker.
   
3. Make your movie as usual (i.e. put in your pictures or clips where they need to go.)
   
4. Look to the left side of the screen. There should be a header that says "Capture Video" and below it should have an option that says "Import Audio or Music" Double click on that.
   
5. A browse box should pop up, with a list of documents. Go to where you saved your music file (preferably under "My Music" in your documents.), then double click on it. It should be transfered into the Movie window with any other files you might have.
   
6. Left click and hold, to drag your music clip into the spot on your timeline where you want it to go. After positioning it on the timeline, release the left click. Your music should be where you placed it.
   
7. From here you can crop the music (make it shorter) to fit how long your clips and/or pictures are.
   

Tips

• Windows Movie Maker supports these types of music files: .aif, .aifc, .aiff .asf, .au, .mp2, .mp3, .mpa, .snd, .wav, and .wma Most of the music files you take are going to either be .mp3, .wav, or .wma so you don't have to worry too much about the others.
  

Related wikiHows

• How to Save Music from Websites
  
• How to Rip Music from a CD to a Computer
  

Article provided by wikiHow All content on wikiHow can be shared under a Creative Commons license.