Move WordPress from shared database

My WordPress database was initially installed in a shared database with four other WordPress installations.  I wanted to move my blog to its own database so that it would be easier to backup and make and restore.

Place your WordPress into maintenance mode so  no changes are made while doing this. In phpMyAdmin I selected the database, went to the export tab.  Then I selected the tables that contained my WordPress installation, then exported it to SQL  format.  After the export,  I opened the exported file with Notepad++ I edited the database name and any paths.

After editing the file. Open phpMyAdmin created a new empty database. Then select the database and go to the import tab and import the edited file.  In your WordPress installation rename the wp-config.php, then open your blog. The installation page will appear, complete the database connection, this is all that is required. Login as admin and turn off maintenance mode. Your blog should be up and running in the same state it was in before the migration, (except in it’s own database).

This should be able to be done in about thirty minutes.

Good luck :-)

MySQL new install

Installed MySQL in a OES2 server this week, install went fine. YaST install was fast and seamless. Used the Linux client to setup the users and the databases, creating the databases and users was straight forward once the syntax was correct, thanks to google made finding the syntax fairly painless.
Once created this is where problem started, getting the users access to the databases for a workstation. Mostly this issue Continue reading