PDA

View Full Version : How to Manage & Work with MYSQL


umaiirr@yahoo.com
07-03-06, 11:12 PM
Hi Seniors,
I need to've usefull information in this regard, I'll thankfull for providing me usefull knowledge.
Let say I've an open source content management system (PHP + MYSQL), I can understand little bit PHP also MYSQL, but I don't know what I've to do for this CMS's SQL files how can I use them with application, where I've to place SQL files, please note that I've Windows XP sp2+ Apache + PHP 5.1.2 + MYSQL 5.0.18, please let me know how can I :

work with ready made SQL file ?
where I've to place them for working properly ?

I'm thankfull for every reply
Thanks in advance :)
Umair

flann
07-04-06, 12:13 PM
so are you trying to upload an sql file into your database?

umaiirr@yahoo.com
07-04-06, 07:10 PM
so are you trying to upload an sql file into your database?
Hi flann,
I's asking for localhost envoronment not to upload, and I need to know in local environment where should I place MYSQL files or any other way to use it with my php script ?
Thanks for reply

duesi
07-05-06, 02:46 AM
An SQL File is just a bunch of instructions for your databse.
Just storing them somewhere wont help (if you put your cookbook on the shelf, your dishes won't get cooked, or will they?)

In other words, you need a program that sends these instructions to the database.
If you have ssh access to your server, you can use the "mysql" command to feed it the sql file.
If not, you might have soemthing like phpmyadmin which does the same thing from a web interface.

Or even better, if you can access your fdatabase from your computer (this depends on teh security settings of your provider),
you can use tools like Mysql Front (http://www.mysqlfront.de/)

Happy Coding!