Restoring site from a backup DB

[Tino]

Hi,

I am currently trying to restore a CMSMS based site that I lost everything for over the weekend. I have managed to obtain a backup of the database from my host, but I don't know where to start to get the site back up and running?

I have checked the documentation but it isn't the most thorough with instructions and it's left me a bit

Any help would be greatly appreciated.

Regards,
Martin

[moorezilla]

Need more information.

Are you using mysql? Do you have phpmyadmin as a frontend?

If so, it's easy. phpmyadmin has an import feature that will take your backup and recreate a database for you.

Taking for granted you have a copy of the database locally:

1. Login to phpmyadmin and make a new database.
2. Click on import and browse to your backup copy.
3. Make sure the proper database name is in your cmsms config.php file and make sure that the database user has privs to the new database.
4. As for all the cmsms files, just make sure you put them all back, and use 1.3.1.
5. Make sure you put back any other files you may have added for custom images, file uploads, or what not.

[Tino]

Thanks for the reply

I do have phpmyadmin yes, the backup database is currently in a folder on my webspace, I'll go and try what you've said.

Obviously I'll need to reinstall CMSMS, does it need to be the same version as the one that was installed, and do I install it before or after restoring the database?

Thaks again,
Martin

[moorezilla]

To be absolutely safe, I would restore as the same cmsms version it was previously. All earlier cmsms versions are available for download here. At least I think they are.

After you restore, I'd then upgrade to 1.3.1. You just want to make sure that the database schema gets upgraded correctly.

[Tino]

Ok thanks, I'll do that.

So do I install CMSMS with a blank database of the same name as the backed up database, or can I just copy the content of the backed up database into a new one of any name? Sorry about all the questions, this is new territory for me!

Thanks,
Martin

[Tino]

Having some problems with restoring the database.

I created a new database through the hosting control panel then went to the phpmyadmin front end for that database. I the clicked 'import', browsed to the backup file of the database than my hosts gave me and left everything else as it was.

However I get this error:

SQL query:

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `web35-abcrafters` /*!40100 DEFAULT CHARACTER SET latin1 */;

MySQL said: 

#1044 - Access denied for user 'web176-abcrafter'@'%' to database 'web35-abcrafters'

Any ideas?

Thanks, Martin

[alby]

#1044 - Access denied for user 'web176-abcrafter'@'%' to database 'web35-abcrafters'

[/quote]

Maybe you can not create new database in your host.
Backup your old database (export in phpmyadmin) and try to import in old database

Alby

[Tino]

Hi Alby, thanks for the reply.

I am able to create as many DBs as needed with my hosting, the DB named web176... is a new, blank DB I created to import the data of the backed up DB (web35...) into.

I no longer have access to the old database as the whole hosting account was wiped, I only have the DB dump provided by my host from their backups.

I thought I would be able to import the data from 'web35...' into 'web176...', but I can't get past this error.

Thanks,
Martin

[Tino]

Can anyone else help me with this? I need to get this site back online quickly, and if I can't restore it from the DB I'll need to recreate it manually.

Thanks in advance,
Martin.

[alby]

Can anyone else help me with this? I need to get this site back online quickly, and if I can't restore it from the DB I'll need to recreate it manually.

Download backup and edit file sql:
- drop row: CREATE DATABASE ......
- if exist a row USE , replace with new dbname
- save and import

Alby