Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Moving a database to another host

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthorgilray
    • CommentTimeNov 7th 2006
     
    Hi,

    I am nobbish about MySQL. I have a site which is running on windows server and has a MySQL database in it.
    Now i want move the entire site to a new host. I have already transferred all files but the database files are not working now.

    While accessing the login page it says INTERNAL SERVER ERROR.

    Can anybody help me to come out of the problem
    • CommentAuthorhardy
    • CommentTimeNov 7th 2006
     
    Hi,

    How did you transfer the database Was it a dump for example ... And are the two server configurations the same

    Cheers
    • CommentAuthorviane
    • CommentTimeNov 7th 2006
     
    I've done this in the past via the MySQL Administrator with a simple backup/restore operation. This will allow you to compensate for different schema names on the two db servers.

    You can get MySQL Admin from www.mysql.com

    If your host doesn't allow MySQL Admin, you can do the same thing using the common PHPMyAdmin that most hosts use.

    The backup will generate a text file of commands, including your SQL data.

    You can then run those scripts on the new server to inject the data.

1 to 3 of 3

  1.