Sponsored Content
Full Discussion: Restore MySQL backup
Top Forums Web Development Restore MySQL backup Post 302819191 by marek on Monday 10th of June 2013 12:12:19 PM
Old 06-10-2013
Thank you radoulov!


ooops! This is a good idea! BUT where is this error log?

Code:
sudo find . -iname "*.log" -print
sudo find . -iname "*error*" -print

does not help (searching in /usr/local/mysql-5.6.11-osx10.7-x86_64). Sorry for this beginner question! And the system.log in /var/log/ does not tell anything of mysql server ...

marek

ps: I tried mysqlaccess like follows:

Code:
mysqlaccess -h localhost --user=webdev --password=webdevpass --db=webdb
mysqlaccess Version 2.06, 20 Dec 2000
...
Sorry,
An error occured when trying to connect to the database
with the grant-tables:
* Maybe YOU do not have READ-access to this database?
* If you used the -U option, you may have supplied an invalid username?
  for the superuser?
* If you used the -U option, it may be possible you have to supply
  a superuser-password to, with the -P option?
* If you used the -P option, you may have supplied an invalid password?

And

Code:
mysqlaccess -h localhost -U --password=XXXX --db=webdb
mysqlaccess: No match.

Does this help more as information?
 

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
ONEDB(1)					  onedb(1) -- OpenNebula database migration tool					  ONEDB(1)

NAME
onedb This command enables the user to manage the OpenNebula database. It provides information about the DB version, means to upgrade it to the latest version, and backup tools. OPTIONS
-f, --force Forces the backup even if the DB exists -b, --backup file Use this file to store SQL dump -v, --verbose Verbose mode -h, --help Show this message -V, --version Show version and copyright information -s, --sqlite file SQLite DB file -S, --server host MySQL server hostname or IP. Defaults to localhost -P, --port port MySQL server port. Defaults to 3306 -u, --username user MySQL username -p, --password pass MySQL password. Leave unset to be prompted for it -d, --dbname dbname MySQL DB name for OpenNebula COMMANDS
o backup [output_file] Dumps the DB to a file specified in the argument valid options: force o version Prints the current DB version. Use -v flag to see also OpenNebula version o history Prints the upgrades history o restore [backup_file] Restores the DB from a backup file. Only restores backups generated from the same backend (SQLite or MySQL) valid options: force o upgrade [version] Upgrades the DB to the latest version where <version> : DB version (e.g. 1, 3) to upgrade. By default the DB is upgraded to the latest version valid options: force, backup ARGUMENT FORMATS
o file Path to a file o range List of id's in the form 1,8..15 o text String April 2012 ONEDB(1)
All times are GMT -4. The time now is 09:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy