Page 1 of 1

Copying databse table to another database

Posted: Sat Mar 08, 2008 5:38 am
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

Re: Copying databse table to another database

Posted: Sat Mar 08, 2008 7:03 am
by bertfour
What error do you get?

Re: Copying databse table to another database

Posted: Sat Mar 08, 2008 7:31 am
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'