Server :: Tar Backup And Restore In Mysql?
May 6, 2011how to take tar backup and restore in mysql,Iam new to mysql,i searched in google but i did not get the exact one.
View 4 Replies
ADVERTISEMENT
Server :: Mysql Backup And Restore Scripts?
Apr 11, 2011writting shell scripts,i searched in google but could not get the exact,pls can anyone help how to take mysql backup & restore using shell scripts.
View 3 Replies View RelatedUbuntu :: Restore Backup Server - Where Is The Location Backup Snapshots Or Files Are Saving
May 10, 2011I install and tested Restore EE Backup server on a test PC with basic configuration and its working fine.
[URL]
The issue i have is where is the location these backup snapshots or files are saving? I want to add a separate Storage to save the backup?
Server :: Recover MySQL Innodb From /var/lib/mysql/ Backup?
Jan 30, 2011I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
Server :: Mysql Will Not Restore Database?
Feb 21, 2011I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows;Quote:
0,4),('2011-02-21 03:30:32','Queue Wait Outside (100)','Queue Wait Outside (100)',11,0,4),('2011-02-21 03:30:49','Queue Wait Sleep (30)','Queue Wait Sleep (30)',5,0,4),('2011-02-21 03:30:53','Queue Wait Sleep (30)','Queue Wait Sleep (30)',13,0,4)
[code]...
Server :: Backup / Restore - Importing LVM Setup At Destination
Jun 8, 2009I am doing a LVM replicate to another server.
Example: server1.foo.com has / , /boot , swap and few LVM partitions. All are in /dev/sda disk of size 80GB. /dev/sda5 is a LVM partition which has only one vg00 and it has 2 LV's (/var and /usr) and a SAN storage connected to this server which has around 500GB of single partition(a LV partition) called /data and its under vg00 .
Now I have build another server called "server2.foo.com" with same RedHat OS version - RHEL 4 and want to import the same LVM setup at destination. Down time or unmounting the filesystem is not a problem (but am trying to reduce the down time as much as possible). Is there any way that I can take a proper snapshot of whole LVM disk and restore with same setup at destination without losing the data and the lvm file system layout?
CentOS 5 :: Server Crash - Restore Backup - Scsi ?
Apr 25, 2011Client has a server running 5.5 (I think) and it they moved locations. This server is used in other locations (state) via ssh tunnel as well so they can all access files.
When attempting to boot up I get screenshot 1 (superblock errors)[url]
They supposedly have a backup on a hot swap scsi and I want to know how/if I can restore it using that backup if I cant fix the superblock boot/error issue.
I took some other screenshots:
[url]
[url]
[url]
Server :: Recover A Compressed Mysql Backup?
Dec 6, 2009I'm trying to recover a compressed mysql backup. As the backup is extremely large, I dont wanna decompress it before importing. How can I make a mysql variable take effect before I load this compressed file into the database.
View 7 Replies View RelatedFedora :: Backup System To Restore Server Incase The Hard Disk Is Damaged
Jan 13, 2011This is a good way to backup my current system:
How to backup your system to restore your server incase the hard disk is damaged.
Server :: Stop Mysql In Order To Preform A Backup?
Apr 12, 2010I'm working on an old redhat server with mysql installed and I need to find a way to stop the service in order to preform a backup.
some info that I found on the server code...
Server :: MySQL Backup Cron Job Not Executing Correctly?
Mar 2, 2011I own a CentOS 5 VPS. I typed crontab -e, and then I added the following line to automatically have my server backup mysql
0 * * * * mysqldump -u root -p password --all-databases | gzip > /home/dbbackup/database_`date '+%m-%d-%Y_%H'`.sql.gz
When I go in and look, it doesn't place any files in /home/dbbackup. When I run
mysqldump -u root -p password --all-databases | gzip > /home/dbbackup/database_`date '+%m-%d-%Y_%H'`.sql.gz
Programming :: Create A Bash Menu Script For Home Server - Restore Files From A Backup?
Jan 19, 2011I would like to create a bash menu script for my home server For instance if i were to type ./script It would then bring up 3 options
a. Create a backup
b. Restore files from a backup
c. Quit
If you were to select a or b it should then ask you were you want to backup or restore from. And if i were to type in an incorrect letter i should get an error and take me back to menu. I have attepmted this a view time now and have magaged to get the menu up using parameters
Debian :: Used Backup-manager - Restore The Backup Data?
Feb 4, 2011I am now preparing myself to upgrade lenny to squeeze and decided to do a backup on my system. I used backup-manager to do the job and it worked fine. how do you restore said backup data?
View 4 Replies View RelatedServer :: MySQL Backup - Deal With Large Amounts Of Data?
Feb 15, 2011we've been trying to become a bit more serious about backup. It seems the better way to do MySQL backup is to use the binlog. However, that binlog is huge! We seem to produce something like 10Gb per month. I'd like to copy the backup to somewhere off the server as I don't feel like there is much to be gained by just copying it to somewhere else on the server. I recently made a full backup which after compression amounted to 2.5Gb and took me 6.5 hours to copy to my own computer ... So that solution doesn't seem practical for the binlog backup.Should we rent another server somewhere? Is it possible to find a server like that really cheap? Or is there some other solution? What are other people's MySQL backup practices?
View 8 Replies View RelatedUbuntu Servers :: Mysql-admin Won't Schedule Backup But Will Manual Backup
Jan 19, 2010I have a scheduled backup to run on our server at work and since the 7/12/09 it has be making 592k files instead of 10Mb files, In mysql-admin (the GUI tool) I have a stored connection for the user 'backup', the user has select and lock rights on the databases being backed up. I have a backup profile called 'backup_regular' and in the third tab along its scheduled to backup at 2 in the morning every week day. If I look at one of the small backup files generated I see the following:
Code:
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version`
[code]....
It seems that MySQL can open and write to the file fine, it just can't dump
OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock
Jun 7, 2011I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)
Jun 2, 2010i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
Fedora :: Backup And Restore Of A Grub Mbr?
Feb 13, 2011One Laptop. One hard drive. Two OS's. Windows 7 is shot to hell from installing and uninstalling to much crap. Windows & WILL rewrite my MBR. How do I back up my far superior GRUB MBR and restore it over the wincrap MBR once I am done reinstalling Windoze?
View 6 Replies View RelatedGeneral :: Restore A Backup On Different Filesystems?
Sep 30, 2010I'm now using Ubuntu 10.04 with ext4 and for the second time in my life I experienced data loss (not for real: I got backups) and I'm assuming problems with the recent ext4 fs.
I want to restore all of my configurations (/etc and the like), data and home on reiserFS: is this possible? What to do in order to accomplish that?
Ubuntu :: How To Take Backup And Restore In GnuCash
Jun 27, 2010How to take Backup & how to do restore in GnuCash. I need to take backup of my all accounts & all transactions
View 1 Replies View RelatedUbuntu :: Restore Menu.lst From Its Backup?
Jul 24, 2010Im running ubuntu 10.04 and I recently had a little adventure whilst trying to disable KMS and deleted all the stuff out of the # kopt line and added the nomodeset thing.Now I crash to easybox everytime I try to boot, how do I restore the backup of said file that I noticed beside it in the folder. Also I saved one to my desktop.
View 7 Replies View RelatedSoftware :: Backup / Restore Script - For Svn?
Feb 13, 2009Do You have any good script to backup and restore Subversion ?
View 1 Replies View RelatedCentOS 5 :: How To Restore From Image Backup
Apr 21, 2011I have 4 different servers with exactly the same hardware. I set up one of them to have a centos install with all the basic stuff I'd like running on each one. I then created an image of the harddrive with the operating system, and stored it on an external drive. I used dd to copy the external image to one of the new machines. It worked fine, everything booted up as normal and with a few tweaks everything was great. The problem is that the drive is rather large (500gb) and it takes days for dd to copy it over. I decided to try a different route, I booted to a usb (using the linux distro on the ultimate boot cd pre-loaded with gparted). There are two partitions on the external drive, a small (100mb) partition which can easily be copied over with gparted, and the larger 480+gb lvm partition.
Gparted doesn't support lvm, so I used fdisk to create a new lvm partition on the new machine, and then pvcreate/vgcreate/lvcreate to re-create the same volume groups/logical volumes that are in the image on the external harddrive. I rsync'ed all the information over from LogVol00, and made the same swap partition LogVol01 (which took WAY less time). I disconnected the hard drive and renamed the volume group to VolGroup00 (initiall I named it differently, since linux doesn't like having the volume groups named the same). I can mount the LogVol00 partition and see all the files as they should be. But when I try and boot up, it doesn't even go to grub, I just end up with a blank screen and blinking cursor. How to make the drive bootable? Alternatively, a better strategy than using dd to restore this image??
Debian :: Backup Linux Installation And Restore On New HDD
Jun 10, 2015I have Lenovo IdeaPad z510 laptop.My HDD SMART status is currently "failure". As my laptop is under warranty I can return it to lenovo. So I want to backup as much data as possible (everything is readable). I currently have 3 operating systems: linux xubuntu 14.10, debian 8 and windows 8.1 (triple-boot?). I want to back up only my current debian installation. There are 3 partitions for debian: root (about 50GB), home (>200GB) and swap. I know that I can backup the whole partition using:
Code: Select alldd -if=/dev/sdaX -of=/locaton/of/backup -something
And create .tar file with the whole home directory.
how to restore it later. In /etc/fstab there are references to UUIDs, and as I understand, with new HDD these UUIDs would be different. And possibly the whole partition table would be different. And how would I restore GRUB?I can't make full image of my disk simply because I don't have disk to store it on.Is it possible to create backup on my current debian installation without actually making full HDD backup? Would it work if I would install debian on new disk, then from LiveCD overwrite it with my backup and modify /etc/fstab to match new partitions?
Fedora Installation :: Image Backup And Restore
Aug 27, 2009My laptop is Windows XP Fedora 11 dual boot. I am replacing it because of a defect. The original laptop is fairly new so I could simply start from scratch and setup everything again. But I was thinking there might be a way to do an image backup and restore. My new laptop will be identical to the old one
View 1 Replies View RelatedFedora :: Any Way To Backup And Restore All Downloaded Updates?
Feb 22, 2010I have fedora 12 (amd64) on desktop. I was wondering if there a way to backup and restore all my downloaded updates since installation?! In the same manner that debian has aptoncd. I am planning to migrate on all data to a new partition with clean install and then just move the updates there.
View 6 Replies View RelatedOpenSUSE Install :: Backup / Restore And GRUB 11.3 X86-64?
Nov 5, 2010I do regular full and incremental backups using dar. All disk volumes are labeled and mounted by label. There is no other operating system installed. I built a new system but due to having to RMA a disk, I built the openSUSE system on a disk from the backup cycle. This Maxstor disk has problems which is why it was moved into an external box and the backup system. I now have a replacement disk and wish to replace the Maxstor before it dies. I initially tried a disk to disk clone with clonezilla but this died complaining that a small target partition was smaller than the source partition. It had created the partition and the start and end sectors were identical. There are no problems with the new disk.
I decided that it would be a good opportunity to test a full system disk restore from the backups. I have in the past restored individual files and partitions but have never restored onto a bare boot disk. I have restored and labeled all 6 partitions. The partition containing / has been marked as active. /boot is included in the partition containing /. fstab is valid, menu.lst is valid, device.map needs editing but this is not a problem.
What do I need to do to make this disk bootable. I have looked through the GRUB documentation but if you try some standard GRUB commands in 11.3 you get messages saying don't do this use YAST. I have seen other suggestions ranging from trying to start the not supported system repair option to using dd to copy the MBR which seemed to trash the partitions in the users extended partition.
The YAST bootloader displays "boot from the root partition". I assume that this is currently what is happening rather than what YAST thinks might be a good idea for next time. I suspect that all I have to do is dd the first 512 bytes of the root partition. If this is the case I can add this to the backup process. While I automate backups I do not automate restores. Each restore tends to be different and I am not sure of the best way getting grub to work on a bare disk restore.
Ubuntu :: Restore Folders Out Of .tgz Backup File?
Feb 10, 2011I'm using ubuntu for a few weeks now and i created a backup script that can copy some folders into a .tgz file. Now i want to place back the folders to where they come from and overwrite the original folder. like the /home folder in the .tgz file overwrite the /home folder on my harddrive. I already tried to do this with: tar xvpfz filename.tgz. But after that the folders came in the same folders as the backupfile stands.
How can i do this the right way?
Ubuntu :: Backup And Restore Installed Copy Of 10.10?
Mar 19, 2011How to Backup & Restore Installed copy of my UBUNTU 10.10.If I create any ISO or Recovery CD /DVD, saves time to fresh install & update & install favorable software.I use Mobile to connect, works slow to download.
View 3 Replies View RelatedUbuntu :: Restore A TAR Backup To Virtual Machine?
Apr 9, 2011I'm trying to use this tutorial (URL...) to backup my Ubuntu 10.10 (ext3) operating system. I've successfully gotten it into a TAR file on my external hard-drive, but inside the archive are 2 folders: sda5 and media (/media/sda5/), sda5 ofcourse containing my operating system.
I run VMWare as my virtual machine software, but I could easily run Virtual Box if the situation calls for it. On my virtual machine I created an Extended partition, made a 2GB swap space and the rest is ext3 (ext3 space is mounted as sda1) (at this point, Swap is OFF) here is what I've tried to do inside the virtual machine to restore:
Code:
sudo -s
mkdir /media/FROM/
mkdir /media/TO/
mount /dev/sdb1 /media/FROM/
[Code]...
but instead it just creates the directory sda5 under media of the live ubuntu cd Do I need to CHRoot in these conditions? AFTER I get the files successfully into the virtual machine, how do I go about restoring the grub2 bootloader? Right now I haven't tried to restore grub on my hardware, but I would be interested in doing so. There are a vast immense amount of forum posts about this subject, but all are to mixed results. Can anybody tell me the absolute definite way to restore grub2 successfully, I don't want to try something if it's going to mess up my install, whether I've backed up or not.
for further reference, here is a link to the previous (failed) thread I made about this same subject:
[URL]...