If you are running MySQL Databases you probably asking yourself how can I back them up without using third party tools or Backup agents. Well the answer is quite easy. MySQL provides a command line tool called mysqldump to export entire databases to the console and by redirecting and/or piping the output we can create sufficient backups and also restore databases from them.
In this two youtube videos I will demonstrate how you can look up databases, create backup and restore databases from backup. By using this command line tools you can build your very own scripts which will do the job and by creating a Cron job you can also have that scheduled. Watch these two clips and please leave a comment to this topic or the clips, which will help me to improve further productions.
Part two finishes the progress to backup the MySQL Database and demonstrate the restore from a sql file.
today I am writing an article about how to install the Backup Exec 12.5 remote agent onto a Ubuntu 9.xx/10.xx Server to backup Linux Server to your Windows based Backup Exec. First things first, if you are a Symantec customer then you should have an Customer Account with Symantec and if not create one and register your product. Log in to their website and download the BEWS_12.5.2213_LINUX-UNIX-MAC-SAP_AGENTS.tar.gz file to your Server. Next extract the file by entering the following command:
tar -xzvf BEWS_12.5.2213_LINUX-UNIX-MAC-SAP_AGENTS.tar.gz and hit enter.
Change to the directory and go further down the path to pkgs/LINUX and there extract the VRTSralus.tar.gz with the following command:
tar -xzvf VRTSralus.tar.gz and hit enter.
Change into the directory and copy the file VRTSralus-12.5.2213-0.i386.deb into your home directory for later purposes. Now open up your internet browser and go to http://packages.ubuntu.com/jaunty/i386/libstdc++5/download and download the file: libstdc++5_3.3.6-17ubuntu1_i386.deb and save it to the same location as your remote agent.
Install both files by executing the following two commands:
sudo dpkg -i libstdc++5_3.3.6-17ubuntu1_i386.deb
sudo dpkg -i VRTSralus-12.5.2213-0.i386.deb
Create a backup user account using the following command:
sudo adduser bckpadm
Set a password for that user account with the following command:
sudo passwd bckpadm
create a group called beoper using the following command:
sudo addgroup beoper
Add the root user to the beoper group using the following command:
sudo adduser root beoper
Add the bckpadm user to the following groups adm, admin, root & beoper with the following commands:
sudo adduser bckpadm root
sudo adduser bckpadm adm
sudo adduser bckpadm admin
sudo adduser bckpadm beoper
Edit the file /etc/VRTSralus/ralus.cfg with the following command:
sudo nano /etc/VRTSralus/ralus.cfg
and add the entry to the end of the file:
SoftwareSymantecBackup Exec For WindowsBackup ExecEngineAgentsAgent Firectory List=your_backupexec_server_ip
save the changes and leave the file. Now make the Backup Exec Start script executable with the following command:
sudo chmod 755 /opt/VRTSralus/bin/VRTSralus.init
Start the Backup Exec Remote Agent with the following command:
sudo /opt/VRTSralus/bin/VRTSralus.init start
Now you can start up your Backup Exec Management Console on your Windows Server and add the Linux Server to the selection list. Before you add the Server to the selection list you should add the bckpadm user account to the Backup Exec Logon Accounts with it’s password you have set-up earlier. Now after this is done make your selection and make sure you assign the bckpadm account to the linux backup part in your selection list.
I have tested this procedure so far on Ubuntu 9.04 & 9.10 Server edition. It backed up everything and restored everything I wanted Backup Exec to.
I hope that this article makes it possible to get your Ubuntu Linux Server backed up with Backup Exec 12.5. Please post comments to this Blog and don’t forget to subscribe.