Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th September 2006, 18:44
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 212
Thanked 648 Times in 294 Posts
Default MySQL version for mysql-zrm on Debian Sarge

Hello Falko,

First, i want to thank you for your great how to called "MySQL Backup And Recovery With mysql-zrm On Debian Sarge".
I am really interested in this so i like to give it a try.

Before i start with it, i need to know if it is necessary to update the MySQL-version on my server and if so how can i do this?

The MySQL part of my ISPConfig server has been setup according these commands:

apt-get install mysql-server mysql-client libmysqlclient12-dev

And if i check the output of my phpinfo file it says:

Client API version 4.0.24

So, I guess this is the version of the MySQL, i am running on my server.


You mentioned in your how to "MySQL Backup And Recovery With mysql-zrm On Debian Sarge" that this backup system needs MySQL 4.1 at least.
So my conclusion is: i have to update my MySQL software form 4.0.24 to 4.1.

- How can i do this on Debian Sarge (Unofficial 64 bit) ?

I found this in the forums:
apt-get install mysql-server-4.1 mysql-client-4.1 libmysqlclient14-dev
Is this all i need before i proceed?

- Is updating no problem for websites with databases using the current version of MySQL?
- Will an update effect my databases and will i be able to login again?

Please let me know as i am not an expert at this point.
__________________
Hans

MrHostman | Master in managed hosting

Last edited by Hans; 28th September 2006 at 18:59.
Reply With Quote
Sponsored Links
  #2  
Old 29th September 2006, 06:41
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 212
Thanked 648 Times in 294 Posts
Default MySQL update from 4.0.24 to 4.1

I could not wait to start with Falko's how to so i did:

apt-get install mysql-server-4.1 mysql-client-4.1 libmysqlclient14-dev

And it worked perfectly!!!

unbelievable that this is all (thanks to Debian).
__________________
Hans

MrHostman | Master in managed hosting
Reply With Quote
  #3  
Old 29th September 2006, 14:25
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by Hans
You mentioned in your how to "MySQL Backup And Recovery With mysql-zrm On Debian Sarge" that this backup system needs MySQL 4.1 at least.
So my conclusion is: i have to update my MySQL software form 4.0.24 to 4.1.
I guess it also works with MySQL 4.0, but I didn't test, and the Zmanda web site says that they only tested with 4.1, 5.0, and 5.1 beta.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 29th September 2006, 15:01
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 212
Thanked 648 Times in 294 Posts
Thumbs up Works great

Falko,
i want to know that the MySQL backup system works great.

I updated to MySQL 4.1 (for sure) and just tested it !

Thanks for your great how to.
__________________
Hans

MrHostman | Master in managed hosting
Reply With Quote
  #5  
Old 7th November 2006, 23:08
nenad nenad is offline
Senior Member
 
Join Date: Nov 2005
Location: Novi Sad, Serbia
Posts: 415
Thanks: 13
Thanked 5 Times in 5 Posts
Default

Are those errors something that I should be worried about?

----------------------------------------------------------
Tue Nov 7 22:17:26 2006: INFO: backup-set=dailyrun
Tue Nov 7 22:17:26 2006: INFO: backup-date=20061107221726
Tue Nov 7 22:17:26 2006: INFO: backup-date-epoch=1162934246
Tue Nov 7 22:17:26 2006: INFO: retention-policy=7D
Tue Nov 7 22:17:26 2006: INFO: mysql-version=4.1.11-Debian_4sarge7-log
Tue Nov 7 22:17:26 2006: INFO: backup-directory=/var/lib/mysql-zrm/dailyrun/20061107221726
Tue Nov 7 22:17:28 2006: ERROR: Copy from /var/lib/mysql/master.info to /var/lib/mysql-zrm/dailyrun/20061107221726 failed
Tue Nov 7 22:17:28 2006: ERROR: Error backing up master.info
Tue Nov 7 22:17:28 2006: ERROR: Copy from /var/lib/mysql/relay-log.info to /var/lib/mysql-zrm/dailyrun/20061107221726 faile
Tue Nov 7 22:17:28 2006: ERROR: Error backing up relay-log.info

Tue Nov 7 22:17:28 2006: INFO:
Tue Nov 7 22:17:28 2006: INFO: backup-level=0
Tue Nov 7 22:17:38 2006: INFO: logical-databases=ispconfigdb mysql test web36_db1 web4_db1 web4_db2 web8_db1
Tue Nov 7 22:17:38 2006: INFO: read-locks-time=00:00:10
Tue Nov 7 22:17:38 2006: INFO: flush-logs-time=00:00:01
Tue Nov 7 22:17:38 2006: INFO: backup-time=00:00:12
Tue Nov 7 22:17:38 2006: INFO: backup-size=4.15 MB
Tue Nov 7 22:17:38 2006: INFO: next-binlog=mysql-bin.000076
Tue Nov 7 22:17:38 2006: INFO: /var/lib/mysql-zrm/dailyrun/20061107221726/backup.sql=e7c66f2c218479765ca343be8ee8ea03
Tue Nov 7 22:17:38 2006: INFO: backup-status=Backup done but with errors
Tue Nov 7 22:17:38 2006: INFO: Backup done but with errors
-----------------------------------------------------------------

