Restore MySQL backup


 
Thread Tools Search this Thread
Top Forums Web Development Restore MySQL backup
# 8  
Old 06-12-2013
Hi marek,
if you're able to bring up the instance with the old version and everything's working fine,
follow the upgrade procedure on dev.mysql.com.
# 9  
Old 06-13-2013
Here I am again. Still struggling with the same problem. Here my Shell session with some comments; hope this is not too longish for this forum.


mysqldump with the former MySQL 5.5. I remove the link to the new MySQL and link to the old one:


Code:
cd /usr/local/
sudo rm mysql
sudo ln -s mysql-5.5.13-osx10.6-x86_64 mysql
ls -l
lrwxr-xr-x    1 root  wheel    27 Jun 13 18:54 mysql@ -> mysql-5.5.13-osx10.6-x86_64

I am now restarting the MySQL server (the old one). Now the mysqldump ...

Code:
mysqldump -u root -p /usr/local/mysql-5.5.13-osx10.6-x86_64/data/webdb ~/Desktop/dump.sql
Enter password: 
-- MySQL dump 10.13  Distrib 5.5.13, for osx10.6 (i386)
--
-- Host: localhost    Database: /usr/local/mysql-5.5.13-osx10.6-x86_64/data/webdb
-- ------------------------------------------------------
-- Server version	5.5.13

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Got error: 1049: Unknown database '/usr/local/mysql-5.5.13-osx10.6-x86_64/data/webdb' when selecting the database

To be sure which mysqldump I am using:

Code:
which mysqldump
/usr/local/mysql/bin/mysqldump
[Mareks-MacBook-Pro:/usr/local] mstep% mysqldump --version
mysqldump  Ver 10.13 Distrib 5.5.13, for osx10.6 (i386)

I repeat the same with the mysqldump of the new installation (MySQL 5.6). With the same result. I am probably unaware of something obvious.
# 10  
Old 06-13-2013
Sorry for my confusion, but why are you running this command:

Code:
mysqldump -u root -p /usr/local/mysql-5.5.13-osx10.6-x86_64/data/webdb ~/Desktop/dump.sql

.. instead of:

Code:
mysqldump -u root -p webdb > ~/Desktop/dump.sql

??
# 11  
Old 06-13-2013
Thanx! Neo!

Now finally I have it on my Desktop Smilie I forgot the '>'

And now I did:

Code:
mysql -u root -p < ~/Desktop/dump.sql

And it's working! Uff! Thank you radoulov and neo for your patience!


marek
# 12  
Old 06-13-2013
Great! FYI.. for the future, this command:

Code:
mysql -u root -p < ~/Desktop/dump.sql

.. should more-than-likely be this command

Code:
mysql -u root -p webdb < ~/Desktop/dump.sql

# 13  
Old 06-13-2013
Yes I made an error with copy and paste. A little resumé for everybody. To upgrade from mysql-5.5 to mysql-5.6 and import the tables do following commands in your shell:

Code:
shell> mysql_admin -u root -p shutdown
password:
shell> cd /usr/local/
shell> sudo rm mysql
shell> sudo ln -s mysql-5.5.13-osx10.6-x86_64 mysql
shell> ls -l #is 'mysql' linking to the old version?
shell> sudo mysqld_safe
shell> Cntr + Z
shell> bg
[1]    sudo mysqld_safe & # Now the old MySQL server is running
mysqldump -u root -p webdb > ~/Desktop/dump.sql
shell> mysql_admin -u root -p shutdown
shell> sudo rm mysql
shell> sudo ln -s mysql-5.6.11-osx10.7-x86_64 mysql
shell> ls -l # is 'mysql' linked to the new version?
shell> sudo mysqld_safe
shell> Cntr + Z
shell> bg
[1]    sudo mysqld_safe & # now the new MySQL server is running
mysql -u root -p webdb < ~/Desktop/dump.sql
Enter password:

Hope this script receipt will help some other people out there.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Backup / Restore

Hi, I need to back up a RH file system (96G). The files are oracle .dbf format some of which are 5G in size. I know that tar has got a size restriction of 2G so I cannot use this. Can anyone recommend an alternative way of backuping up this FS? I have been looking at dump but this... (6 Replies)
Discussion started by: Duffs22
6 Replies

2. AIX

Backup and restore

Hi experts, i got a question. i have a production server with two Volume Group(VG) which are rootvg and datavg. Both of these VGs are 256 PP SIZE. On Disaster Recovery Server (DR server) contains two empty hardisks for restoring rootvg and datavg from production server. This two hardisks are... (7 Replies)
Discussion started by: polar
7 Replies

3. Shell Programming and Scripting

Backup and restore in unix

Hello everybody, i am trying to make a script in UNIX to backup some compressed files to a tape drive. The thing is that i cannot use cpio command because some of these files are greater than 2GB. so i think the only solution left is backup command. to restore the files i should use the... (6 Replies)
Discussion started by: omonoiatis9
6 Replies

4. Shell Programming and Scripting

Backup/restore scripts

hi people i am in need of some assistance here hoping to star a linux course in january to wanted to get some experiance before starting so got a hold of some old assessments from a mate at college so just working through them in my spare time for the past 8 weeks or so and this is the final ? that... (2 Replies)
Discussion started by: boabbyrab
2 Replies

5. AIX

How to restore from mksysb backup

system is not booting ... i want to restore from mksysb backup. (2 Replies)
Discussion started by: AIXlearner
2 Replies

6. HP-UX

Backup Tape Restore?

I am trying to do a restore on a backup tape (DDS2) and am having a little trouble. For one, I dont know how the tape was made, whether is was tar, cpio, dump..etc. Anyone know how to restore a tape without knowing the format of the backup? (5 Replies)
Discussion started by: bake255
5 Replies

7. HP-UX

F-Backup restore

Hello! i have a blank harddrive and a complete tape backup of the workstation. the backup is made with F-Backup. Now my question is: how can i restore my workstation? thanks for every idea! paul tittel hup-si (3 Replies)
Discussion started by: paultittel
3 Replies

8. AIX

Backup and restore

I have several H80 machines, all with AIX 4.3.3. On these machines I have mksysb running for rootvg backups and savevg for non-rootvg backups. I'm trying to get a list of files on the tapes, but I can't seem to do it with tar for the mksysb images. I keep getting the directory checksum errors?... (3 Replies)
Discussion started by: uXion
3 Replies

9. Solaris

Backup / restore

Hi.... everyone could help me to understand how to do a backup of my servers .. operating systems is sun solaris 8 . I have some question about .... 1) Is better backup phisical disk or partition ??? i sow the command is ufsdump 0cfu /expbck/bcksunver/c0t0d0s5 dev/dsk/c0t0d0s5 to... (4 Replies)
Discussion started by: tt155
4 Replies

10. HP-UX

HP-UX Filesystem backup/restore?

:confused: Hi Guys, I'm not new to UNIX but I am new to HP-UX. I have a proven backup and restore procedue using cpio on Solaris, however, the filesystem structure appears to be different on HP. Can anybody help me with the following questions? 1) What is the best method for performing a... (7 Replies)
Discussion started by: mybeat
7 Replies
Login or Register to Ask a Question