2

I have accidentally typed in webserver terminal following command:

sudo apt-get remove apache2 php* mysql* -y

Can i rescue my database tables, without a backup? I know that, for instance, apache does not remove anything (configs) from system on removal, but what about mysql?

6
  • 4
    Removing mysql packages should not have affected your mysql data files. Jan 28, 2016 at 17:46
  • i know that each time you run "apt-get install mysql-server" it creates new database with new root password.
    – Croll
    Jan 28, 2016 at 17:48
  • Usually apt-get remove is supposed not to touch any configuration files while uninstalling packages. But I don't use mysql and can't tell you if that one has anything special on it...
    – Byte Commander
    Jan 28, 2016 at 18:29
  • Then you should not write this ( i noticed before that i know it creates new database in "install" that's why i am asking and not trying "install" again). Thanks.
    – Croll
    Jan 28, 2016 at 18:35
  • You might want to have a look in the directory /var/lib/mysql/ to check if the databases files are still there. Jan 29, 2016 at 8:39

2 Answers 2

3

apt-get does not delete data files when you remove a package. It might remove configuration files if you instruct it to purge (but that's not default behavior).

By default, mysql databases reside in /var/lib. Your dbs should be there.

2

You still can fetch for your database files within:

/var/lib/mysql

To access a database_name_1 you previously created, you'll find its path as:

/var/lib/mysql/database_name_1

(you'll need su permissions obviously)

2
  • Good. But how can i restore it, if "install" creates new database?
    – Croll
    Jan 29, 2016 at 18:24
  • you know the location: so you can copy those DB files wherever you want to save them. Later if you install LAMP, you can import those DB files without needing to recreate them again
    – user284234
    Jan 29, 2016 at 18:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .