Solved

OpenSuse cloud backups

Posted on 2014-03-09
2
297 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
2 Comments
 
LVL 34

Expert Comment

by:Duncan Roe
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
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…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now