I'm using ISPconfig (With Fedora core 4 Linux) for my Web Control panel. I've problem with my staff. he is make disabled mysql featured and empty trash on tools panel. So .. my database with name web**_db1 was gone..... I'm using System recovery for Linux.. but cannot find that's file (. How can i recover my database ?? .. please help me.... Thanks for all.
What do you mean by system recovery for linux? How do you generally do a Backup of all your mysql Databases?
I mean data recovery software, like disk doctors. Realy .. i have not backup for this .... I know that's stup*d Can i get data it again ??
The mysql database files are stored in /var/lib/mysql/web**_db1 The files inside the folder are named like that tables that were in the database. Example for a table named "test": test.MYD test.MYI test.frm if you used MyISAM databases.
Yups I know that.. Thanks for Information. But for mya question is. If i'd remove database from Ispconfig, and my database was gone. can i recover that with Linux data recovery software ?? Thanks
Tip for you. Yes that's a fact. Maybe it is a good idea to make backup automaticly of all your MySQL databases by using 'Zmanda Recovery Manager for MySQL' for example. Then you always have a backup of your databases!
I am using this simple shellscript, attaching a timestamp to each db backup file and deletes files older than a given age in minutes, so you may call that script as often as you wish. Code: #! /bin/sh DB_USR=root DB_PWD=yourrootpassword BDIR=/root/mysql_backup #backupdir TIME_PREF=`date +%Y%m%d-%H%M` #format of the generated timestamp AGE=720 #in minutes #Delete files older than agedays LIST=`find $BDIR/* -cmin +$AGE` for i in $LIST do echo "Removing $i" rm $i -f done # Backup all Databases for i in `echo SHOW DATABASES | mysql -N --user=$DB_USR --password=$DB_PWD`; do echo Dump $i database to $BDIR/$TIME_PREF.$i.sql.gz mysqldump -u $DB_USR --password=$DB_PWD --databases $i --opt > $BDIR/$TI ME_PREF.$i.sql gzip -f $BDIR/$TIME_PREF.$i.sql done
