When creating dynamic web pages with PHP and MySQL do you have to place the MySQL files into the bin folder? or can you just place them into any folder?
@dennicauthorSep 13.2004 — #when you say 'you create them when you make a dump of your tables' do you mean when you actually insert records into the database?
...and by the way, to drop is to delete. (Be warned).
When you use PHP dynamically, you connect to the MySQL database on the fly. You can create tables, insert data into those tables, delete the contents, etc, etc.
Your php files will allow users to sign up, login, etc. All this is handled behind the scenes.
However, there are times when you'll want to go to your MySQL database and make a physical copy of the entire database, for example.
To do this sort of thing, you would use an administrative tool like PHPMyAdmin. This tool, and others like it, will create a copy of the entire database as a text file with a .sql extension.
@dennicauthorSep 13.2004 — #where do you get phpAdmin from?
and also when you dump a file how do you specify a path, say if i have a php file and the sql file (which is the actual database with the tables inside )in the same folder??
When you create a dump, you will be prompted for the location, it is just the same as when you try to save a Word document. You are asked where you want to save it.
I'm not sure if you're from a MSAccess background. Most people from that background, like me, start of by thinking of a MySQL database in the same way as an MDB database in MSAccess.
A MySQL database is an entire folder of files which is under the control of the MySQL engine. It is actually not one file, like an Access MDB.
Well, things will get clearer as you write your scripts to talk to MySQL.