djdubuque — 2009-11-05T10:04:32-05:00 — #1
I have a dB on another server and it contains data I need on another host. How can I import that data into my new sites database?
They have the same table name, but there other tables are not the same.
r937 — 2009-11-05T10:17:17-05:00 — #2
which database system are you using?
djdubuque — 2009-11-05T10:22:38-05:00 — #3
r937 — 2009-11-05T11:05:56-05:00 — #4
okay, just for your information, we have a mysql sub-forum for mysql questions (i'll ask the moderators to move this thread over)
use mysqldump to create a dump file from the source database, and then use this file to create the tables in the target database
alternatively, if you have access to a front end app like phpmyadmin, the dump and restore features are built in
djdubuque — 2009-11-05T11:26:14-05:00 — #5
I can only do an export from the source dB. It will export to a CSV file.
r937 — 2009-11-05T11:57:26-05:00 — #6
do you have a front end app like phpmyadmin? they can all import csv files
djdubuque — 2009-11-05T11:59:00-05:00 — #7
Yes, the target site has phpmyadmin
phpycho — 2009-11-06T00:00:43-05:00 — #8
Have you heard of SqlYog GUI for mysql and it's tunneling feature? If yes then it definitely helps u alot.
For more info:http://www.devx.com/security/Article/27854/1954
djdubuque — 2009-11-06T07:39:28-05:00 — #9
This is a small program like Navicat, I have programs that will open dB's but my problem is that the source host doesn't have a remote login capability only export.
bruin03 — 2010-03-10T15:43:35-05:00 — #10
That is why tunnenning will help.
The idea is you upload a php file prorided with your app (navicat for instance) and set up the navicat client to connect to your mysql database via the uploaded file. The technique is called "tunnelling".
I realize this is an old thread, i just wanted to provide clarification because it seems like you didn't make the connection.
trader2 — 2010-03-22T11:48:44-04:00 — #11
..or you can use an online tool, where you install only small proxy to facilitate communication between servers. Novaquantum makes one...