Tuesday, July 1, 2008

Mysql Data Transfer from one server to other server - mysqldump

1>First run this command in you windows folder I mean in C:\Program Files\MySQL\MySQL Server 5.0\bin>
mysqldump -u root -p password -h Host IP DatabaseName>Sql_Text_file.sql
2> this will create all tables and data with insert command.
3> copy this script and connect to remote server by using mysql query browser and run to insert/create database and table.
www.visli.com - hot deals

No comments: