seperating database

[Michael_N]

I have a vicibox dial and i wish to move database to another server.

Is it just enogh with a default install of mysql-server 5.1 ?

do i need to change my.cnf on the new server?

What settings do i need to change on vicibox?

Is it enogh changeing astguiclient.conf ?

Do i need to disable mysql-server on vicibox, if yes where is it done?

[DarknessBBB]

Hi Michael, as we talked in private, I've installed Vicibox Redux on both machines, and then disabled what I had to disable in "yast".

If you only have to move MySQL you only have to change its address in astguiclient.conf

for the backup I've used this string:

Code: Select all

mysqldump --opt -uUSER -pPASSWORD DATABASE | gzip -9 > /backup/`date -I`_db.sql.gz

--opt is an alias for the options

--add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset

For the restore

Code: Select all

gunzip < /backup/DATE_db.sql.gz | mysql -uUSERNAME -pPASSWORD DATABASE

[Michael_N]

thanks and if its another server like 5.1 ?