What We’re Trying to Do We’re trying to set up a local web development environment on a Windows computer with an XAMPP installation. XAMPP will allow us to run Apache and MySQL on our local computer. Apache is a web server technology: it allows us to run PHP. MySQL is a database technology: it allows us to create and operate MySQL databases. For more information, see the Apache and MySQL sites. Don’t get lost — extensive knowledge isn’t required to use XAMPP. We want Apache and MySQL because without them, we cannot run PHP/MySQL applications such as WordPress or phpBB. […]
Register Your Domain and Hosting Separately
Learn what a domain name and host are, and learn why you should register your domain separately from your host.
Gotchas and Other Notes for the Absolute Beginner Web Developer
“#*@#, why isn’t it working?” If you find yourself saying that a lot, think about these basic coding gotchas. These are some very basic things that can trip you if you’re just starting out with HTML, CSS, and other things (I guess). Just remember — everything is different, everything has its own troubleshooting steps. Understand how to fix problems in general — don’t just remember how to fix specific problems you’ve encountered before. It’s more useful for you to have general problem-solving and troubleshooting knowledge that can be applied in a variety of different environments.
Importing Large MySQL Database with XAMPP
Even locally, phpMyAdmin has a size limit to the database you can import. You can change those limits, I’m pretty sure, but you can also bypass phpMyAdmin altogether and import the database with the XAMPP shell. Open the XAMPP shell (“Shell” button on your XAMPP Control Panel). Type: mysql -h localhost -u root database_name < J:\path\to\database.sql Change database_name to the name of the database you want to import to. Change the \path\to\database.sql to the appropriate path and filename. I'm working locally with XAMPP so I don't set a password on my root MySQL user (this is default behavior in XAMPP […]