Follow the steps in the section on Migrating directories and files using network sharing to move the SQL dump file to the folder c:\inetpub\wwwroot\Joomla on the Windows Server 2008 machine. Import a MySQL database using a simple redirect command To import a database from Windows Server 2003 to Windows Server 2008 using a simple redirect command, perform the following the procedures: On the Windows Server 2008 machine, click on the Start button, and then select Run from the Start menu. In the Run field, type cmd.exe and click on OK. A Windows command console will open. At the command prompt, normally, C:\>, type following command: mysql root < c:\inetpub\wwwroot\Joomla\dump.sql –u –p Then strike the Enter key. The cmd console will return a prompt password: Type in the MySQL administrator password and strike the Enter key. Database export using mysqldump.exe If the command runs successfully, the cmd console will return another command prompt. If not, an error message will appear and the user should check for the following: Typographical errors in the commands; Incorrect location for the file in question; A correct user name after the argument, and a correct password for that user after the argument; –u –p these are username and password for the \mysql\bin folder; The correct password at the Enter password: prompt. This will be a database administrator password. Import a MySQL database using SQLyog SQLyog is an enterprise database manager commonly purchased to manage MySQL installations. SQLyog offers a Graphical User Interface with a layout similar to Windows Explorer. If SQLyog is installed on the Windows Server 2008 machine that hosts the MySQL database, the database can be exported to a Windows Server 2008 machine using the following procedure: Launch SQLyog from a desktop icon, which is by default a leaping dolphin. The SQLyog window will open, followed by a Connect to MySQL Host dialog box. SQLyog In the Connect to MySQL Host dialog box, select localhost from the Saved Connections dropdown menu. Click on the Server tab, and enter the following values:
Follow the steps in the section on Migrating directories and files using network sharing to move the SQL dump file to the folder c:\inetpub\wwwroot\Joomla on the Windows Server 2008 machine. Import a MySQL database using a simple redirect command To import a database from Windows Server 2003 to Windows Server 2008 using a simple redirect command, perform the following the procedures: On the Windows Server 2008 machine, click on the Start button, and then select Run from the Start menu. In the Run field, type cmd.exe and click on OK. A Windows command console will open. At the command prompt, normally, C:\>, type following command: mysql –u root –p < c:\inetpub\wwwroot\Joomla\dump.sql Then strike the Enter key. The cmd console will return a prompt password: Type in the MySQL administrator password and strike the Enter key. Database export using mysqldump.exe If the command runs successfully, the cmd console will return another command prompt. If not, an error message will appear and the user should check for the following: Typographical errors in the commands; Incorrect location for the file in question; A correct user name after the –u argument, and a correct password for that user after the –p argument; these are username and password for the \mysql\bin folder; The correct password at the Enter password: prompt. This will be a database administrator password. Import a MySQL database using SQLyog SQLyog is an enterprise database manager commonly purchased to manage MySQL installations. SQLyog offers a Graphical User Interface with a layout similar to Windows Explorer. If SQLyog is installed on the Windows Server 2008 machine that hosts the MySQL database, the database can be exported to a Windows Server 2008 machine using the following procedure: Launch SQLyog from a desktop icon, which is by default a leaping dolphin. The SQLyog window will open, followed by a Connect to MySQL Host dialog box. SQLyog In the Connect to MySQL Host dialog box, select localhost from the Saved Connections dropdown menu. Click on the Server tab, and enter the following values:
Apache_to_IIS_70_-_Migration_Guide.docx