Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303

    Unanswered: transferring table to another server

    hi,
    Im using mysql 5.0.13 and table type is Innodb. Our company has 2 branches . I want to transfer that specifec table from branch A to branch B through email. But i dont knew what file in mysql subdirectory to make as my attachement. Anybody can help me.

    thanks,

    Popskie
    Last edited by popskie; 11-10-05 at 02:21.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    Export the table and data to a .sql file. Email the file and then have them import it.

  3. #3
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303
    Ok, Im using Dbtools manager professional. I can export to .dbf, .mdb, .txt but there is no .sql here. if it is ok for u can i ask what tools you are using and its free? heheheh.

    thanks for the big help.

    Popskie

  4. #4
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    From the shell:
    http://www.dbforums.com/showthread.php?postid=4479795
    I'm pretty sure you'll just have to specify the table name after the database name.

    As far as good tools, I use phpMyAdmin. But you need php installed on your machine. If that's not an option, I'd try downloading one of the apps from the mysql site.

  5. #5
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303
    thanks for the reply. I hope dis solution is good.

  6. #6
    Join Date
    Aug 2004
    Location
    San Antonio, TX
    Posts
    84
    Another way would be to use mysqldump. You can export your entire database into a single sql file, zip it up (if it's large) and copy it to the other server, unzip it and run it.

    Not sure if DBTools has the capability, but if you can establish connections to both servers with it, it may let you duplicate databases/tables from one server to the other.

  7. #7
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    Quote Originally Posted by ranbla
    Another way would be to use mysqldump. You can export your entire database into a single sql file, zip it up (if it's large) and copy it to the other server, unzip it and run it.
    This whole post was about mysqldump .

  8. #8
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303
    ok thanks guys sqldump is good.

  9. #9
    Join Date
    Mar 2004
    Posts
    33

    Lightbulb

    Hi,

    Other option different to table dump is a database transfer or object tranfer, this option are available in many GUI's like MySQL Turbo Manager or MySQL Manager, this option is a lot easy that dump.


    Regards,

  10. #10
    Join Date
    Aug 2004
    Location
    San Antonio, TX
    Posts
    84
    Quote Originally Posted by jfulton
    This whole post was about mysqldump .
    If it was, I wouldn't have mentioned it.

Posting Permissions

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