According to the codex (http://codex.wordpress.org/Moving_to_a_New_Server), and if I'm understanding it properly, I need to change some files in the database file. (Although my server stayed the same, the domain name changed.) It says:
If you are moving to a new domain, the database file may have references to your previous domain name in it which need to be changed. These include website references, emails, and links to images within your site. They will need replacing with the new domain name. A simple process of changing this information is as follows:
1. Using Notepad or another plain text editor, open a copy of the .sql database file. Using a word processor or an HTML editor could cause errors. Your best bet is to stick with a generic plain text editor.
2. Using the search and replace function in the text editor, find all instances of the blog's old URL and replace it with the new URL.
3. Repeat the process with your old email address. (For example, replacing email@example.com with firstname.lastname@example.org)
4. Save your changes.
I understand all of this. What I don't understand is where I should find the .sql database file that needs editing with a text editor. I realize this is probably a very "duh" question, but I've banged my head on the wall enough and am conceding defeat. Help?