Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: copying info from one mysql databse to another

    does anybody know a query i could use that will copy all the info from one table ina a databse to another table in the databse as soon as its added?

  2. #2
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15

    Re: copying info from one mysql databse to another

    Originally posted by darudude
    does anybody know a query i could use that will copy all the info from one table ina a databse to another table in the databse as soon as its added?

    http://www.mysql.com/doc/en/mysqldump.html

    Best regards,
    archm

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    thx for the quick reply. should i use the mysqldump or mysqlcopy? and does this go into a query in phpmyadmin? or do i enter it in a php file?

  4. #4
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15

    DUMP

    Hi,

    I would take mysqldump because you store it in a script-file and do a batch on it. About mysqlcopy I do not know much but a dump is a dataset where the stored information of database/tables is saved sequentiell. Best is you test it. I did not test it but will do it soon to make sure I can administrate the databases well. Get the mysql reference. Especially chapters 5 and 6 are very interesting because they teach you the administration. They also tell there about reorganisation and other important things on mysql. Normally I adminstrate DB2 on a Host so I know the techniques but not how to handle them in mysql.

    You can download it here:

    http://www.mysql.com/get/Downloads/M...chen.de/mysql/


    Best regards,

    archm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •