How to load data file to mysql

copy xx.sql file to your mysql\bin forlder
than login to mysql
mysql> source xx.sql;

Comments

Post a Comment

Popular posts from this blog

How to install and configure PHP5 with IIS6 on Windows Server 2003 in five easy steps.

I thought installing PHP would be as easy as just using the install program. Well it wasn't... But by learning from my mistakes it can be almost that easy. Just follow these five easy steps on how to install and configure PHP 5 on a Windows Server 2003 running IIS - after trying the manual and several guides and tutorials found on the net (of which some were very long and very complicated and some were short and easy but partially incorrect) this is what it all came down to. Enjoy. This is tested on PHP 5.0.4, IIS6 on Windows Server 2003 SP1. Be aware that IIS is not automatically installed with all editions of Windows Server 2003, this guide assumes that IIS 6 and Windows Server 2003 is already up and running on your server. 1. Download PHP at http://www.php.net/downloads.php. Make sure you dowload the "zip package", the installer package won't work. 2. Extract the downloaded zip file to a directory of choice on your harddrive. The rest of this guide will assume you ...
Read more

Install IIS 6 + PHP5.2.5 + MySQL in WIN 2003 (PART2)

Today let's lean how to set MySQL. 1. Download MySQL5.0.51a from http://dev.mysql.com/downloads/mysql/5.0.html 2. Unzip it to your C: drive. Then click setup.exe 3. Select "typical" installation.-->standard configuration-->install as windows service-->set new root password (write it down somewhere, otherwise....) 4. Now you can see Mysql in C:\Program Files\MySQL 5. Want access the database? Go to start-->all programs-->MYSQL-->MySQL server 5.0-->MYSQL command line client. 6. Read MYSQL tutorial from this link http://webhelp.ucs.ed.ac.uk/services/mysql/example1-cli.php 7. Add C:\PHP to your path. From the Start menu, right click My Computer and select Properties. From the Advanced tab click the Environment Variables button. Under System Variable find Path and click Edit. At the end of what is already present in Variable Value add a semicolon (;) and then C:\PHP. 8. If you can see it, Then your are success set up MYSQL, simple ! C:\mysql\bin\mysql.exe ...
Read more