Topic: How to make a complete backup of SME

[ihlebek]

OK! When I do a "Backup to desktop" I've got a big file "xxxxxxx.rar" but how to backup the mysql-databases?

How can I do a complete backup for my SME 5.5?

I would like to upgrade my SME 5.5 to 6.0.1 but I like to make a complete backup first?

Is there a "How-to"?

Regards
Ihlebek

[MoonLight]

what you could do it login into mysql itself and export the databases.

at a command prompt type in :-

mysqldump --opt --all-databses -rbigdump.sql

it will put all your databases into 1 sql file named at the end of the line feel free to change this, however I wouldn't remove the --opt as if you do it loads the dump into memory and then outputs it, this could be a problem for large databases.

Any problems post back here and will see what I can do.

[raem]

ihlebek

> When I do a "Backup to desktop" I've got a big file "xxxxxxx.rar"

Be careful ! If that file is larger than 2Gb you will have problems restoring from it. If your backup is larger than 2Gb you need to use something like backup2ws contrib and split the backup into less than 2Gb chunks (selectable from the setup screens).


> but how to backup the mysql-databases?

They are included in the backup to desktop, or in the backup2ws 911 Disaster Recovery backup


> I would like to upgrade my SME 5.5 to 6.0.1

The recommended path is upgrade from 5.5 >> 5.6 then >> 6.0.1