Solved

OpenSuse cloud backups

Posted on 2014-03-09
2
299 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

930 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

12 Experts available now in Live!

Get 1:1 Help Now