Database File Is Gone
May 15, 2008My wife accidentally deleted wordpress within fantastico
so i had to reinstall wordpress but my database file is gone
where does linux or fantastico keep deleted files
My wife accidentally deleted wordpress within fantastico
so i had to reinstall wordpress but my database file is gone
where does linux or fantastico keep deleted files
i found out that for the past 6 months ive been backup up all my MySQL databases into one big file. However, now that i actually need to restore a database, i can't find out how to actually restore 1 database out of this enormous file.
I can find the Mysql shell command to restore 1 database ... but it doesnt tell me if you need to have a 1 database dump file for this as well. It does not mention what happens if you execute that command on the big file containing all databases. Restoring all server databases would be a very bad thing.
How to import mysql dump file to database by SSH?
How to import mysql database host to other host database by SSH?
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
On server, it show detail below: .....
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
For starters im using mysql Server version: 5.0.32-Debian_7etch1-log Debian etch distribution.
What i did :
a) i run out of space on var partition, so i figured that i will copy my /lib/mysql to other partition (/mnt/hdb) and change only in my.cnf path to it.
b) I did so, and after launching mysql again i got several of this :
Could not retrieve from database: Incorrect information in file: './database/******.frm'
c) when i copy it back to my old location (and change back my : my.cnf) , same result errors
I cant lose my database:
I'm build Plesk Panel for Linux and Presence Builder, I don't want my user can upload their website to hosting via File Manager. How can I do it...
View 2 Replies View RelatedSay I have 2 websites and they all use file.php which is located on mainserver.com/file.php.
I want to use the file like this:
website1.com/file.php
website2.com/file.php
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.