MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)
All,
I am trying to delete a user created file from specified folder. This folder is using for my Team member (i.e, Public folder). For example,
$ ls -l
total 1336
-rw-rw-r-- 1 g_btha customer 2655 Dec 06 12:35 A_COL_1001
While deleting/moving this file I am getting the following... (3 Replies)
No help guys??? :(
Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file...
so the first move would be, to access the mysql interface right? hence...
#! /usr/bin/ksh
echo "Job Begin: " `date`
... (1 Reply)
Hello:
I made this mistake on my tru64 machine, I renamed a file from:
binary.errlog to binary.errlog(B3)
now when im tryign to move or delete the file Im getting:
# rm binary.errlog(B3)
ksh: syntax error: `(' unexpected
4# mv binary.errlog(B3) log
ksh: syntax error: `(' unexpected
... (3 Replies)
Hi ,
In a particular path the below mentioned three files has been created.
-rw-r--r-- 1 edwprod edw 0 Jun 5 00:06 -f%*lock.clock
-rw-r--r-- 1 edwprod edw 151 Jun 5 00:06 -f.log
-rw-r--r-- 1 edwprod edw 4 Jun 5 00:06 -f%conn_err.out
... (5 Replies)
hi friends,
i need to delete a file named "-vyxx-.0.sdct.txt"
i'm unable to use
"rm -vyxx-.0.sdct.txt"
jus give me your suggesstions
thanks in advance (5 Replies)
Hi,
I executed the query in mysql as
"select * into outfile "/tmp/result.out" from table_x;
which inturn wrote all the records in that table to file in /tmp directory.After this i tried to delete the file "/tmp/result.out", but can't able to do that.
Is there any way to achieve... (2 Replies)
Hi,
I have a folder A which contains files 1,2,3... I also have a file xyz under a diff folder B containg the entries 1,2,3...
I am trying to compare and delete the nonexisting ones from xyz using the below code:
QFILE=/B/xyz
cd A
ls -1 > /tmp/file1
for fname in `cat $QFILE`
do
if ... (4 Replies)
Hi Guys,
In one of my folders i have 10000 log files starting with sqlfile.....
Iam trying to delete the log files alone from the folder using for loop but i am getting an error
ksh: /usr/bin/ls: 0403-027 The parameter list is too long.
For loop i used
for i in `ls sqlfile*`... (4 Replies)
Hello all again,
How do you guys backup your MySQL databases?
I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Discussion started by: AimyThomas
2 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm)NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.
METHODS
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
SimpleUpdateFromSelect
Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch
data from the table that is updated.
DatabaseVersion
Returns the mysql version, trimming off any -foo identifier
CaseSensitive
Returns undef, since mysql's searches are not case sensitive by default
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT Name FROM mysql.time_zone_name;
Read docs about keeping timezone data up to date:
http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)