Hi Guys, I realise this is probably out of your scope but I'm getting deperate and you guys have always been so helpful
Request: can you tell me how to identify the 'create database' line in a V4 .sql backup so that I can restore the back-up to a V5 database for my wordpress blog.
To upgrade my wordpress blog to 2.9.2 I needed to upgrade my sql server from V4 to V5
I used the wordpress guidance to create a backup .sql file of my V4 database. I also used the in-wordpress back-up facility. Thank you for really clear step by step guidance and automated process.
Using GoDaddy web hosting I created a V5 database, then upgraded my wordpress, changed the config file then posted a few posts on the blog to check it all works - it does :-).
Then I tried to restore the backup first using GoDaddy UI - it gave me a success message but didnt actually restore, then using MyPhpAdmin (StarfieldTech), again it gave me a success message without actually restoring the backup. Both support services told me the failure is because I still have the you "create database line in your SQL file". They will not tell me how to identify this line.
Searching the backup SQL file (in wordpad) for 'Create Database' produces no results. I do not know what line to delete in order to restore my database. Please help me :-)