Page 1 of 1

Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 12:01 pm
by gsxrian
I am totally new to the PHP, MySQL environment and recently purchased a job board, that uses MySQL and PHP.
I currently have my database running on SQL server 2008 and want to get the data into the MySQL DB.
I guess MySQL does not have an equivalent Management Studio so i was advised to download
myphpadmin.
Once you download myphpadmin to the desktop, which extracted program do you run to activate the start myphpadmin ?
I know how to do the SQL Query, i am just not sure how to get the environment started.
Thanks

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 12:30 pm
by jayshields
Once you've install MySQL you can launch the command line client, if you're in Windows you'll probably have a Start menu folder containing a shortcut to it. PHPMyAdmin is a good tool to use to manage your MySQL database(s) through a web browser. To use it you'll have to install it on a PHP enabled web server, and then you can access it like all other web apps.

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 12:58 pm
by gsxrian
Just to clarify, you cant run PHPmyadmin from a desktop only a server ?
If so, my server runs Windows Server 2003 as an O/S is that ok ?
Thanks

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 1:09 pm
by jayshields
Yes and yes.

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 1:31 pm
by gsxrian
Thanks

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 2:10 pm
by gsxrian
Ok i've downloaded and extracted the phpmyadmin files, what file do i run to get to the next step? I dont see a .exe file ?
Thanks

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 2:15 pm
by jayshields
There are install files with the package and also on the MySQL website, you'd be better off looking in either one of those or Google.

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 9:32 pm
by Doug G
I'd recommend you get mysql administrator and mysql query browser, combined in mysql-gui-tools for tools to run on your own workstation. These tools work fine as long as any remote mysql databases allow remote connections, if not then phpmyadmin on the db server is the answer.

mysql admin and query browser are free downloads from mysql.com

Re: Loading data into MySQL DB - How to ?

Posted: Tue Aug 26, 2008 10:12 pm
by Christopher
gsxrian wrote:Just to clarify, you cant run PHPmyadmin from a desktop only a server ?
If so, my server runs Windows Server 2003 as an O/S is that ok ?
To clarify, phpMyAdmin is a web application. So any machine running webserver with PHP and MySQL installed and configured can run it. It is OS independent (as is PHP). You install it's directory inside your webserver's public directory. If you name the directory 'phpmyadmin' then you would 'run' phpMyAdmin with the URL 'http://myservername/phpmyadmin/'.

Also like most Unix style programs, phpMyAdmin uses a text configuration file that either you edit or some configuration code generates. Follow the installation instructions.