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

@morningdot-6Xuj4M • Oct 25, 2024

Oct 25, 2024

1.0K

Hello friends,
Anybody have idea how to transfer our data(of database like mysql,oracle) from one computer to another(except by creating backup).

Like 0 Replies 6

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Ankita Katdare

@abrakadabra • 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.
Morningdot Hablu

@morningdot-6Xuj4M • 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

@abrakadabra • 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.
Morningdot Hablu

@morningdot-6Xuj4M • Apr 4, 2011

hmm thanks AKD for your help.
slashfear

@slashfear-tSWzpz • 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-aSUfhP • 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.