copy tb1 from db1 to tb1 in db2

searain

i am using interbase.

i have 2 datbases on the same database server, db1, db2. in db1 i have a table called tb1.

i want to copy tb1 from db1 to db2 and still call it tb1. how can i write the sql statment?

thanks!

sid

just last weekend i did exactly what you want to do by hand with a 65000 entries table, just to find out, that phpmyadmin offers the feature in a nice interface without heving to dump and restore it...

www.phpwizard.net/projects/phpMyAdmin/

Sxooter

This can be very different depending on the database you are using.

I'll show you how I do it on postgresql from the command line (i.e. a shell prompt under unix)

pg_dump dbname1 -t tablename1 | psql dbname2 -e
psql dbname2 -c 'alter table tablename1 rename tablename2'

sid

ah sorry - i thought it was about mySql ... duh...

searain

as a matter of fact, i am thinking about switch to MySQL and Linux platform. Interbase is good but not so many free sample codes there for Interbase, most of them for MySQL. And Linux is cheap.

Now, I am on NT server and with Interbase Windows version, any simple SQL can help me dump on table from one database to another database?

If there isn't any. I think I may just write a page of php codes, read the data from one database and insert to another database, like the sample sid gave out for MySQL.

Sxooter

Consider both MySQL and Postgresql. MySQL is easier to maintain day to day and works pretty well as a text data store. It seems to not handle high parallel load all that well. It does however have things like full text indexing and replication built in (both add ons for postgresql). License is GPL.

Postgresql is built more as a high load transactional database, but if takes a fair bit more expertise to both maintain and utilize well. It has many more features than MySQL, things like triggers, rules, stored procedures, foreign keys with cascade, inheritence, MVCC locking (better than row level locking) and is maintained by a group of database experts. License is BSD.