I always have this error with mysql
Can't create/write to file '/tmp/#sql_7042_0.MYI' (Errcode: 13)
the /tmp has been chmoded 1777. I installed mysql downloaded from rpm on www.mysql.com, version 5.0.51a 64bits for CentOS-5
one of my site shows this error
MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'
I checked space on the server is still 25 GB free,
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies View RelatedI seem to be having a problem where periodically the data in one file is getting corrupted. I haven't been able to figure out a pattern to it, so I wanted to run command by crontab that would create a copy of the file each day. To avoid overwriting previous backups the filename of each day's copy would have to be unique like...
cp filename filename-2008-07-03
Is there a way to include this year, this month, and this day variables in a linux command?
In my personal website at URL.... I have the top like 'index.php?pg=profile', 'index.php?pg=home' or 'index.php' (without any querystring), 'index.php?pg=diary' etc. I am looking to see if I can have .htaccess file which can make me create links like
index.php/
index.php
index.php/home
index.php/profile
index.php/diary
write an .htaccess for the same?
how to create Dump File for Apache Crash in Windows.We are using Apache for Reverse Proxy with OpenAM Module for Sign-in.Apache Version : 2.4.9.0...We are very frequently facing Apache Crash Issue.
Also in logs we do not get much information.when submitted logs to ForgeRock, they asked us to look into below error and provide Crash Dump.
[Sun Jun 15 23:00:10.153908 2014] [mpm_winnt:warn] [pid 2376:tid 424] (OS 64)The specified network name is no longer available. : AH00341: winnt_accept: Asynchronous AcceptEx failed.
[Sun Jun 15 23:02:21.609557 2014] [proxy_http:error] [pid 2376:tid 6544] (OS 10060)A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. : [client 10.XXX.XX.XX:XXXX] AH01095: prefetch request body failed to XX.XXX.XX.XX:XXX (teampark.sogeti.com) from XX.XXX.XX.XX (), referer: https://teampark.sogeti.com/blogs/roller-ui/authoring/weblog.do?method=create&weblog=VeckobrevIntegrationSyd&lang=sv_se
Display some text in a web browser from a file called text.txt
text.txt will have many lines and some of them I do not want users to be able to modify and overwrite.
config_item_1=user can edit
config_item_2=user should see but not edit (could be on any line)
config_item_3=user can edit
config_item_4=user can edit
The user has made their changes in the web browser and clicks submit. I then need this info to be saved as the text.txt file however some checking needs to be done first. Anything matching config_item_2 should be removed. This could be on any line. Anything not matching should be permitted and added.
I have a script and there are some modifications that I want to make
In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.
I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.
Should I use phpmyadmin or whats the correct way?
Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily
mysqldump -u usernam -p password dataname > file.sql
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
why this mysql command doesn't work on phpmyadmin on cpanel server.
Quote:
CREATE VIEW TEST AS SELECT * FROM COURSE
it give this error:
Quote:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW TEST AS SELECT * FROM COURSE' at line 1
how to achieve the following:
We have a dedicated server, on which we hosts about 15 sites. I am needing to:
Backup each site individually (all files)
Backup each Db associated with each site
FTP to our own in-house ftp server
I have been searching around all afternoon, and possible solutions to each point above are the following:
Iterate through each top level folder in, say /var/www/vhosts/ and tar each folder individaully
I have only been able to do a mysqldump the whole server, and have only found scripts into which you have to manually specify each db if i need separate backups for each one done
Not an issue, we currently have backups from a separate server running
Is it possible to set this all up in one, top-level cron job?
I have a server with many db on mysql 5
Any db contains 5 table with data
This data is processed by routine
Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"
The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..
what I can do about the following database error in mysql?
Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it
I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.
I am trying to increase my open file limit on my CentOS release 4.6 VPS.
I have tried modifying my /etc/security/limits.conf with the following:
@mysql soft nofile 4096
@mysql hard nofile 4096
@mysql soft sigpending 4096
@mysql hard sigpending 4096
Even is a mannual set it with "ulimit -n 4096 mysql" it will not stick.
Any ideas what I can do to get this limit increased permanently?
Customer has requested the following:
"Create a zend id for your machine." This is apparently for them to create a product key for their software and have to bind to it?!
I have never heard of this and have been unable to locate any information on it.
This is a Centos box with php 5.2.5 installed:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies
how to go about this or even what this is?
How to import mysql dump file to database by SSH?
How to import mysql database host to other host database by SSH?
Is it possible to export the MYSQL DB from an Hypervm backup file?
If possible,how to?
As I fail several times to restore it in Hypervm.
Recently,Mysql has been a problem that is going down.So,I have to restart Mysql Service everyday. You can see for further information at here
Quote:
ERROR
Couldn't connect to database.
Please contact admin about this err. Back
DETAIL
2002 : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
This is the error when i restart Mysql Service via SSH
Quote:
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL SUCCESS!
what i should do and give me a solution to kill this error
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?
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
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..
Rapidly growing error logs showing the same message
$ug-non-zts-20020429/ffmpeg.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//usr/local/lib/php/extensions/no-debug-non-zts-20020429/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
Using cpanel 11 / centos 4