DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

Accessing MYSQL database on server (1459 previews)
Accessing MYSQL database on server	Posted in 08th, 02/2006 10:31 by worsley
I have downloaded DB Manager per ISP suggestion but don't underestand how to access the database on the web site used in cojunction with VB Bulletin BB program. I need to be able to transfer it to another server we are setting the web site up on. Unfortunately the person that was taking care of the site and originally set up the BB can't seem to get around to it and the site registration expires in a week. Can someone help me with figuring out how to download the database so that it can be placed on the new site Thanks Joe /
Re: Accessing MYSQL database on server	Posted in 08th, 02/2006 05:44 by support
Hi Joe, This is simple actually. Follow the steps: 1) Connect to each of the databases. You will need to use the Server Manager to this task. It is simple and quick to set up a connection 2) When the connections are ok, you may use one of the following ways to copy the database from one server to another a) Dragging and dropping the tables: - select the objects view - select the source database=>tables - select all tables - drag them into the target database - follow the instructions on the wizard to finish the process b) Using the Data Migration Wizard - Open the Wizards Manager - Select the Data Migration Wizard - select the source and target server=>Database - select the tables - follow the rest of the wizard options to finish the process c) Dumping and loading the database - right click the source database - select Dump from the context menu - this process will generate an SQL/DDL file with the commands to create the database structure - right click the target database - select Load from the context menu - when the process finishes the target database will be an exact copy of the source database That's it. DBmanager has a manual which can be accessed through the menu or pressing F1 on one of its views. Hope that helps, Support / DBTools Software
Accessing MYSQL database on server (1459 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General