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
MYSQLD(8)						       MySQL Database System							 MYSQLD(8)

NAME
mysqld - the MySQL server SYNOPSIS
mysqld [options] DESCRIPTION
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files. When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients. The mysqld program has many options that can be specified at startup. For a complete list of options, run this command: shell> mysqld --verbose --help MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that provide information about its operation. You can monitor these status variables to access runtime performance characteristics. For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, "The MySQL Server". For information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL. COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc. 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
Sun Microsystems, Inc. (http://www.mysql.com/). MySQL 5.1 04/06/2010 MYSQLD(8)
All times are GMT -4. The time now is 05:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy