September 2008

September 30, 2008

Which is the best tool to transfer data between mysql servers located in two different machines?

mysql
kashyap asked:


Even if the tool is a shareware also its ok for me, as i am ready to buy it. I can do it with dump function available in mysql but it gives error when database size becomes too large .I thank in advance for all those who replies.

Filed under Software by administrator

Permalink Print 1 Comment

How do you install PHP and MySQL without additional software?

mysql
alto asked:


How do you install PHP and MySQL onto a computer without using things like WAMP? I am really desperate. I would REALLY appreciate you if you’d tell me how to do it step by step. Thanks.
I’m not trying to install LAMP. I’m trying to install PHP, Apache, phpmyadmin and MySQL individually without using software bundle.

Filed under Programming & Design by administrator

Permalink Print 1 Comment

Delphi for PHP mysql query sample

noamrachmany posted video:


Delphi for PHP mysql query sample

Filed under Howto by administrator

Permalink Print 3 Comments

Lecture - 32 Case Study : MYSQL

nptelhrd posted video:


Lecture Series on Database Management System by Dr. S. Srinath, Department of Computer Science and Engineering,IIT Madras. For more details on NPTEL visit http://nptel.iitm.ac.in

Filed under Education by administrator

Permalink Print

September 29, 2008

How to change drive for data folder of MySQL?

mysql
technical asked:


I have installed Apache Server on my PC, with PHP and MySQL. But I store all my files and folders in Drive D:
While MySQL stores all its databases in C:\mysql\data. I want to change the drive from C to D?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

How to configure and install apache, mysql and php on windows xp with step by step?

mysql
karthik asked:


how to integrate php and apache.
how to integrate php and mysql.
windows xp support php and mysql and apache?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

How do I configure MySql to work with the Apache 2 server and php on my computer?

mysql
Smoothie asked:


I have all three installed and they run separate of eachother. Apache and php are working great, I just can’t get MySql to come to the party.

Filed under Programming & Design by administrator

Permalink Print 2 Comments

September 28, 2008

How do I get the number of rows of each type with MySQL?

mysql
Anonymous asked:


I have a database table with two fields: id (an unique numerical identifier) and type (a string). I would like to count the number of occurrences of each of the possible values of ‘type’. Is there an easy way of doing this with MySQL?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

How to build a MySQL Database and Table?

mysql
Knowledge asked:


Does anyone have any knowledge of where I can find guides on how to build a MySQL Database and Table.

Also, Is there a reference for what type of data types there are?

Filed under Programming & Design by administrator

Permalink Print 4 Comments

How to overwrite / update a previous record automatically in mySQL?

mysql
hockey_goalie31 asked:


I have a mysql database that receives the data from a php form that submits a unique user id, and 3 sports. I will likely be adding new fields (age etc) but the main thing I want to accomplish is if my users go through the form again (logged into to the same user id) and submit different information, how could I overwrite the old entry so I only have 1 record for the user?

hopefully this is possible one way or another !

Filed under Programming & Design by administrator

Permalink Print 2 Comments