Copying databse table to another database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
skills2go
Forum Newbie
Posts: 2
Joined: Sat Mar 08, 2008 5:33 am

Copying databse table to another database

Post by skills2go »

Hi

I am trying to move a database table from one databse to another. I used the Export function in myphpadmin and got a text file which I saved on my computer then tried to add it to another databse on the same server. The table has the same name and I even changed the host and table name in the text file but it won't dump into the database.

Any suggestions.

Thanks
bertfour
Forum Commoner
Posts: 45
Joined: Fri Mar 07, 2008 7:33 am

Re: Copying databse table to another database

Post by bertfour »

What error do you get?
skills2go
Forum Newbie
Posts: 2
Joined: Sat Mar 08, 2008 5:33 am

Re: Copying databse table to another database

Post by skills2go »

Thank for answering|

I get this in the window after inserting sata from a text file|

Inserted rows: 0 (Query took 0.0065 sec)
SQL query:
LOAD DATA LOCAL INFILE '/var/tmp/phpOnH1sS' INTO TABLE `ams_categories` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
Post Reply