Importing database on VPS Server, please help!

[oscarenjonat]

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

[eUK - Chris]

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