Freebsd and VPC server problem....help needed

01/02/2011 07:33 OldFart#1
hello all

i have been reading on making a root server using freebsd and i have no problems getting it to work fine but i was wondering on how you get a copy of the database from the VirtualPC program so i can add it to the freebsd

is the a way to do this as in a program i can use or is there something out there i can download that it similiar to the database i can modify

as at the moment i run the server on windows andi would like to put my metin server for a windows to the freebsd

thanks

amt2.webs.com
01/02/2011 07:59 xSteelx#2
So you want to copy the Database from the Vritual PC ?

There are 2 ways:

Way 1:

1.Connect to your Virtual PC Server per FTP.
2.Go to the folder "var/db/mysql" and download the folder/s that you need.
3.Connect to your Root Server an replace the folder/s in "var/db/mysql".
4.Done

Way 2:

1.Download "Navicat" and install it.
2.Start Navicat and click at: File->New Connection->MySQL
3.Write at "Connection Name" what you want.
4.At "Hostname/IP Adress" write your "Virtual PC IP".
5.By "Username" write your username standard it is "root".
6.By "Password" write your password standard it is "123456".
7.Click at "Test Connection" to test if your Datas that you wrote are right.
8.If yes click "OK".
9.Connect with your database, double click on the entry left.(it has the Connection Name that you wrote in Step 3)
10.Press with the right click on your Table and click "Dump SQL File" and save it.
11.Click with the right mouse button at the table that you want to replace ant click "Execute SQL File".
12.Select your "Dumped SQL File" and click "Start".

or:

13.If you got Navicat Premium the full version you can make a "Backup".
14.Select your Database left.
15.Click on "Backup" at the top, then at "New Backup".
16.Write your comments if you need in "Comment" and press "Start".
17.When itīs done click at "Save" then "Save as" ant enter any title for your Backup.
18.Click at "Extract SQL" and enter a name that you want and save it.
19.For replacing the root database with the Virtual PC database connect to your Root.
20.Click at the Table left with the right mouse button and click "Execute SQL File".
21.Browse to your folder where you save your "Backup" and click "Start".
22.Done

regards xSteelx