Sponsored Content
Top Forums UNIX for Dummies Questions & Answers MySQL Database Missing on UNIX server. Possible to recover? Post 302928214 by zaxxon on Wednesday 10th of December 2014 03:08:59 AM
Old 12-10-2014
To make sure, I would check if mysql is still installed or maybe currently just not started.
You can call the mysql client and check where the DB files should reside:
Code:
mysql -u<yourusernameinhere> -p -e 'show variables where variable_name = "datadir"'

It should hopefully return the path where you can have a look into, if the files are still there.
When your DB is still there and you get your app online again, you should think about having backups more often and really update your environment soon!


Added Info:
- I am not sure if your support checked all this, together with if mysql can be started, if the DB can be connected and tables and data are there or not.
- There are companies, that offer to rescue data, but I am not sure about the costs and I assume that it can only be done if the parts on the disk have not been overwritten.

Last edited by zaxxon; 12-10-2014 at 07:17 AM.. Reason: added info
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

unix database server

hello , guys , im new to unix , just passed out my system admin certification from sun. i need to do few things at home , which are 1. ihave a unix box and windows box wired together using hub , i want to use internet from windows box . i have win98 ist edition , as well as win2000 server. kindly... (7 Replies)
Discussion started by: definate
7 Replies

2. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

3. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

4. SuSE

Recover dropped database

I have deleted a database. I restored it again with a backup. Now we lost some data of two days. Is it possible to restore this lost data? (5 Replies)
Discussion started by: Eastme
5 Replies

5. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies

6. Shell Programming and Scripting

Error in installing mysql on unix server

Hi , I am trying to install mysql but getting below error $# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) can anyone provide me this file 'mysql.sock' Thanks (6 Replies)
Discussion started by: aish11
6 Replies

7. Solaris

Recover Solaris 11 pkg database

Hi, I was messing with pkgsrc and wanted to start fresh so I manually deleted the /var/pkg directory on Solaris 11 :eek: (of course I was supposed to delete the /var/db folder instead)... Anyways... I've basically bricked the Solaris11 Package Manager. Do you know if there is any way to... (1 Reply)
Discussion started by: testers1717
1 Replies
safe_mysqld(1)							  MySQL database						    safe_mysqld(1)

NAME
mysqld_safe - start the mysqld daemon on Unix. SYNOPSIS
mysqld_safe [--basedir=path] [--core-file-size=#] [--defaults-extra-file=path] [--defaults-file=path] [--open-files=#] [--datadir=path] [--err-log=path] [--ledir=path] [--log=path] [--no-defaults] [--open-files=#] [--pid-file=path] [--port=#] [--socket=path] [--timezone=#] [--user=#] DESCRIPTION
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file. --basedir=path --core-file-size=# Size of the core file mysqld should be able to create. Passed to ulimit -c. --defaults-extra-file=path --defaults-file=path --datadir=path --err-log=path --ledir=path Path to mysqld --log=path --no-defaults --open-files=# Number of files mysqld should be able to open. Passed to ulimit -n. --pid-file=path --port=# --socket=path --timezone=# Set the timezone (the TZ) variable to the value of this parameter. --user=# NOTE
Note that all options on the command line to mysqld_safe are passed to mysqld. If you wants to use any options in mysqld_safe that mysqld doesn't support, you must specify these in the option file. SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqldump(1), mysql_fix_privilege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com). This software comes with no war- ranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme- dia.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 safe_mysqld(1)
All times are GMT -4. The time now is 09:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy