Just to update this--I tried changing the URL in $baseurl in /conf/basic_config.php as advised on another post, to newsite.com but that didn't make any difference.

You need to move your files AND your database!

(/blogs refers to typically *all* the files related to b2evolution. It's good that you don't have a /blogs folder; It's best to have the files at the root of your site and not in a "/blogs" subfolder)

We made a little refresh of this manual page: http://b2evolution.net/man/installation-upgrade/move-my-installation

Let us know it it helps.

Thanks Francois--I found that page through google but I get stuck at importing the database. I saved my database, but when I go to export it to newurl.com I get error messages about dump pages that I don't understand. Never mind, I've spent too many hours on this now. I'll have another look at it when I'm less tired!

I guess you should copy/paste your error messages here.

1) I use the backup facility in cpanel to save my old database.

2) I go to the new site's cpanel (I have installed b2e there, and created an empty new database).

3) I go to the new site's cpanel and choose php myadmin and go to "import".

4) It asks me for "file to import", so I click browse and select the filename.gz file which is my old database.

5) I get this:

Error

SQL query:

--
-- Table structure for table `evo_antispam`
--
DROP TABLE IF EXISTS `evo_antispam` ;

MySQL said: Documentation
#1046 - No database selected

Aaaggh! This is getting worse! I can't even access my oldsite/admin.php now.
----------------------------

An unexpected error has occurred!

If this error persists, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

Table 'loobyne2_bvlt1.evo_antispam' doesn't exist(Errno=1146)

Your query: Check URL against antispam blacklist

SELECT aspm_string

FROM evo_antispam

WHERE 'http://[mysite]/admin.php' LIKE CONCAT("%",aspm_string,"%")

LIMIT 0, 1
----------------------------

This is terrible! I now find that posting a new post simply sends me to the new site's home page, but without posting the new entry.

Thanks Francois but this is far too deep for me. I'm going to try to change everything back to how it was.

loobyloo wrote:

--
-- Table structure for table `evo_antispam`
--
DROP TABLE IF EXISTS `evo_antispam` ;

MySQL said: Documentation
#1046 - No database selected

You need to tell the importer which database to use
- OR you need to add a line like "USE abc;" at the beginning of the script, where abc is the name of your DB
- OR you have to ask your web host to run the import for you (they know how to do it).

Regarding your thing with going from one site to another, maybe you configured the new url on the old server or sth like that.

Here is a new page that might help:
http://b2evolution.net/man/installation-upgrade/moving-your-site/restoring-a-mysql-backup

loobyloo wrote:

This is terrible! I now find that posting a new post simply sends me to the new site's home page, but without posting the new entry.

Thanks Francois but this is far too deep for me. I'm going to try to change everything back to how it was.

You are overthinking it.It's easy. you just transfer your files, and duplicate the database.If the both sites are on the same server you dont even have to do step2.
You're making simple mistakes.It seems you didnt select and go into your new created database before going to 'import' tab.(no db selected error).

As long as you have a backup, no need to worry, you can roll back any time.Give it another shot, trust me.
If you are fine with it, i could move it for you.
Cheers

Right, I've tried for another few hours this morning and I still can't get it to work.

1) Transferred everything in public_html to public_html in the new site
2) Made a new DB in the new site.
3) Selected that DB, then imported the old DB. Went through fine.

Results:
1) Cannot access admin.php in the new site

"Additional information about this error:

MySQL error!

Error selecting database [violetpu_b2e228]!

Are you sure the database exists?
Are you sure the DB user is allowed to use that database?
Are you sure there is a valid database connection?

-------------
I am afraid that I will have to take you up on your very kind offer of help! I will PM you.

I can't PM you! :((

"Please complete the entering of a username".

I give up!

PM is broken in the forums and we are working on a fix (it already works in the manual or the news blog)

sorry about that. I hope it will be fixed today.

Error selecting database [violetpu_b2e228]!

Are you sure the database exists?
Are you sure the DB user is allowed to use that database?
Are you sure there is a valid database connection?

This typically means the name of the database, or the db user or the db password are different on the new server.

You need to edit /conf/_basic_config.php to reflect the correct information to access the new DB.

loobyloo wrote:

Right, I've tried for another few hours this morning and I still can't get it to work.

1) Transferred everything in public_html to public_html in the new site
2) Made a new DB in the new site.
3) Selected that DB, then imported the old DB. Went through fine.

Results:
1) Cannot access admin.php in the new site

"Additional information about this error:

MySQL error!

Error selecting database [violetpu_b2e228]!

Are you sure the database exists?
Are you sure the DB user is allowed to use that database?
Are you sure there is a valid database connection?

-------------
I am afraid that I will have to take you up on your very kind offer of help! I will PM you.

You are on the right track. The answer is most probably resides in one of the questions above.Make sure, double, triple check the above questions, see if you didnt make any typos writing the db_name, db_user, and if you believe both are correct, make sure your db user have rights to access the db.

I completely uninstalled b2e and reinstalled it in newsite.com/b2e/

I imported the saved database from the old site.

I went to newsite/admin.php and I get this:
-----------------------------------------------

This is b2evolution version 4.1.5.

You cannot use the application before you finish configuration and installation.

Database schema is not up to date!

You have schema version «9960», but we would need «10200».

Please use the installer to finish your configuration/installation now.

On most installations, the installer will probably be either here or here... (but I can't be sure since I have no config info available! :P)
---------------------------

Neither of the pages referenced as being the installer do anything.

The old db was wrtitten when I was using 3.3.3. If I took v.4.1.5 out and replaced it with 3.3.3 should my old db work OK?

I dont know what you are trying to achieve but it doesnt work that way, you cant use 4.1.5 files and 3.3.3 db.

If your db is 3.3, you have to use 3.3 files, and then perform and upgrade.

tilqicom wrote:

I dont know what you are trying to achieve but it doesnt work that way, you cant use 4.1.5 files and 3.3.3 db.

If your db is 3.3, you have to use 3.3 files, and then perform and upgrade.

Just desperation now really :) It's OK I think I'll drop this whole idea now. Thank you very much tilqicom and Francois for your help.

You have schema version «9960», but we would need «10200».

Please use the installer to finish your configuration/installation now.

This is actually good. It means you are on the right path.

At that point you need to go to your base url/install/index.php (that's the installer) and b2evolution will automatically offer you to upgrade your database (from db version 9960 (b2evo version 3.3.3) to db version 10200 (b2evo version 4.1.5).

You are on the right track!