mySQL confusion

[abathor]

I'm trying to create a simple database through the mySQL command line, and have succeeded (it says the database was created), however I cannot find the physical .sql file anywhere on my hard drive. I have tried creating different databases with different names, all to no avail.

Where are the files stored by default, I have used Windows search for any file ending with .sql and found nothing!

All I am really trying to achieve is to create a mySQL database which I can use with a PHP comment box on my site. Is there any way to do this without mySQL?

[Blink]

Are you using MySQL locally on your machine? If so it would be worth installing phpMyAdmin which will give you full access to the databases through a web browser.

It's what I use.

[zombie@computer]

if you are using mysql to create the database, why do you need a .sql ? You simply use the mysql interface to use the database, no need for individual files. .sql is just a textfile with a (list of) mysql command(s), the database itself is contained in various .bin files and whatnot. Some of which should reside in the mysql server RAM anyways.

[abathor]

I'm having extreme difficulty even getting PHP to recognise and work with mySQL at the moment. I've tried changing the various values in the php.ini file still with no results. Every time I try phpinfo I still don't see mysql mentioned.

[davidc538]

this might seem kinda stupid but i coulda sworn mySQL stores its databases in .db files and .SQL files were for scripts. i could be wrong, not 100% sure

[ScarT]

Your MySQL databases are stored in \mysql\data\ on your local computer. If you're trying to set up an Apache server with MySQL I recommend using XAMPPLite instead, since all the work is done for you.

[Blink]

Yeah, if you're struggling try - http://www.wampserver.com/en/

[Echo51]

I'd suggest Xammp, have that for random testing PHP/MySQL.

.sql's are like a dump of what the db contains, like for backup and such