1. Home >
  2. Apps >
  3. Groups >

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

Question asked by mohit007kumar00 in #Databases on Apr 4, 2011
mohit007kumar00
mohit007kumar00 · Apr 4, 2011
Rank B2 - LEADER
Hello friends,
Anybody have idea how to transfer our data(of database like mysql,oracle) from one computer to another(except by creating backup). Posted in: #Databases
Ankita Katdare
Ankita Katdare · Apr 4, 2011
Rank A1 - PRO
@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
Rank B2 - LEADER
@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
Rank A1 - PRO
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
Rank B2 - LEADER
hmm thanks AKD for your help.
slashfear
slashfear · Apr 4, 2011
Rank C1 - EXPERT
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
Rank B1 - LEADER
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.

You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up