02-05-2010
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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)
Discussion started by: _hp_
8 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: nvkuriseti
3 Replies
3. Shell Programming and Scripting
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)
Discussion started by: 12yearold
1 Replies
4. UNIX for Dummies Questions & Answers
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)
Discussion started by: aladdin
3 Replies
5. UNIX for Dummies Questions & Answers
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)
Discussion started by: anupam_jash
5 Replies
6. UNIX for Advanced & Expert Users
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)
Discussion started by: rprajendran
5 Replies
7. Web Development
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)
Discussion started by: DILEEP410
2 Replies
8. Shell Programming and Scripting
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)
Discussion started by: swasid
4 Replies
9. Shell Programming and Scripting
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)
Discussion started by: mac4rfree
4 Replies
10. Programming
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
notedb::mysql
NOTEDB::mysql(3pm) User Contributed Perl Documentation NOTEDB::mysql(3pm)
NAME
NOTEDB::mysql - module lib for accessing a notedb from perl
SYNOPSIS
# include the module
use NOTEDB;
# create a new NOTEDB object (the last 4 params are db table/field names)
$db = new NOTEDB("mysql","note","localhost","username","password","note","number","note","date");
# get a single note
($note, $date) = $db->get_single(1);
# search for a certain note
%matching_notes = $db->get_search("somewhat");
# format of returned hash:
#$matching_notes{$numberofnote}->{'note' => 'something', 'date' => '23.12.2000 10:33:02'}
# get all existing notes
%all_notes = $db->get_all();
# format of returnes hash like the one from get_search above
# get the next noteid available
$next_num = $db->get_nextnum();
# recount all noteids starting by 1 (useful after deleting one!)
$db->set_recountnums();
# modify a certain note
$db->set_edit(1, "any text", "23.12.2000 10:33:02");
# create a new note
$db->set_new(5, "any new text", "23.12.2000 10:33:02");
# delete a certain note
$db->set_del(5);
# turn on encryption. CryptMethod must be IDEA, DES or BLOWFISH
$db->use_crypt("passphrase", "CryptMethod");
# turn off encryption. This is the default.
$db->no_crypt();
DESCRIPTION
You can use this module for accessing a note database. There are currently two versions of this module, one version for a SQL database and
one for a binary file (note's own database-format). However, both versions provides identical interfaces, which means, you do not need to
change your code, if you want to switch to another database format.
Currently, NOTEDB module is only used by note itself. But feel free to use it within your own project! Perhaps someone want to implement a
webinterface to note...
USAGE
please see the section SYNOPSIS, it says it all.
AUTHOR
Thomas Linden <tom@daemon.de>.
perl v5.10.1 2011-02-12 NOTEDB::mysql(3pm)