+ Reply to Thread
Results 1 to 6 of 6

Thread: Copy tables to another Database

  1. #1
    hamsn's Avatar
    hamsn is offline x10 Lieutenant hamsn is an unknown quantity at this point
    Join Date
    Mar 2008
    Location
    Earth™
    Posts
    290

    Copy tables to another Database

    Can anyone post the method to copy or export selected tables from a particular database to another database on the same site?
    I Rise, You fall.

  2. #2
    scorch94 is offline x10 Sophmore scorch94 is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    228

    Re: Copy tables to another Database

    Google for SQL SELECT INTO. MySQL doesn't support it, but you can find alternatives on their dev site ;)
    Good luck!

  3. #3
    hamsn's Avatar
    hamsn is offline x10 Lieutenant hamsn is an unknown quantity at this point
    Join Date
    Mar 2008
    Location
    Earth™
    Posts
    290

    Re: Copy tables to another Database

    ok thanks
    let me check
    anyways i have go by its tutorials
    is it very lengthy thing?
    coz my work is fairly small
    so i dont want to waste my time if its not worth for just a work.
    I Rise, You fall.

  4. #4
    scorch94 is offline x10 Sophmore scorch94 is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    228

    Re: Copy tables to another Database

    I guess it's not lengthy thing, but you can always back up your tables using PhpMyAdmin or cPanel and then import them ;)

  5. #5
    tittat's Avatar
    tittat is offline x10 Spammer tittat is an unknown quantity at this point
    Join Date
    Sep 2007
    Location
    Kerala,India
    Posts
    2,479

    Re: Copy tables to another Database

    ******Moved to Programming Help*******
    PLAY ONLINE GAMES
    WWW.TMONDO.COM PlayFar Flash Games
    Former X10 Forum Senior Moderator(Retired)


  6. #6
    hamsn's Avatar
    hamsn is offline x10 Lieutenant hamsn is an unknown quantity at this point
    Join Date
    Mar 2008
    Location
    Earth™
    Posts
    290

    Re: Copy tables to another Database

    ******Moved to Programming Help*******
    I thought of creating it program, but its neither related to any programming.Anyways ok, u are mod.


    I guess it's not lengthy thing, but you can always back up your tables using PhpMyAdmin or cPanel and then import them
    should I run that SELECT INTO syntax under sql query window?
    and of which database? where i am moving it right?
    Edit:
    well no need of any select into though, thanks for ur help
    i found it within myphpadmin and worked well without hassle

    thanks for all ur help.
    Edit:
    no closing option for this thread?
    Last edited by hamsn; 09-07-2008 at 04:27 AM. Reason: Automerged Doublepost
    I Rise, You fall.

+ Reply to Thread

Similar Threads

  1. tables in database table entries
    By stalkio in forum Programming Help
    Replies: 3
    Last Post: 07-26-2008, 07:22 PM
  2. Can you have too many tables in a MySQL database?
    By sclewin in forum Programming Help
    Replies: 8
    Last Post: 03-07-2008, 07:27 AM
  3. install drupal
    By abhi666 in forum Scripts & 3rd Party Apps
    Replies: 4
    Last Post: 02-18-2008, 08:05 AM
  4. mySQL Database copy?
    By Conor in forum Scripts & 3rd Party Apps
    Replies: 3
    Last Post: 11-30-2007, 06:14 AM
  5. PHP BB 2.0.16 Manual instalation
    By GFIV in forum Free Hosting
    Replies: 8
    Last Post: 09-14-2005, 12:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers