Announcement

Collapse
No announcement yet.

Importing database on VPS Server, please help!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Importing database on VPS Server, please help!

    Hi,

    I have a VPS server with Windows Server 2008.

    I just installed mysql-5.1.47-winx64 on it and I went through the configuration wizard.

    When I am in the 'Internet Information Services (IIS) Manager' on my server I see options for:

    - ASP.NET (.NET Authorization, .NET Compilation etc etc.)
    - FTP (FTP Authentication etc etc)
    - IIS
    - Management (Configuration Editor, Database Manager)

    I want to import my existing database from my domain. All my files are already uploaded through FTP (including all my Wordpress files).

    In the database manager I don't see any options to import my database.

    How can I import it? Can I access myPhpAdmin in some way?

    Thanks in advance!

    Oscar

  • #2
    Mysql database

    Originally posted by oscarenjonat View Post
    Hi,

    I have a VPS server with Windows Server 2008.

    I just installed mysql-5.1.47-winx64 on it and I went through the configuration wizard.

    When I am in the 'Internet Information Services (IIS) Manager' on my server I see options for:

    - ASP.NET (.NET Authorization, .NET Compilation etc etc.)
    - FTP (FTP Authentication etc etc)
    - IIS
    - Management (Configuration Editor, Database Manager)

    I want to import my existing database from my domain. All my files are already uploaded through FTP (including all my Wordpress files).

    In the database manager I don't see any options to import my database.

    How can I import it? Can I access myPhpAdmin in some way?

    Thanks in advance!

    Oscar
    Hi Oscar

    If you are using control panel,
    You can use myPhpAdmin to restore/import mysql database upto 2 mb from the import option
    if you have database larger than this size , you can restore it with following command

    mysql -u #username# -p #database# < #dump_file#
    Of course you need to replace #username# to your database username and #database# to your target database. and rename #dump_file# to your dump file file name (Ex: dump.sql) Once you enter the command, it will prompt you for your database user password, just enter in your database password and you are done
    Chris White
    (Former eUK Employee)


    UK's premier web hosting company.

    Comment

    Working...
    X