transferring the entire database to another computer

[ghai_gaurav205]

i want to transfer the entire database (along with tables and structures) that i have on my computer to another one. how to do it.

[bathurst_guy]

Dump it to a (SQL) text file and then insert it again. Do you have phpMyAdmin installed? This makes this job so easy.

[chazzy]

i want to transfer the entire database (along with tables and structures) that i have on my computer to another one. how to do it.

you need to export it somehow. different DBMS have different ways of exporting. try looking up some help information for your specific DBMS or post here if you don't know how/where. make sure you mention what dbms and version you're using.

[ghai_gaurav205]

i am using oracle 8i and developing a VB based database application. basically when making the setup, i want to know how the tables should be transferred.

[felgall]

The way I do it is to export everything in SQL format from one database using phpMyAdmin (via the Export tab) and then use phpMyAdmin on the other computer to run the SQL from the file (via the SQL tab).

[chazzy]

why do you guys keep telling him to use phpMyAdmin? He's using oracle. phpMyAdmin is a MySQL tool?

ghai: take a look at toad or project raptor (now called sql developer) if you want to do a one time dump of the database contents.