Sourdough35
02-10-2012, 04:42 PM
Apologies if this question sounds ridiculous. I'm reading all the FAQs and learning how to source DB files into MySQL. Been using PEQ's DB.
The question is, where is the DB actually stored, and what files comprise it? I understand you download the DB .sql file, run MySQL, load your database, and source the SQL in. But what does that do? What files does it modify? Is the SQL still the DB or does "sourcing" it pull content from the .sql into some other location? It's hard to tell exactly because running MySQL from a command line gives no indication of where the modifications it makes are being made.
I mostly want to know so I can figure out what files I have to move around if I want to transfer/backup a current sourced database I'm using.
The question is, where is the DB actually stored, and what files comprise it? I understand you download the DB .sql file, run MySQL, load your database, and source the SQL in. But what does that do? What files does it modify? Is the SQL still the DB or does "sourcing" it pull content from the .sql into some other location? It's hard to tell exactly because running MySQL from a command line gives no indication of where the modifications it makes are being made.
I mostly want to know so I can figure out what files I have to move around if I want to transfer/backup a current sourced database I'm using.