MYQL

[Anon]

Sir I have installed Mysql+php4+Apache
on win-2000.Index html file is working fine.
I have got database in mysql which in linux
server, I would like to import to win2000 mysql
I need to know how to import database
from other.
regards

[Anon]

You need to do 2 steps:

1. Export the linux database.
   You need to telent onto the Linux host and use the mysqldump command.

http://www.mysql.com/doc/m/y/mysqldump.html

2. Copy the file that this generates across to your Windows server and run the script file using the mysql command prompt.

e.g. mysql < <file location>
so
mysql < c:\temp\dbcreate.sql

where dbcreate.sql is the file created in step 1.

HTH
Justin