Saturday, September 27, 2008

Import WordPress database

Importing Database

The next step is to import the Word Press database into your current production MySQL database server.

First Copy your word press database dump file into your "c:\wamp\bin\mysql\mysql5.0.51b\bin" if you did not choose the default install directory you will substiute "c:\wamp" for the directory you choose.

Next start a command line tool and navigate to "c:\wamp\bin\mysql\mysql5.0.51b\bin". To start the command line interface choose Start > Run and the type "cmd".
To move to the MySQL bin directory type "cd c:\wamp\bin\mysql\mysql5.0.51b\bin".
Finally run the import tool using the MySQL dump file provided to you.
"mysql -u root < your_database_dump_File.sql"

No comments: