Hi This is a quick C&P from my own notes. It's actually about moving a database rom a 32 bit machine to 64 bit. Perhaps there are much easier ways - but - this worked for me. Note that this is for a dotproject mysql database but is just as applicable for otrs.
Your milage may vary and I do suggest taht you read the link as it contains a lot of useful information. How to Move a Database This is a bit like how to copy a database from one machine to another - generally it's also to do with backing up... Most of this comes from the following reference: http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html This is ALL about mysqldump and it's kith & kin. Anyways - heres what I did to move the dotProject database. First - I created the database on new machine - note that this can be done remotely (because root for mysql has been allowed to log on from other hosts): mysql -h 'new machine' -u 'root' -p create dotproject (the -p switch will cause mysql to ask for the password) Once created - the database needs a user adding - in this case 'dp_user'. This user needs to be granted all permissions to the dotproject database. For this - I used the mysql-administrator GUI - note though that for this - when you create a user - make sure you add all perms and hosts that will be needed - the current version has a bug that will not allow you to change the settings after they have been applied (the only way then being to remove the user and re-add it). Once the database was created - the following can be run (on old machine): mysqldump --opt dotproject | mysql -h 'new machine' -u 'dp_user' -p dotproject This dumps the database (the files can be moved but this is not without with problems - so don't do it) and pipes it directly into the new dotproject database. And thats about it - there are other options for mysqldump and this will form the basis for any backup procedures that need to be done. Cheers Chris _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
