Need to move astracker and its database to new server

Discussion in 'MySQL' started by gillian1, Jan 29, 2007.

0
  1. #1
    Hi

    I need to move my astracker software and corresponding database to a new server. The database is now too big for my current hosting to allow any decent searches. It just times out. So I'd like to move the whole thing to my VPS.

    I can manage .ftp and can reinstall the software easily enough but I have never moved a database before. I did a quick search on Google and in this forum and the process looked a bit complicated but I'm not sure that the posts I found were wanting to do the same thing as I do.

    So, how difficult is this? Is this something I could tackle myself or is it best left to someone who knows what they are doing?

    Of yes . . . I have root access to the VPS but not to the server that astracker and database are currently installed on. (This seemed to be an important factor in the info I read).

    Thanks for your help.
    Gillian
     
    gillian1, Jan 29, 2007 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Depending on how big the DB is, you can export it via phpmyadmin (assuming you have it) and run the .gz file via ssh. Or you can ask your hosting to create the db backup for you and again, run it via shell.
     
    maiahost, Jan 29, 2007 IP
  3. gillian1

    gillian1 Peon

    Messages:
    142
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for your response. I don't have phpmyadmin on my cpanel and the rest of your post doesn't mean anything to me so I suppose that answers my question really - I need to get someone to do it who knows what they're doing.

    Thanks for your help.
    Gillian
     
    gillian1, Jan 29, 2007 IP
  4. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #4
    OK - I will try to explain - ask your current host to give you the database backup. Upload the backup to the VPS and run this : 
    mysqladmin -u USERNAME -p create DATABASE
    Code (markup):
    Where database is you database name and username is your username and : 
    mysql -u USERNAME -p DATABASE < FILENAME.mysql
    Code (markup):
    Or as you said get s.o. that knows how to do it
     
    maiahost, Jan 30, 2007 IP
  5. ForumJoiner

    ForumJoiner Active Member

    Messages:
    762
    Likes Received:
    32
    Best Answers:
    0
    Trophy Points:
    83
    #5
    1.There is a free program, called SQL Manager Lite. You can find a link here.

    2. Copy the php file that comes with SQL Manager Lite program in the root of your website account.

    3. Start the MySQL Manager LIte program and connect to the database.

    4. Export your database into sql format.

    In my opinion, it's easier than using PhpMyAdmin.

    Should you need any help on any of the steps, please post your question and I will be happy to answer back.
     
    ForumJoiner, Feb 8, 2007 IP