Solved

OpenSuse cloud backups

Posted on 2014-03-09
2
302 Views
Last Modified: 2014-04-15
I have a client that has their online purchasing system database on an OpenSuse server.  This is really annoying to me since I have zero experience with OpenSuse and really very little in anything Linux.

Anyways, my concern is if something were to go down, they don't have a backup of any of their database info.  I have weeded my way through some things and found the system backup option in the YaST admin tools.  The problem is that it just doesn't start when I tell it to.  I set it for a certain time and that time just comes and goes with nothing happening.

My question is, can someone give me a very dumbed down explanation of how I can get a backup going on this?  Am I missing something?  Could you recommend a very easy cloud based system?  It doesn't have to be free either....I just want to get this thing backed up!

Thank you!
0
Comment
Question by:tchristman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 34

Expert Comment

by:Duncan Roe
ID: 39916702
You can't use system backup to backup a MySQL database. You have to use a MySQL utility. See http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
0
 
LVL 25

Accepted Solution

by:
madunix earned 500 total points
ID: 39916826
Backup DB:
mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]t
Restore DB:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]


Attached a script to run in crontab to take backup DB.

Also you could use Import and Export MySQL dump file from phpMyAdmin, or Backing Up MySQL with Webmin.

http://hosting.com/support/mysql/import-and-export-mysql-dump-file-from-phpmyadmin/
http://www.phpmyadmin.net/home_page/index.php
http://www.webmin.com/standard.html
http://doxfer.webmin.com/Webmin/MySQLDatabaseServer
bckup.txt
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question