Loading data into MySQL DB - How to ?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
gsxrian
Forum Newbie
Posts: 5
Joined: Tue Aug 26, 2008 11:50 am

Loading data into MySQL DB - How to ?

Post 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
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: Loading data into MySQL DB - How to ?

Post 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.
gsxrian
Forum Newbie
Posts: 5
Joined: Tue Aug 26, 2008 11:50 am

Re: Loading data into MySQL DB - How to ?

Post 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
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: Loading data into MySQL DB - How to ?

Post by jayshields »

Yes and yes.
gsxrian
Forum Newbie
Posts: 5
Joined: Tue Aug 26, 2008 11:50 am

Re: Loading data into MySQL DB - How to ?

Post by gsxrian »

Thanks
gsxrian
Forum Newbie
Posts: 5
Joined: Tue Aug 26, 2008 11:50 am

Re: Loading data into MySQL DB - How to ?

Post 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
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: Loading data into MySQL DB - How to ?

Post 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.
Doug G
Forum Contributor
Posts: 282
Joined: Sun Sep 09, 2007 6:27 pm

Re: Loading data into MySQL DB - How to ?

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Loading data into MySQL DB - How to ?

Post 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.
(#10850)
Post Reply