Create a new wordpress database, say wordpress2, and then make offline modifications of the exported SQL files and then re import them into the new database, wordpress2, until it's right and complete.
- Log into phpMyAdmin; select the Databases tab; at the top under Create Database enter wordrpress2 and click the Create button.
- Browse to wordpress the default name for a Wordpress installation (on Amahi server at least) and click the Export tab.
- Browse to wordpress2 and click Import and browse to the folder on your local PC with the your exported wordpress.sql file.
- Edit your wordpress installations config.php (.../var/hda/web-apps/wordpress/html/config.php), with any editor, such as gedit. You'll find a line referencing you wordpress database, in the default case wordpress. Simple change this to wordpress2.
- Refresh your Wordpress Blog to establish the new database is working correctly.
I found one of the best editors for hacking about huge .sql files to be the Windows based Notepad++, it also run pretty well through Wine.