Loading data into MySQL DB - How to ?
Moderator: General Moderators
Loading data into MySQL DB - How to ?
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
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
- 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 ?
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 ?
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
If so, my server runs Windows Server 2003 as an O/S is that ok ?
Thanks
- 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 ?
Yes and yes.
Re: Loading data into MySQL DB - How to ?
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
Thanks
- 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 ?
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 ?
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
mysql admin and query browser are free downloads from mysql.com
- 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 ?
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/'.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 ?
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)