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
Copying databse table to another database
Moderator: General Moderators
Re: Copying databse table to another database
What error do you get?
Re: Copying databse table to another database
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'
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'