Programming Forums > Web Development and Design > Other Web Development Languages

java_roshan · Feb 23rd, 2006, 11:43 AM

The title may not directly tell you what my question is ....

I have MS-SQL Server in my college LAB.

I created a database on another computer at my classmate's home.

How do I use this database in my college LAB without connecting these two computers. (i.e. the computers are not connected, so the database cannot be remotely accessed..)

There would be some file for this database...but where do I find it exactly and if I find it, should I just purely copy it at my college LAB and will it work?

Symptom · Feb 23rd, 2006, 12:31 PM

I don't know under which OS you have mysql, but that's the basic concept:

Run this in the source computer (the one with the mysql database)

(Toggle Plain Text)

% mysqldump --user=account_name --password=password databasename_tobesaved > path/to/file

Take the saved file to the other computer and run this on the target computer

(Toggle Plain Text)

% mysql - u account_name -p database < path/to/file

To be honest, I haven't tried this but it's supposed to work...

java_roshan · Feb 23rd, 2006, 1:00 PM

Oh..I am using Microsoft - SQL Server 7 in college LAB.
Same is at my classmate's home.

Since, MySQL is command based, I wouldn't be trying the solution with MS-SQL ...

I have backed up the database and will try to restore it in my college LAB...I'll see if it works!

Ghost · Feb 23rd, 2006, 1:27 PM

That should just move over pretty clean if you did an entire backup, not just tables or not just data.

Feb 23rd, 2006, 11:43 AM	#1
java_roshan Professional Programmer Join Date: Mar 2005 Location: Student of University of Mumbai, Maharashtra State, India Posts: 344 Rep Power: 4	"Moving" Databases The title may not directly tell you what my question is .... I have MS-SQL Server in my college LAB. I created a database on another computer at my classmate's home. How do I use this database in my college LAB without connecting these two computers. (i.e. the computers are not connected, so the database cannot be remotely accessed..) There would be some file for this database...but where do I find it exactly and if I find it, should I just purely copy it at my college LAB and will it work?

Feb 23rd, 2006, 12:31 PM	#2
Symptom Newbie Join Date: Sep 2005 Posts: 28 Rep Power: 0	I don't know under which OS you have mysql, but that's the basic concept: Run this in the source computer (the one with the mysql database) (Toggle Plain Text) % mysqldump --user=account_name --password=password databasename_tobesaved > path/to/file % mysqldump --user=account_name --password=password databasename_tobesaved > path/to/file Take the saved file to the other computer and run this on the target computer (Toggle Plain Text) % mysql - u account_name -p database < path/to/file % mysql - u account_name -p database < path/to/file To be honest, I haven't tried this but it's supposed to work... __________________ The geeks shall inherit the earth.

Feb 23rd, 2006, 1:27 PM	#4
Ghost Man Bear Pig Hunter Join Date: Jul 2005 Location: NorCal, USA Posts: 290 Rep Power: 4	That should just move over pretty clean if you did an entire backup, not just tables or not just data. __________________ People who click "images" that end with .exe shouldn't have computers.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 23rd, 2006, 1:00 PM	#3
java_roshan Professional Programmer Join Date: Mar 2005 Location: Student of University of Mumbai, Maharashtra State, India Posts: 344 Rep Power: 4	Oh..I am using Microsoft - SQL Server 7 in college LAB. Same is at my classmate's home. Since, MySQL is command based, I wouldn't be trying the solution with MS-SQL ... I have backed up the database and will try to restore it in my college LAB...I'll see if it works!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > Other Web Development Languages

"Moving" Databases