exporting mysql database in windows vista

[rochie]

Hi all,
I'm running MYSQL Server 5.1 on a Vista laptop, I want to export the database to another machine, how do i do this?
thanks

[batterj2]

Do you have a client tool for the database e.g. PHPYMyAdmin, SQLYog? If so, backup the database as an SQL dump, then install the database on your other machine and then restore the database using that SQL dump.

[Vege]

or with cmd:

OUT: mysqldump.exe -u root -p >all.sql

IN: mysql.exe -u root -p <all.sql

This would be full mysql dump.

[HostWeb]

Microsoft's Vista Enterprise website explains how to obtain it:
http://www.microsoft.com/windows/product...

Most important is the Volume Licensing Program you will need. Please see here:
http://www.microsoft.com/licensing/mla/

You can also contact a Volume Licensing Specialist:
http://www.microsoft.com/licensing/conta...

In the United States, call (800) 426-9400, or visit the Microsoft Licensing Program Reseller page.

Hope this helps.




-----------------------------------------------------