#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    1
    Rep Power
    0
    I was wondering how I could import existing tables (.ISD files) into a new database (which is hosted somewhere else).

    This is because I've got a database which contains a few tables on my own server, but now I want these tables to be imported by my hosting provider... The hosting provider already made a database which I can only access from their shell.

    Tnx alot.

    - BlackB1rd
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    London, England
    Posts
    251
    Rep Power
    15
    You could export the tables as SQL scripts using mysqldump and then import them into your new database by running the script back into mysql:

    $ mysql < myscript.sql

    Have a read of the mysqldump documentation for details.

Similar Threads

  1. Large tables or many small tables?
    By Tassadar356 in forum MySQL Help
    Replies: 4
    Last Post: February 8th, 2004, 01:07 PM
  2. tables get corrupted
    By 90coders in forum MySQL Help
    Replies: 1
    Last Post: December 5th, 2003, 05:23 AM
  3. importing tables and data into mysql
    By chekeleke in forum MySQL Help
    Replies: 4
    Last Post: November 15th, 2002, 12:23 PM
  4. table with data from two other tables?
    By SuperShaz in forum MySQL Help
    Replies: 1
    Last Post: September 27th, 2002, 02:39 AM
  5. Importing MySQL Tables into a New Database
    By chinook in forum MySQL Help
    Replies: 6
    Last Post: June 11th, 2001, 11:59 AM

IMN logo majestic logo threadwatch logo seochat tools logo