View Feed
group-icon
Databases
Discuss databases and writing database queries with fellow DB enthusiasts.
296 Members
Join this group to post and comment.
mohit007kumar00
mohit007kumar00 • Apr 4, 2011

How to transfer our data(of oracle) from one computer to another ?

Hello friends,
Anybody have idea how to transfer our data(of database like mysql,oracle) from one computer to another(except by creating backup).
Ankita Katdare
Ankita Katdare • Apr 4, 2011
@mohit: We can export data in mysql and use the .sql file on another computer.

I hope I got your question right.
mohit007kumar00
mohit007kumar00 • Apr 4, 2011
@AKD are you sure because i have tried this.I created many tables in a database named mysql.Then copied my mysql folder from "F:\mysql\data" and paste it on the other computer data dir.But still i am not able to access the tables(datas).
.
Please do some fast reply friends.Tomorrow i have to submit my web app cd.
Ankita Katdare
Ankita Katdare • Apr 4, 2011
What I mean't was, go to phpmyadmin> choose your database> select all tables> go to export option on top and press go.

A .sql file of your project will be created. When you move to another computer, run the queries inside the .sql file in the phpmyadmin and you get the replica of the database within minutes.
mohit007kumar00
mohit007kumar00 • Apr 4, 2011
hmm thanks AKD for your help.
slashfear
slashfear • Apr 4, 2011
Hi Mohit,

Ok so you wanna transfer the data from Oracle table to another oracle table right ? use export and import commands in oracle which allows you to export the data from an oracle database and import for importing the datas to an oracle database. but make sure you have the same user name and password for both the oracle databases because the ownership of the table is also copied when you use export or import option.

If you want any more help on command please feel free to ask!! 😉

-Arvind
Prasad Ajinkya
Prasad Ajinkya • Apr 4, 2011
Mohit, if its mysql you are looking for, then simply use mysqldump.

If you are thinking about migrating tablespaces from one db to another (mysql to ora), then either you use some plug-in for data importing in oracle or you export everything in .sql format.

Share this content on your social channels -