Transferring a site DB

Discussion in 'MySQL' started by wptheme, Nov 24, 2008.

  1. #1
    Hi, I recently purchased a directory site with a moderate size database.
    I got the HTML and sql
    So I uploaded the HTML and config the site to a new DB username,name I created. Uploaded the DB using phpmyadmin
    After all that hastle but I still cannot complete the site.
    The seller is a busy man and I was lucky to get the sites and domain already.
    Waiting for his reply if he can help install it to my host.
    Anyway, as an alternative are there anyone here that can help to install the host?
    Maybe I can give a domain as a present or token of gratitude or something. Thanks a lot.
     
    wptheme, Nov 24, 2008 IP
  2. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #2
    This article may help you or if you want to pay someone you can PM me.

    I will be back home in a few hours.
     
    Colbyt, Nov 25, 2008 IP
  3. cipals15

    cipals15 Well-Known Member

    Messages:
    1,085
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    100
    #3
    Backup a MySQL database:

    mysql> SELECT * INTO OUTFILE '/location/backup.sql' FROM 'tablename';

    Loading the backup to the new database:

    mysql> LOAD DATA INFILE '/location/backup.sql' INTO TABLE 'new_table';

    If you know php, you can use it as parameters for mysql_query([parameters]);
     
    cipals15, Nov 25, 2008 IP