Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copying tables between datasources
- Thread starter gm456
- Start date
You may use the mysqldump-tool (linux-box) to transform your database into an ascii-file
within "create table.." and" insert value into.."-syntax
(or better, use the phpMyAdmin-tool with the "View dump (schema) of database"-button plus the
"send" checkbox).
Then, edit it and reimport it somehow like
"mysql [some options about the database] > textfile" on the console (sorry, i dont have
the exact syntax yet) or again with the phpMyAdmin using
the "Run SQL query/queries on Location of the textfile"
- Button.
Hope it helps.
within "create table.." and" insert value into.."-syntax
(or better, use the phpMyAdmin-tool with the "View dump (schema) of database"-button plus the
"send" checkbox).
Then, edit it and reimport it somehow like
"mysql [some options about the database] > textfile" on the console (sorry, i dont have
the exact syntax yet) or again with the phpMyAdmin using
the "Run SQL query/queries on Location of the textfile"
- Button.
Hope it helps.
- Status
Similar threads
