Setheus
06-17-2003, 03:49 AM
i've already transfered my forum files to my new host. now i need to transfer the DB to my new host's DB. how do i do that? what do i need?
 | View Full Version : moving forum into another host krisdv 06-17-2003, 04:08 AM What forum are you using and what control panel do you have at both hosts? Is PHPmyadmin installed? Setheus 06-17-2003, 04:10 AM im using Invision board. at dominet im using plesk at p4host (new host) im using cpanel phpmyadmin is installed on dominet. Setheus 06-17-2003, 04:34 AM anyone? krisdv 06-17-2003, 04:58 AM You can make a dump of your db using phpmyadmin and afterwards restore it using the backup/restore function in cpanel. On the new host you have to create the db first. Setheus 06-17-2003, 05:11 AM how can i make a "dump" using phpmyadmin? krisdv 06-17-2003, 05:16 AM What's the version of phpmyadmin? Setheus 06-17-2003, 05:19 AM 2.2.6 krisdv 06-17-2003, 05:22 AM Click on a database or table name in the left frame, the properties will be displayed. Then on the menu, click "Export", you can dump the structure, the data, or both. (You need both)This will generate standard SQL statements that can be used to recreate your database/table. You will need to choose "Save as file", so that phpMyAdmin can transmit the resulting dump to your station. Depending on your PHP configuration, you will see options to compress the dump. Setheus 06-17-2003, 05:27 AM "Click on a database or table name in the left frame, the properties will be displayed. Then on the menu, click "Export", you can dump the structure, the data, or both. (You need both)" I can't find that. Setheus 06-17-2003, 05:38 AM What I did is click on my DB name then clicked phpmyadmin. I dont see the properties, menu, export, ect. krisdv 06-17-2003, 05:38 AM This is in phpmyadmin, can't you see your databases? You should go to phpmyadmin first and afterwards select your database. Setheus 06-17-2003, 05:40 AM I'm INside phpmyadmin window. I can see what's in my database but I dont see the EXPORT. krisdv 06-17-2003, 06:02 AM It should be on the right hand side, if not on top of the page you should see "View dump (schema) of database" in the middle of the page. Setheus 06-17-2003, 06:11 AM I SELECTed ALL that is inside the "view dump (scheme) of database". i put a dot on "structure and data" now what's next? Setheus 06-17-2003, 06:14 AM http://www.setheus.com/pic.jpg where is it? krisdv 06-17-2003, 06:20 AM in the middle of the page .... as I said: * View dump (schema) of database you selected "Structure and data", just underneeth click "Select All" (all tables are now highlighted), further down select "save as file" and check "zipped" Now click go and save the file to your hard drive. Unzip it and use the *.sql file to upload at the new host using cpanel. krisdv 06-17-2003, 01:21 PM I suppose you figured it out? Setheus 06-17-2003, 07:55 PM got it thanks :) |