473,320 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Exporting/importing table

Hi

I have two separate databases (A and B). Both databases have one table (A).
How I could transfer the contents of table A from Database A to database B
table A? The tables are same.

Ville
Jul 19 '05 #1
5 3162
On Sun, 18 Jan 2004 14:58:21 GMT, "Ville Rontti"
<vi**********@pp.inet.fi> wrote:
Hi

I have two separate databases (A and B). Both databases have one table (A).
How I could transfer the contents of table A from Database A to database B
table A? The tables are same.

Ville


Do the tables have a unique identifier?

If not then you can just use mysqldump to dump table A, make sure that
it doesn't try to recreate the table, use awk, sed, vi, etc to change
each reference of table A to table B, then reload the data.

If it does then you will probably have to write a program that simply
takes all the information form A (minus the unique identifier) and
inserts it into B.
Jul 19 '05 #2
On Sun, 18 Jan 2004 14:58:21 GMT, "Ville Rontti"
<vi**********@pp.inet.fi> wrote:
Hi

I have two separate databases (A and B). Both databases have one table (A).
How I could transfer the contents of table A from Database A to database B
table A? The tables are same.

Ville


Do the tables have a unique identifier?

If not then you can just use mysqldump to dump table A, make sure that
it doesn't try to recreate the table, use awk, sed, vi, etc to change
each reference of table A to table B, then reload the data.

If it does then you will probably have to write a program that simply
takes all the information form A (minus the unique identifier) and
inserts it into B.
Jul 19 '05 #3
"Erik Tank" <er**@jundy.com> wrote in message
news:15******************************@news.teranew s.com...
On Sun, 18 Jan 2004 14:58:21 GMT, "Ville Rontti"
<vi**********@pp.inet.fi> wrote:
Hi

I have two separate databases (A and B). Both databases have one table (A).How I could transfer the contents of table A from Database A to database Btable A? The tables are same.

Ville


Do the tables have a unique identifier?

If not then you can just use mysqldump to dump table A, make sure that
it doesn't try to recreate the table, use awk, sed, vi, etc to change
each reference of table A to table B, then reload the data.

If it does then you will probably have to write a program that simply
takes all the information form A (minus the unique identifier) and
inserts it into B.


The table has unique identifier. Now we are just "filling" the tables with
information. Both tables will have same information. That is why we like to
have copy the contents of table A from database A to database B to table
A... So, mysqldump you said? Does it create file that I can copy to the
other database?

Ville
Jul 19 '05 #4
"Erik Tank" <er**@jundy.com> wrote in message
news:15******************************@news.teranew s.com...
On Sun, 18 Jan 2004 14:58:21 GMT, "Ville Rontti"
<vi**********@pp.inet.fi> wrote:
Hi

I have two separate databases (A and B). Both databases have one table (A).How I could transfer the contents of table A from Database A to database Btable A? The tables are same.

Ville


Do the tables have a unique identifier?

If not then you can just use mysqldump to dump table A, make sure that
it doesn't try to recreate the table, use awk, sed, vi, etc to change
each reference of table A to table B, then reload the data.

If it does then you will probably have to write a program that simply
takes all the information form A (minus the unique identifier) and
inserts it into B.


The table has unique identifier. Now we are just "filling" the tables with
information. Both tables will have same information. That is why we like to
have copy the contents of table A from database A to database B to table
A... So, mysqldump you said? Does it create file that I can copy to the
other database?

Ville
Jul 19 '05 #5
"Erik Tank" <er**@jundy.com> wrote in message
news:15******************************@news.teranew s.com...
On Sun, 18 Jan 2004 14:58:21 GMT, "Ville Rontti"
<vi**********@pp.inet.fi> wrote:
Hi

I have two separate databases (A and B). Both databases have one table (A).How I could transfer the contents of table A from Database A to database Btable A? The tables are same.

Ville


Do the tables have a unique identifier?

If not then you can just use mysqldump to dump table A, make sure that
it doesn't try to recreate the table, use awk, sed, vi, etc to change
each reference of table A to table B, then reload the data.

If it does then you will probably have to write a program that simply
takes all the information form A (minus the unique identifier) and
inserts it into B.


The table has unique identifier. Now we are just "filling" the tables with
information. Both tables will have same information. That is why we like to
have copy the contents of table A from database A to database B to table
A... So, mysqldump you said? Does it create file that I can copy to the
other database?

Ville
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ville Rontti | last post by:
Hi I have two separate databases (A and B). Both databases have one table (A). How I could transfer the contents of table A from Database A to database B table A? The tables are same. Ville
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
1
by: Luis Esteban Valencia | last post by:
Hello Everyone, Iam an intermediate ASP.Net programmer and iam facing a challenging task. I have a table in MS-SQL server database called 'Members'. The table has following fields... ...
11
by: MLH | last post by:
Anyone ever experiement importing WAB data directly into A97? Would lke a chance to look at any work done in this arena.
2
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
0
by: Mike Collins | last post by:
I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble...
6
by: sara | last post by:
I have what I think is a little strange...I have to get data from our payroll system into a specific format (fixed record length) as a .txt or .prn file only to upload to our 401k custodian. I...
16
by: pmatzek | last post by:
I am attempting to automate a process involving importing a .txt file into an existing table, changing a date in each record, then exporting the table, again as a .txt file. One field contains a...
1
by: John Overton | last post by:
I have a new requirement to Import and Export Excel tables into and out of Access 2003. The Excel tables are located on a remote server but I know the path to the Excel Files. Can you please help...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.