1)i want to delete a folder in /var/lib/mysql,
when i use "ls" to check ,it shows with (space)foldername,
i use rm -rf ./foldername, it failed,
and i use rm -rf ./(space)foldername, oh no,all the files in the /var/lib/mysql are gone,
2)i do not have the backup files of the folder at all.
3)how can i rebuild the system files of the mysql server with a smooth way?
My server HDD got corrupted. My server provider mount a new HDD for me, and put the OLD HDD as secondary drive.
This is what they emailed me:
[root@ns1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda3 149G 3.7G 138G 3% /
/dev/hda1 99M 17M 77M 19% /boot
none 498M 0 498M 0% /dev/shm
/usr/tmpDSK 485M 13M 447M 3% /tmp
/tmp 485M 13M 447M 3% /var/tmp
/dev/hdc3 149G 23G 119G 16% /backup
I have a forum data (files and database) that is still on the old HDD, I hope to retrieve it.
May I know how can I access to the data?
I tried SSH, can only go till /dev/, then don't know what to do.
What is the command in SSH that I should type in order to go to the 2nd HDD? How can I retrieve the database and files to my new HDD?
Does anyone know of any services that can help retrieve data from a crashed server. The server is managed but the support are saying that they are having problems retriving the data. The server had an os reload and they can't slave the old disk.
View 2 Replies View RelatedDoes my linux server keep copies of deleted email messages? If so how can I go about retrieving them?
View 2 Replies View RelatedIs there any host out there that is compliant (say to PCI type standards) that would allow me to create a online form that will be used to fill out a rental application?
These applications will need to have the SSN / Drivers Lic. of the user filling them out, as well as CC info to be processed.
The CC info does not need to be stored, just processed for the application fee.
The SSN / DL need to be stored in such a manner that the realty agents can retrieve the form the users filled out so they can then use it to submit the application for whatever purposes.
(I would imagine it also needs to be stored so that if they ever get called by the GOVT for information about certian tenants they can retrieve the forms if necessary.
If i do this for the client, I will of course have a contract signed that basically makes sure that I am not liable if the system is breached, as i don't want the host i use for the website part itself to be storing this information at all.
I am kind of looking for a API like setup such as a merchant account, but one that allows the storing / retrieval of SSNs / DL.
I'm trying to retrieve some files from another hard disk and I get weird characters.. Exemple:
("location:index.php"); becomes ("lOcation:aNdex.php");
Initially I was able to connect via FTP. Then all of a sudden I started getting 550 SSL/TLS required on the control channel. Why did it suddenly required SSL/TLS when I did not do anything extra?
Now when I'm trying to connect via FTPES using FileZilla (tried both active and passive) on Linux Mint Debian, I'm getting the error below. I'm really stumped. I have tried to Allow incoming from all on port 49152-65534/tcp via Plesk firewall, but still no go.
The worst thing now is, I can't even get FTP to work anymore. Of course I would prefer to have TLS working.
Status:Connection established, waiting for welcome message...
Response:220 ProFTPD 1.3.5 Server (ProFTPD) [206.106.213.243]
Command:AUTH TLS
[Code]....
I enabled plesk firewall to my ip now I cant seem retrieve directory listing. I've done the same with ssh that works fine.
Response:230 User logged in
Command:OPTS UTF8 ON
Response:200 UTF8 set to on
Status:Connected
Status:Retrieving directory listing...
Command:PWD
Response:257 "/" is the current directory
Command:TYPE I
Response:200 Type set to I
Command:PASV
Response:227 Entering Passive Mode
Command:MLSD
Error:Connection timed out
Error:Failed to retrieve directory listing
The Plesk panel indicates that the Spam folder can be retrieved using an email client. We are using Outlook 2013 and can not figure out a way to make this happen. We can see the Spam folder using Webmail, but the contents never shows up in Outlook...
View 1 Replies View RelatedI am trying to create a new domain and I am getting this error
Error: vhostmng failed: Access is denied. (Error code 5) at retrieves attributes for file or directory D:PleskVHOSTS
s1.caboodledns.com
achaelwillment.com
(Error code 1)
I have done permission repairs via the plesk tool on the server but I still get this error. What user needs what permissions to fix this?
when I run this command show me some errors what should I do?
# yum update
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
* plesk: www.atomicorp.com
* extras: mirrors.portafixe.com
* updates: mirrors.portafixe.com
* base: mirrors.portafixe.com
* addons: mirrors.portafixe.com[url]
[Errno 14] HTTP Error 404: Not Found
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: plesk. Please verify its path and try again
I have Linux with Plesk.
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 keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
I got an error in ftp.
Command:MLSD
Response:150 Accepted data connection
Response:226-ASCII
Response:226-Options: -a -l
Response:226 24 matches total
Error:Connection timed out
Error:Failed to retrieve directory listing
I'm working on a script to notify customers of security issues with their accounts.
I've got the script half working but want to email them if issues are found with their account.
So far i've found no way to retrieve the email address from whm of the account holder that they setup when they signed up, is there a way to do this? the script runs on the server itself.
I am using fedora 7 and when i fire "yum localinstall dovecot-*" it gives error.
Could not retrieve mirrorlist [url]Error was [Errno4] IOError:< urlopen Error (110,'connection timed out')> Error:cannot retrieve repository metadata (Repomd.xml) for repository:fedora
i have checked all the setting but nothing.
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
Which server for mysql only?
This is sort of a continuation to this thread here
Based upon the screenshots I provided below. What server would best suit my needs. I need this server to be able to handle the mysql usage and server load.
This server will be only for mysql. The rest of the site (html, videos) will be hosted on a different server.
If you think these servers are not enough for this please let me know any suggestions you have pertaining to server specifications.
Server 1:
Dual Core
Core 2 Duo E4500 2.2Ghz 2MB Cache
500 GB SATA II Hard Drive
2 GB DDR2 SDRAM
Server 2:
Dual Core
Core 2 Duo E8400 3.0Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
Server 3:
Quad Core
Core 2 Quad Q9300 2.5Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
i have install a durpal on my centos server(php5,mysql5,suphp),
for some feature,
i get a lof of error like
---------
Warning: MySQL server has gone away query
---------
i try to google to find some solution,
but the issue is still here,
do you know any problem make this?
I have an older script that works well on the config below. Can anybody know where I find such boxes?
PHP version 4.4.7
MySQL version 4.1.22-standard-log
My site is getting big and my server can barely hold all the mysql processes.
Once I had a similar problem with bandwidth because my media files were eating quite a big chunk of it. So, I just bought a media server and changed some HTML to hotlink all the media from the media server. I would like to do something like that with my MySQL databases, to get some load off my main server.
Should I get my current host to cluster another server for mysql? Or can I use a completely different server (from a different webhost) for mysql?
I have A and B server, i linked a cross cable in both server second ethernet port.
I have A as 10.0.0.1 (eth02) and B as 10.0.0.2 (eth02).
Both can ping to each other.
Now how could i setup 10.0.0.2 mysql to accept connections from 10.0.0.2?
The idea is to setup in A server to be able to backup mysql or write to B server.
I have an issue with one of my scripts,it wont run on mysql 5.x
if its possible to run mysql 4.x and 5.x on the same server?