and

---------------------------------------------------------------------
server201:~# mysql-zrm-scheduler --now --backup-set dailyrun --backup-level 0
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
Use of uninitialized value in concatenation (.) or string at /usr/bin/mysql-zrm line 1305.
INFO: mysql-zrm-version
INFO: backup-set=dailyrun
INFO: backup-date=20061107230239
INFO: backup-date-epoch=1162936959
INFO: retention-policy=7D
INFO: mysql-version=4.1.11-Debian_4sarge7-log
INFO: backup-directory=/var/lib/mysql-zrm/dailyrun/20061107230239
cp: cannot stat `/var/lib/mysql/master.info': No such file or directory
ERROR: Copy from /var/lib/mysql/master.info to /var/lib/mysql-zrm/dailyrun/20061107230239 failed
ERROR: Error backing up master.info
cp: cannot stat `/var/lib/mysql/relay-log.info': No such file or directory
ERROR: Copy from /var/lib/mysql/relay-log.info to /var/lib/mysql-zrm/dailyrun/20061107230239 failed
ERROR: Error backing up relay-log.info
INFO:
Use of uninitialized value in pattern match (m//) at /usr/bin/mysql-zrm line 1077.
INFO: backup-level=0
INFO: logical-databases=ispconfigdb mysql test web36_db1 web4_db1 web4_db2 web8_db1
INFO: read-locks-time=00:00:02
INFO: flush-logs-time=00:00:00
INFO: backup-time=00:00:02
INFO: backup-size=4.15 MB
INFO: next-binlog=mysql-bin.000078
INFO: last-backup=/var/lib/mysql-zrm/dailyrun/20061107230217
INFO: /var/lib/mysql-zrm/dailyrun/20061107230239/backup.sql=d83be38ee7111245ff9c07ca18b1038c
INFO: backup-status=Backup done but with errors
INFO: Backup done but with errors
Use of uninitialized value in hash element at /usr/bin/mysql-zrm line 1986.
ERROR: /usr/bin/mysql-zrm did not finish successfully
server201:~#
---------------------------------------------------------------------------------------------
__________________
Nenad Bulatovic
---------------
Debian Lenny & ISPConfig 3
Reply With Quote
  #6  
Old 7th November 2006, 23:21
nenad nenad is offline
Senior Member
 
Join Date: Nov 2005
Location: Novi Sad, Serbia
Posts: 415
Thanks: 13
Thanked 5 Times in 5 Posts
 
Default

Quote:
Use of uninitialized value in concatenation (.) or string at /usr/bin/mysql-zrm line 1305.
Is because of this:

Quote:
This was because the /etc/mysql-zrm/mysql-zrm-release file was empty.

So if the install is done from the source directly, do not leave the file
empty.

The warning message will be fixed and an appropriate warning message will be
printed. The fix will be available in the next release.
http://forums.zmanda.com/pipermail/m...er/000013.html

And this:
Quote:
Tue Nov 7 22:17:28 2006: ERROR: Copy from /var/lib/mysql/master.info to /var/lib/mysql-zrm/dailyrun/20061107221726 failed
Tue Nov 7 22:17:28 2006: ERROR: Error backing up master.info
Tue Nov 7 22:17:28 2006: ERROR: Copy from /var/lib/mysql/relay-log.info to /var/lib/mysql-zrm/dailyrun/20061107221726 faile
Tue Nov 7 22:17:28 2006: ERROR: Error backing up relay-log.info
was because of this:
/etc/mysql-zrm/mysql-zrm.conf
Code:
replication=1
so I changed it to
Code:
replication=0
__________________
Nenad Bulatovic
---------------
Debian Lenny & ISPConfig 3
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19
mysql 5 und debian sarge pontifex Installation/Configuration 6 7th October 2006 11:24
Debian Sarge 3.1 and MYSQL problem SteveBennett HOWTO-Related Questions 1 24th May 2006 18:09
KErnel not showing all my memory Jorem Kernel Questions 8 13th April 2006 12:59
e-mail problem!!! Debian 3.1 maroonworks Installation/Configuration 18 6th December 2005 14:42


All times are GMT +2. The time now is 04:21.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.