Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Restore MySQL backup
Top Forums Web Development Restore MySQL backup Post 302819027 by marek on Monday 10th of June 2013 06:13:12 AM
Old 06-10-2013
Restore MySQL backup
Hello all!


First posting here! So be patient with me.

I made a clean install with MacOS 10.8 and need to restore my Databases from my external backup drive. Apparently it is not possible, to create the MySQL user and password as before, and simply drag the databases from /backup/usr/local/mysql-5.5.13-osx10.6-x86_64/data/ into /usr/local/mysql-5.6.11-osx10.7-x86_64/data/

I checked the owners _mysql:wheel the permissions everything. Everything is as before on the backup. (off topic question: why is there an underscore before _mysql?)

When I log in as root:

Code:
mysql -u root -h localhost -p
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| webdb              |
+--------------------+
mysql> USE webdb
mysql> SHOW TABLES;
+-------------------+
| Tables_in_webdb   |
+-------------------+
| anz_werte         |
| einsendung        |
...
+-------------------+

But I am unable to see what is inside the tables with:

Code:
mysql> SELECT * FROM todo;
ERROR 1146 (42S02): Table 'webdb.todo' doesn't exist

Same when I log in as user webdev ...

Hope this first question was clear enough.


Best greetings from Munich

marek
Last edited by radoulov; 06-10-2013 at 07:26 AM..
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT LINUX

ndb_print_backup_file

NDB_PRINT_BACKUP_(1)					       MySQL Database System					      NDB_PRINT_BACKUP_(1)

NAME

       ndb_print_backup_file - print NDB backup file contents

SYNOPSIS

       ndb_print_backup_file file_name

DESCRIPTION

       ndb_print_backup_file obtains diagnostic information from a cluster backup file.
	       Usage

	   ndb_print_backup_file file_name

       file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup
       directory. These files are found in the data node's backup directory under the subdirectory BACKUP-#, where # is the sequence number for
       the backup. For more information about cluster backup files and their contents, see Section 17.5.3.1, "MySQL Cluster Backup Concepts".

       Like ndb_print_schema_file and ndb_print_sys_file (and unlike most of the other NDB utilities that are intended to be run on a management
       server host or to connect to a management server) ndb_print_backup_file must be run on a cluster data node, since it accesses the data node
       file system directly. Because it does not make use of the management server, this utility can be used when the management server is not
       running, and even when the cluster has been completely shut down.
	       Additional Options

       None.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014						      NDB_PRINT_BACKUP_(1)
All times are GMT -4. The time now is 09:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy