Some background- I have been at my job for 2 years and enjoyed it, especially as of recent. But I was starting to feel underpaid. I stumbled across a job posting that sounded promising. I thought I was underqualified but I applied anyway. A week later I heard back from them and they wanted to set up an interview. The interview is next week. 

This week, I had a meeting at work with the director that went surprisingly well. They told me I can get promoted and wanted to start the process now. 

This job I am interviewing for would actually pay a little bit more than what I would make when I'm promoted and I think it would allow me to learn a lot more skills than what I can learn in my current job. But there's so many unknowns. I could bomb the interview and look like an idiot, preventing me from having a chance at a job there in the future. I could get an offer but end up hating it- be overworked, have terrible work life balance, micromanaged, hate my coworkers, etc. All these things aren't issues at my current job. I have great work life balance, tons of freedom, like my coworkers, feel like my work is valued. 

There is a lot of paperwork involved to get promotion at my company. You basically have to put an application together and apply for promotion. Your director and supervisors all have to write letters of support. It's ultimately up to the director but we still have to go through the process. I was told the whole thing takes 2-3 months. I mention this because I can't in good conscience ask them to do this work for me and then immediately leave. Or leave before even finishing applying for promotion. The director wants me to start putting the application together now.

I know I should at least see what this new job is about. I'm mostly terrified of completely failing the interview. I had a really bad interview experience once where I basically failed every question they asked me and I could tell the interviewers thought I was the biggest idiot they ever interviewed. This role  is a more senior role that uses a lot more skills that I don't have. I didn't lie on my resume but like everyone I may have over embellished on some points. Like, I have written SQL in the past so it *is* a skill I have...but I haven't written SQL in a few years lol. I feel like I should be studying for this interview but I don't even know how to prepare. I don't even know if I should to through with it.